MySQL Forums
Forum List  »  MySQL Administrator

Re: mysql connection and bash script
Posted by: Julian Price
Date: March 20, 2009 06:51PM

As soon as the database connection ends, the lock is lost.

Have you tried using ShellSQL to keep the connection open?

I am working on issuing the MySql command
FLUSH TABLES WITH READ LOCK
before taking a snapshot of the LVM disk containing the database and then
UNLOCK TABLES
to unlock them again.

This minimises the time during which the tables are locked.

If anyone already has/knows of a script that does this then please post the script or a link here.

Thanks,
Julez

Options: ReplyQuote


Subject
Written By
Posted
December 29, 2008 02:53PM
Re: mysql connection and bash script
March 20, 2009 06:51PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.