查询mysql哪些表正在被锁状态
作者：简简单单
2014-09-24
进入mysql数据库
show OPEN TABLES where In_use > 0;
查询结果为正在被锁状态的表，
查看锁表情况
MySQL表锁情况
mysql
| 代码如下 | 复制代码 |
| > show global status like 'table_locks%'; +-----------------------+-----------+ | Variable_name | Value | +-----------------------+-----------+ | Table_locks_immediate | 490206328 | | Table_locks_waited | 2084912 | +-----------------------+-----------+ |
|
