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: http://www.lenzg.net/mylvmbackup/ Expect a serious performance hit while the lvm snapshot is active. ds -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org