… #1104977 (Ignacio Nin). Running the DDL statement while variable innodb_lazy_drop_table was enabled could cause assertion failure. Bugs fixed #1086227… fix for unnecessary log_flush_order_mutex acquisition. Bug fixed #1163262 (Alexey Kopytov). When mysqldump was used with –innodb-optimize-keys and…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… #1104977 (Ignacio Nin). Running the DDL statement while variable innodb_lazy_drop_table was enabled could cause assertion failure. Bugs fixed #1086227… fix for unnecessary log_flush_order_mutex acquisition. Bug fixed #1163262 (Alexey Kopytov). When mysqldump was used with –innodb-optimize-keys and…
Post: How fast is FLUSH TABLES WITH READ LOCK?
April 24, 2010 By 30 Comments
… | localhost | test | Query | 62 | Flushing tables | flush tables with read lock | | 6 | root | localhost | test | Field List | 35 | Waiting for table | | | 7 | root | localhost | test… that “Flushing tables” is a misnomer — connection 5 is not flushing tables yet. It’s waiting to get the lock. Flushing tables After the FLUSH TABLES WITH READ… unavoidable. This includes backing up a mixture of MyISAM and InnoDB data. But many installations do not mix their data this…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
…| 0 | 2359297 | | 10290 | root | localhost | NULL | Query | 317 | Waiting for table flush | flush tables with read lock | 0 | 0 | 1 | | 10291 | root | localhost | …re just using Innodb tables and you’re not actively changing users, stored procedures etc (which are stored in MyISAM tables anyway) …
Post: MySQL optimizer: ANALYZE TABLE and Waiting for table flush
February 27, 2013 By 3 Comments
…information: http://www.mysqlperformanceblog.com/2011/10/06/when-does-innodb-update-table-statistics-and-when-it-can-bite/ There are …like FLUSH TABLES, ALTER, RENAME, OPTIMIZE or REPAIR can cause threads to wait on “Waiting for tables“, “Waiting for table” and “Waiting for table flush“. Conclusion…
Post: Disaster: MySQL 5.5 Flushing
September 18, 2011 By 27 Comments
…InnoDB configured for this hardware innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
… if you have relatively few tables and/or use the global tablespaces) *cough ext3 cough*. innodb_adaptive_flushing: An Innodb plugin/5.5 setting that tries to be smarter about flushing more aggressively based on…
Post: Hacking to make ALTER TABLE online for certain changes
October 29, 2007 By 26 Comments
… is create another table with desired table structure and switch .frm table definition files. For safety, I’d recommend to flush tables with read lock… (`id`) ) ENGINE=InnoDB To remove auto_increment, we (1) create table with the same layout but without auto_increment, (2) flush tables with read… NULL, -> PRIMARY KEY (`id`) -> ) ENGINE=INNODB; Query OK, 0 rows affected (0.01 sec) — 2. mysql> FLUSH TABLES WITH READ LOCK; Query OK…
Post: Innodb vs MySQL index counts
November 29, 2011 By 6 Comments
… ALTER TABLE to add an index then copy the old .frm file back into place re-open the table (Might need a FLUSH TABLES or mysqld restart here) From my testing, I saw that the error only happened when the table… in Innodb could be removed by doing: ALTER TABLE table_name ENGINE=Innodb; This, of course, rebuilds the whole table based on the .frm table definition…
Post: AUTO_INCREMENT and MERGE TABLES
September 11, 2008 By Leave a Comment
…: mysql> truncate table a2; ERROR 1105 (HY000): MyISAM table ‘a2′ is in use (most likely by a MERGE table). Try FLUSH TABLES. mysql> flush tables; Query OK… auto_increment for Merge Tables works differently from both MyISAM and Innodb tables and being similar to what ISAM tables used to have. As…
