How FLUSH TABLES WITH READ LOCK works with Innodb Tables

(Peter Zaitsev) Many backup tools including Percona Xtrabackup, MyLVMBackup and others use FLUSH TABLES WITH READ LOCK to temporary make MySQL read only. In many cases the period for which server has to be made read only is very short, just few seconds, yet the impact of FLUSH TABLES WITH READ LOCK

Read More - Register for Free Membership