mysql线程连接数排查,解决数据库死锁问题

1:查看全局线程数
show global status like ‘Thread%’;

2: 显示进行中的线程list
show full PROCESSLIST;

3: 死锁问题排查sql语句执行
select * from information_schema.INNODB_TRX;
SELECT * FROM information_schema.innodb_trx
SELECT * FROM information_schema.innodb_locks
SELECT * FROM information_schema.innodb_lock_waits
SHOW VARIABLES LIKE ‘innodb_lock_wait_timeout’;

SET GLOBAL innodb_lock_wait_timeout=50;
//对死锁日志进行分析
show engine innodb status;

4： kill掉进程

如： kill 3828877;