… simply drop the table and recreate it under lock_OPEN, which won’t help. Deleting all rows from the table could incur significant expense. MySQL 5.5 does have metadata locking… fixed in trunk. You might consider using RENAME TABLE to swap the table with an empty table, which should be a pretty fast operation…
Post: MySQL optimizer: ANALYZE TABLE and Waiting for table flush
February 27, 2013 By 3 Comments
… the underlying table has changed and it needs to close and reopen it using FLUSH. Therefore the table will be locked until all queries that are using that table finish. There are only two… 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…
Post: Percona Server 5.5.10 (Release Candidate)
April 4, 2011 By 4 Comments
… to table PROCESSLIST and to the output of SHOW PROCESSLIST. (Laurynas Biveinis) Variable Changes Old status variable innodb_row_lock_numbers was renamed… was renamed to innodb_recovery_update_relay_log. (Yasufumi Kinoshita) Old system variable innodb_pass_corrupt_table was renamed to innodb_corrupt_table_action…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… tables | 0.000118 | | System lock | 0.000007 | | setup | 0.000027 | | creating table | 0.002255 | | After create | 0.000050 | | copy to tmp table | 61.816063 | | rename result table | 0…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
…latter, resulting in start up errors. Fixed by renaming the innodb_changed_pages_limit option to … at least one of those tables specified in the replicate-ignore-table. Bug fixed #1068210 (George … the data pages for printing lock information even if no lock information was going to be printed…
Post: Best kept MySQLDump Secret
March 23, 2012 By 13 Comments
…Create temporary table with modified structure, copy data to that table and when drop original table and rename such temporary table to … — Dumping data for table `C` — LOCK TABLES `C` WRITE; /*!40000 ALTER TABLE `C` DISABLE KEYS */; /*!40000 ALTER TABLE `C` ENABLE KEYS */; UNLOCK TABLES; /*!40103 …
Post: Announcing Percona Server for MySQL version 5.1.67-14.4
March 8, 2013 By Leave a Comment
… statement containing BLOB values for a compressed table. This regression was introduced in Percona Server …, resulting in start up errors. Fixed by renaming the innodb_changed_pages_limit option to … the data pages for printing lock information even if no lock information was going to be printed…
Post: Announcing Percona Server 5.1.65-14.0
September 4, 2012 By Leave a Comment
…I_S.GLOBAL_TEMPORARY_TABLES or TEMPORARY_TABLES would crash threads working with temporary tables. Bug fixed #951588 (…) with the default value of innodb_autoinc_lock_mode=1. Bug fixed #1035225 (Alexey Kopytov)….dumps to a temporary file first, and then renames it to the actual dump file. Bug fixed …
Post: Percona Toolkit versions 2.0.5 and 2.1.2 released
June 12, 2012 By 1 Comment
… fixed several bugs in pt-table-sync that prevented it from working properly, and disabled the –lock-and-rename feature when using it with MySQL versions that don’t support it reliably. We enhanced pt-table-checksum and…
Comment: A (prototype) lower impact slow query log
September 28, 2012 By 12 Comments
… is itself reentrant (ie. the fd table or the entry for fd wasn’t locked). It’s quite unlikely that a OS… another partition -the only interesting use case I see- as rename would fail with EXDEV, and no file rotation would be…
