…FLUSH TABLES WITH READ LOCK Note – this command may take a while to complete if you have long running queries. The catch here is FLUSH TABLES WITH READ LOCK… which is done by running UNLOCK TABLES or simply closing connection. 5) … filesystem umount /mnt/backup 
Remove snapshot: lvremove -f /dev/…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
Post: Hacking to make ALTER TABLE online for certain changes
October 29, 2007 By 26 Comments
…=InnoDB To remove auto_increment, we (1) create table with the same layout but without auto_increment, (2) flush tables with read lock, (3) swap .frm files while keeping mysql suspended and (4) unlock the tables afterwards: — 1. mysql> CREATE TABLE `huge_table_new`…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…table scans and index scans more efficient. I can’t wait for ability to create physically sorted indexes with Innodb (with…read-ahead, random read ahead ? HT: InnoDB schedules a sequential read… unlocks (or never locks…flush with a mutex in 5.1, to implement XA, and switching off the XA will not remove…
