怎么查看mysql中是否有死锁
------------------------ LATEST DETECTED DEADLOCK ------------------------ 2017-09-05 16:03:12 7f11bf522700 *** (1) TRANSACTION: TRANSACTION 343501260, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 9 lock struct(s), heap size 1184, 16 row lock(s) MySQL thread id 1313326, OS thread handle 140296516468736, query id 8315059572 172.19.10.3 mysqluser Trx read view will not see trx with id >= 343501261, sees
如果你需要更详细的死锁信息，你可以使用以下命令：
SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX\G
