Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: David Sparks (daveca.sophos.com)
Date: Mon Jun 22 2009 - 18:42:37 CDT
Little, Timothy wrote:
> We have a 20 gig db (that includes the MYIs and MYDs and FRMs).
> We are wondering how long LVM snapshots take.. in that how long might
> the DB be read-locked? Do we have to read-lock it and flush tables?
Take a look at mylvmbackup which takes care of flushing tables, creating and
destroying the snapshot, etc:
Expect a serious performance hit while the lvm snapshot is active.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql