Show mysql database locks

From thelinuxwiki
Jump to: navigation, search

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                  |
+----+----------+-----------------+------------------+---------+------+-------+-----------------------+