June 18, 2013

Post: MySQL Users Conference Presentation Proposals

… 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…

Post: MySQL: what read_buffer_size value is optimal ?

… 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

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

… 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…

Post: SHOW INNODB STATUS walk through

… 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…

Comment: MySQL Users Conference Presentation Proposals

… “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

Comment: Returning to InnoDB scalability

…: 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…

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

…,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