Php Script to check MySQL TABLE LOCK status

Question

I use mysqldump for MySQL Backup.

mysqldump --lock-tables....

The DB is about 2GB, hence mysqldump takes a long time. If anyone tries to access the DB during backup, I would like to flash a message saying "the DB is being backed-up, please return back after 10 minutes"

My questions is using PHP script, how can I check if mysql table is locked or not.

Thank you in advance.

Best regards, Sanjay

ajreal · Accepted Answer · 2010-12-29 12:11:23Z

2

Prefer method will be setup replication,
and mysqldump on the slave instead on master (assuming only master is serving requests)

So, you never experiencing downtime

answered Dec 29, 2010 at 12:11

ajreal

47.4k11 gold badges97 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

SubniC · Accepted Answer · 2010-12-29 12:08:11Z

1

If you have both read/write lock you can write a php script that try to access/write in a table, if it is locked the MySQL server will rise an error and you will be able to evaluate the code and send a message if the error is because the tables are locked.

HTH!

EDIT: You can take a look of the MySQL GET_LOCK function

answered Dec 29, 2010 at 12:08

SubniC

10.4k4 gold badges30 silver badges33 bronze badges

Collectives™ on Stack Overflow

Php Script to check MySQL TABLE LOCK status

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related