经常会遇到这样一个场景:
业务那边觉得
数据库“很慢”,上去通过show processlist查看发现大量State为在等待lock,如:
W
aiting for table metadata/level lock等
比如在执行一个DDL时,发现被hang住,查看到目前进程状态,有MDL
-
Mysql> SHOW PROCESSLIST;
-
+-----+------+-----------+------+---------+------+---------------------------------+--------------------------------------------+
-
| Id | User | Host | db | Command | Time | State | Info |
-
+-----+------+-----------+------+---------+------+---------------------------------+--------------------------------------------+
-
| 585 | root | localhost | test | Sleep | 1658 | | NULL |
-
| 586 | root | localhost | test | Query | 1654 | Waiting for table metadata lock | alter table t change name name varchar(32) |
-
| 590 | root | localhost | test | Query | 0 | starting | show processlist |
-
+-----+------+-----------+------+---------+------+---------------------------------+--------------------------------------------+
-
3 rows in set (0.00 sec)
--结束END--
本文标题: MySQL通过performance_schema定位未提交事务所执行的SQL
本文链接: https://www.lsjlt.com/news/46440.html(转载时请注明来源链接)
有问题或投稿请发送至:
邮箱/279061341@qq.com QQ/279061341
0