mysql> show status like 'Table_locks%'; +-----------------------+-------+ | Variable_name | Value | +-----------------------+-------+ | Table_locks_immediate | 43 | | Table_locks_waited | 0 | +-----------------------+-------+ 2 rows in set (0.00 sec)mysql>看这个Table_locks_waited状态就行了。
+-----------------------+-------+
| Variable_name | Value |
+-----------------------+-------+
| Table_locks_immediate | 43 |
| Table_locks_waited | 0 |
+-----------------------+-------+
2 rows in set (0.00 sec)mysql>看这个Table_locks_waited状态就行了。