MySQL 常用SQL语句

1
2
3
4
5
6
select count(*) form information_schema.processlist where COMMAND != 'Sleep';
select * from information_schema.processlist where COMMAND !='Sleep' limit 5;

explaim sql;

show engine innodb status;