MySQL Innodb如何找出阻塞事务源头SQL
作者:数据库 来源:数据库 浏览: 【大中小】 发布时间:2025-11-05 00:59:02 评论数:
复制mysql> use MyDB; Reading table information for completion oftableandcolumn names You can turn off this feature to get a quicker startup with -A Database changed mysql> createtable test_blocking(id intprimarykey,找出阻塞 namevarchar(12)); Query OK, 0 rows affected (0.05 sec) mysql> insertinto test_blocking -> select 1, kerryfrom dual; Query OK, 1 row affected (0.00 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql> insertinto test_blocking -> select 2, jimmyfrom dual; Query OK, 1 row affected (0.00 sec) Records: 1 Duplicates: 0 Warnings: 0 mysql> insertinto test_blocking -> select 3, kkkfrom dual; Query OK, 1 row affected (0.00 sec) Records: 1 Duplicates: 0 Warnings: 0 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.