SELECT * FROM information_schema.`PROCESSLIST` WHERE TIME > 1000 AND USER = 'dimsusr' ORDER BY TIME DESC; kill id ;
select * from information_schema.innodb_trx 查看 trx_mysql_thread_id
show processlist kill 100070;
引起的问题:并发下spring事务造成了死锁。