show processlist;

show full processlist;

show processlist;

show processlist；把sleep的去掉，或者直接

select *from inforamtion.innodb_trx;

show processlist;

show processlist  这个最常用

如果要在Linux命令看过滤对应的会话，用下面的命令，这个在生产环境中用得最多

mysql -e "show processlist"| grep alter

show processlist;
show full processlist;
select * from information_schema.innodb_trx;

show processlist;