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;