mysql的表被锁住了_mysql 数据库表被锁住了_Mysql数据库表锁死如何处理？

处理方式有如下三种：

1.查询不是sleep或者有状态的sql

select * from `information_schema`.processlist where command !='Sleep' or state !=''

2.查询运行中的事务

select trx_state, trx_started, trx_mysql_thread_id, trx_query from information_schema.innodb_trx

3.查看死锁

SELECT b.trx_state, e.state, e.time, d.state AS block_state, d.time AS block_time

, a.requesting_trx_id, a.requested_lock_id, b.trx_query, b.trx_mysql_thread_id, a.blocking_trx_id

, a.blocking_lock_id, c.trx_query AS block_trx_query, c.trx_mysql_thread_id AS block_trx_mysql_tread_id

FROM information_schema.INNODB_LOCK_WAITS a

LEFT JOIN information_schema.INNODB_TRX b ON a.requesting_trx_id = b.trx_id

LEFT JOIN information_schema.INNODB_TRX c ON a.blocking_trx_id = c.trx_id

LEFT JOIN information_schema.PROCESSLIST d ON c.trx_mysql_thread_id = d.id

LEFT JOIN information_schema.PROCESSLIST e ON b.trx_mysql_thread_id = e.id

ORDER BY a.requesting_trx_id