mysql常用命令

表级锁的争用状态

show status like 'table%'

 

行级锁争用状态变量

show status like 'innodb_row_lock%' 

 

show engine INNODB status;

 

set autocommit=0;

 

-- 查看joinbuffersize

show variables like 'join_%'

 

-- 查看sortbuffersize

show variables like '%sort_%'

 

set profiling=1;

 

show profiles;

show profile cpu,block io for query 75;

 

show full processlist

 

slow sql --> sql --> explain

 

https://tech.meituan.com/2014/06/30/mysql-index.html

 

show variables like "%slow%";