DB----并发引起的死锁

并发引起的死锁

经常出现cdb查询缓慢，cpu占有率高的现象。通过show processlist 可查询大量的连接数
检查下是否有锁等待的情况

show processlist;
select * from innodb_locks

阿里更详细

select
r.trx_id waiting_trx_id,
r.trx_mysql_thread_id waiting_thread,
r.trx_query waiting_query,
b.trx_id blocking_trx_id,
b.trx_mysql_thread_id blocking_thread,
b.trx_query blocking_query
from information_schema.innodb_lock_waits w
inner join information_schema.innodb_trx b
on b.trx_id = w.blocking_trx_id
inner join information_schema.innodb_trx r
on r.trx_id = w.requesting_trx_id;