锁排查--实例

最新推荐文章于 2023-01-10 23:43:16 发布

scan724

最新推荐文章于 2023-01-10 23:43:16 发布

阅读量539

点赞数

分类专栏： Mysql

本文链接：https://blog.csdn.net/zhaoyangjian724/article/details/46834823

版权

Mysql 专栏收录该内容

90 篇文章 30 订阅 ¥39.90 ¥99.00

订阅专栏

mysql>  show processlist;
+----+------+-----------+------+---------+------+-------+------------------+
| Id | User | Host      | db   | Command | Time | State | Info             |
+----+------+-----------+------+---------+------+-------+------------------+
|  1 | root | localhost | NULL | Query   |    0 | init  | show processlist |
|  2 | test | localhost | NULL | Sleep   |   43 |       | NULL             |
+----+------+-----------+------+---------+------+-------+------------------+
2 rows in set (0.00 sec)

mysql> 



SESSION 1:

3 | test | localhost | test | Sleep   |   25 |       | NULL            

mysql> create table t7(id int);
Query OK,

了解本专栏