Difference between revisions of "Show mysql database locks"

Latest revision as of 19:01, 25 February 2013

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