June 18, 2013

Post: MySQL Users Conference Presentation Proposals

October 24, 2007 By 12 Comments

… I would be able to show that to organizers to help with decision. Also let me know if you have submitted similar talk as…. Practical MySQL Variables Tuning This session takes practical approach to MySQL variable tuning. Instead of giving you theoretical guesses on what would be right variable values…

Filed Under: Events and Announcements Tagged With:

Post: MySQL: what read_buffer_size value is optimal ?

September 17, 2007 By 25 Comments

… should set this variable to some high value. Sample my.cnf values on large memory sizes recommend 1M settings and MySQL built-in… enough time to come up with good explanation. It could be OS has to split large requests into multiple ones submitting them to device… to mention tables with fragmented rows when IO pattern can be a lot different. The degree of parallelizm is another important variable…

Filed Under: Benchmarks, Insight for DBAs Tagged With:

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

… what comes back: mysql: SET GLOBAL innodb_ft_server_stopword_table=’test/innodb_myisam_stopword’; ERROR 1231 (42000): Variable ‘innodb_ft_server_stopword_table’ can’t be set to the value of ‘test/innodb_myisam… those worked. Also, trying to set innodb_ft_user_stopword_table produced the same error. I submitted a bug report (68450), and…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: SHOW INNODB STATUS walk through

July 17, 2006 By 40 Comments

… learn from SHOW INNODB STATUS output and how to use this info to improve MySQL Performance. To start with basics SHOW INNODB STATUS is… is done by adjusting innodb_thread_sleep_delay variable. Value is specified in microseconds. mysql tables in use 1, locked 0 is… values for any of these variables is indication of IO bound workload. Note however – IO requests submited by threads executing requests are…

Filed Under: Insight for DBAs Tagged With:

Comment: MySQL Users Conference Presentation Proposals

October 24, 2007 By 12 Comments

… “Practical MySQL Variable Tuning” suppose to show the numbers and tell you which variable sizes are good and why. I think I tried to submit general performance tuning methodology session couple of times but it was not accepted. Though may be it is worth to…

Filed Under: Events and Announcements Tagged With:

Comment: Returning to InnoDB scalability

August 7, 2006 By 42 Comments

…: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion…: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/mysql/en/Forcing_recovery.html InnoDB: about forcing recovery… of memory Hope that’s ok; if not, decrease some variables in the equation. 060804 21:29:29 InnoDB: Database was…

Filed Under: Insight for DBAs Tagged With: , ,

Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6

February 21, 2013 By 6 Comments

…,i add wsrep_cluster_address=gcomm:// to fill it ,the mysql server will not running [root@mysql1...05 [Note] WSREP: wsrep_start_position var submitted: ’00000000-0000-0000-0000-000000000000:-1′ …variables in the equation. Thread pointer: 0×0 Attempting backtrace. You can use the following information to…

Filed Under: MySQL Tagged With: , , , , , ,