June 18, 2013

Post: Percona Server for MySQL 5.5.30-30.2 now available

April 10, 2013 By 10 Comments

… –innodb-optimize-keys option it produced invalid SQL for cases when there was an explicitly … variable. Bug fixed #1135097 (George Ormond Lorch III). Fixed the upstream bug #62578 which caused MySQL … be lost. Bug fixed #989253 (Alexey Kopytov). Warning about the Percona Toolkit UDFs was omitted …

Filed Under: MySQL

Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue

April 24, 2013 By Leave a Comment

… –innodb-optimize-keys option it produced invalid SQL for cases when there was an explicitly … variable. Bug fixed #1135097 (George Ormond Lorch III). Fixed the upstream bug #62578 which caused MySQL … be lost. Bug fixed #989253 (Alexey Kopytov). Warning about the Percona Toolkit UDFs was omitted …

Filed Under: MySQL, Percona Software

Post: Ultimate MySQL variable and status reference list

January 8, 2011 By 4 Comments

…MySQL manual, especially the option and variable reference table. But just as frequently, I want to look up blog posts on variables…warning…

Filed Under: Insight for DBAs, MySQL

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…warning (39.73 sec) Records: 0 Duplicates: 0 Warnings: 1 mysql> show warnings; +———+——+————————————————–+ | Level | Code | Message | +———+——+————————————————–+ | Warning…variables…

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

Post: Replication checksums in MySQL 5.6

February 15, 2013 By 3 Comments

…sql_verify_checksum variable. Let’s first disable them: slave1 [localhost] {msandbox} ((none)) > set global slave_sql…on this slave. Great! Now we’re warned that something went wrong. It’…mysql-bin.000001′ at 2793, the last event read from ‘./mysql-bin.000001′ at 2793, the last byte read from ‘./mysql…

Filed Under: MySQL Tagged With: , , ,

Post: Announcing Percona XtraBackup 2.0.4

December 4, 2012 By 2 Comments

…-timeout was reached when using the safe-slave-backup option, SQL_THREAD was left in stopped state causing the slave thread… it before terminating with a timeout error and starting the SQL_THREAD only if it was running initially. Bug fixed #1037379… would print a warning message during the prepare stage about innodb_file_io_threads being deprecated, even if the variable wasn’t…

Filed Under: MySQL

Post: Percona Server 5.1.58-12.9

August 17, 2011 By 2 Comments

… across machine restarts. The configuration variables for my.cnf have been kept for compatibility and warnings will be printed for the deprecated… network error and stopping the Slave SQL thread. Bugs Fixed #813587 / #51196 and #61790 in MySQL (Alexey Kopytov). Uninitialized values in the…

Filed Under: MySQL, Percona Software

Post: Can MySQL temporary tables be made safe for statement-based replication?

May 26, 2008 By 8 Comments

… a warning that …mysql-bin.000006 Slave_IO_Running: No Slave_SQL_Running: No …… omitted ……… slave1 > start slave until master_log_file=’mysql…mysql-bin.000007 …. omitted …….. Exec_Master_Log_Pos: 207 slave1 > show status like ‘%temp%’; +————————+——-+ | Variable…

Filed Under: Insight for DBAs Tagged With:

Post: The two even more fundamental performance metrics

May 5, 2011 By 6 Comments

… words, there will be a steady but variable “white noise” of incoming requests, and most… a bit longer. This is common in MySQL servers I work with when they’re…graph over time, as a performance early warning? Perhaps there is. I won’t … for example? With the text of the SQL in hand, we might be able …

Filed Under: MySQL

Post: Improved InnoDB fast index creation

November 6, 2011 By 4 Comments

…by the expand_fast_index_creation system variable which is OFF by default. Let’…Warnings: 0 mysql> SET expand_fast_index_creation=ON; Query OK, 0 rows affected (0.00 sec) mysql….sql $ mysqldump -uroot test –innodb-optimize-keys > dump_optimized.sql $ time mysql -uroot test < dump_unoptimized.sql …

Filed Under: Benchmarks, Insight for DBAs, MySQL
« Older Posts