We use LVM snapshots all the time. They are essentially
instantaneous with our >90GB innodb database files.
A command to generate the snapshot could be:
sudo /usr/sbin/lvcreate --snapshot --name mysqlsqlbackup --size 15G /
Please let me know if you have any questions.
On Jun 22, 2009, at 4:41 PM, 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?
> Are we talking half a second, ten-seconds, 20 minutes?
> Currently, when we copy the raw files from one directory to another,
> takes about 20 mins and brings the DB to it's proverbial knees.
> When we
> copy the files with the db server down, it takes 10 minutes or so.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1