Mysql 锁表日志查看

show variables like 'innodb_status_output';

set GLOBAL innodb_status_output=ON;

set GLOBAL innodb_status_output_locks=ON;

select @@log_error;

show VARIABLES like 'general%';

SHOW VARIABLES LIKE 'INNODB_PRINT_ALL_DEADLOCKS';

SET GLOBAL innodb_print_all_deadlocks=1;

show engine innodb status ;

SHOW MASTER LOGS;

flush logs; 

相互碰撞,就死锁了