【mysql -杀会话】

--查询阻塞信息

select * from information_schema.`PROCESSLIST` where id in ( select a.trx_mysql_thread_id from information_schema.INNODB_TRX a );

order by time desc ;

select * from information_schema.`PROCESSLIST` where id in ( select a.trx_mysql_thread_id from information_schema.INNODB_TRX a ) order by time desc；

select * from information_schema.INNODB_TRX；

select CONCAT("kill ",id,';') from information_schema.`PROCESSLIST` where id in ( select a.trx_mysql_thread_id from information_schema.INNODB_TRX a )

order by time desc ;

select CONCAT("kill ",id,';') from information_schema.`PROCESSLIST` a where id in ( select a.trx_mysql_thread_id from information_schema.INNODB_TRX a ) and a.user='mysqld'

order by time desc ;

登录查询的用户（mysqld）进行删除会话

select * from information_schema.`PROCESSLIST` where id in ( select a.trx_mysql_thread_id from information_schema.INNODB_TRX a )；

order by time desc ;

select * from information_schema.INNODB_TRX ;

show create database dbname;

show create table tablename \G;

show warnings;

在mysql全库备份脚本的最后，加了条清理7天前binlog的命令

mysql -uroot -p${DBPasswd} -e 'purge master logs before date_sub(now() ,INTERVAL 7 DAY)';

----杀锁表

select * from information_schema.`PROCESSLIST` where id in ( select a.trx_mysql_thread_id from information_schema.INNODB_TRX a ) order by time desc