http://www.thelinuxwiki.com/index.php?action=history&feed=atom&title=Show_mysql_database_locksShow mysql database locks - Revision history2026-04-29T00:34:48ZRevision history for this page on the wikiMediaWiki 1.21.5http://www.thelinuxwiki.com/index.php?title=Show_mysql_database_locks&diff=28&oldid=prevNighthawk: Pushed from thelinuxwiki.com.2013-02-25T19:01:30Z<p>Pushed from thelinuxwiki.com.</p>
<p><b>New page</b></p><div>from the mysql prompt...<br />
mysql> '''SHOW FULL PROCESSLIST;'''<br />
+----+---------+-----------------+------------------+---------+------+-------+-----------------------+<br />
| Id | User | Host | db | Command | Time | State | Info |<br />
+----+---------+-----------------+------------------+---------+------+-------+-----------------------+<br />
| 72 | root | localhost | NULL | Query | 0 | NULL | SHOW FULL PROCESSLIST |<br />
| 73 | mysqluser | 10.0.0.15:58661 | mysql_database | Sleep | 7 | | NULL |<br />
+----+----------+-----------------+------------------+---------+------+-------+-----------------------+<br />
<br />
[[category:mysql]]</div>Nighthawk