Show mysql database locks
From thelinuxwiki
from the mysql prompt...
mysql> SHOW FULL PROCESSLIST; +----+---------+-----------------+------------------+---------+------+-------+-----------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+---------+-----------------+------------------+---------+------+-------+-----------------------+ | 72 | root | localhost | NULL | Query | 0 | NULL | SHOW FULL PROCESSLIST | | 73 | mysqluser | 10.0.0.15:58661 | mysql_database | Sleep | 7 | | NULL | +----+----------+-----------------+------------------+---------+------+-------+-----------------------+