php mysql查询锁,PHP脚本检查MySQL表锁状态

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

解决方案

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