zdy_software的博客

1、查询是否锁表mysql> show OPEN TABLES where In_use > 0;2、查询进程 mysql>    show processlist  查询到相对应的进程===然后kill    id3、查看正在锁的事务mysql> SELECT * FROMINFORMATION_SCHEMA.INNODB_LOCKS; 4、查看等待锁的事务m

mysql> show status like 'Threads%';+-------------------+-------+| Variable_name     | Value |+-------------------+-------+| Threads_cached    | 58    || Threads_connected | 57    |   ###这个数值