查询锁表:
show open tables where in_use >=1;
SHOW ENGINE INNODB STATUS;
死锁排查步骤:
show engine innodb status;
explain
查看间隙锁是否关闭:
show global variables like "innodb_locks%";
show global variables like "autocommit";
查询事务级别
show global variables like "tx_isolation";
设置事务的隔离级别:
set session transaction isolation level X;
X取值:
read uncommitted
read committed
repeatable read
serializable
关闭自动提交:
set session autocommit=0;
#慢查询配置是否开启:
show variables like 'slow_query%';
set global log_output='TABLE'; -- 开启慢日志,纪录到 mysql.slow_log 表
set global long_query_time=5; -- 设置超过5秒的查询为慢查询
# 打开慢日志记录
set global slow_query_log='ON