On Wed, Jul 04, 2012 at 06:18:44PM +0400, Eugene Berdnikov wrote: > On Wed, Jul 04, 2012 at 04:50:15PM +0300, Andrey Tataranovich wrote: > > (mysql) flush tables with read lock > > (shell) lvcreate --snapshot > > (mysql) unlock tables > > ... backup ... > > (shell) lvremove > > Ничего не зная про mysql, :-) берусь утверждать, что если есть активные > (незакрытые) транзакции, то это либо невозможно, либо некорректно. The implementation does this: 1. set the global read lock - after this step, insert/update/delete/replace/alter statements cannot run 2. close open tables - this step will block until all statements started previously have stopped 3. set a flag to block commits If long-running statements were started prior to step 2, then the FLUSH TABLES WITH READ LOCK command will block until they complete. -- WBR, wRAR
Attachment:
signature.asc
Description: Digital signature