mysql 锁等待/死锁

-- MySQL 8.0 SELECT * FROM performance_schema.data_lock_waits\G -- MySQL 5.7 SELECT r.trx_id waiting_trx_id, r.trx_mysql_thread_id waiting_thread, r.trx_query waiting_query, b.trx_id blocking_trx_id, b.trx_mysql_thread_id blocking_thread, b.trx_query blocking_query FROM information_schema.innodb_lock_waits w JOIN information_schema.innodb_trx b ON b.trx_id = w.blocking_trx_id JOIN information_schema.innodb_trx r ON r.trx_id = w.requesting_trx_id;

SHOW ENGINE INNODB STATUS\G -- 搜索 LATEST DETECTED DEADLOCK 段落

KILL <blocking_thread_id>;