mysql数据库的MDL锁排查

数据准备：

 

 开启一个事务：

 

 

 

 

 

 

 select * from infomation_schema.innodb_lock_waits;

select * from data_locks;

 

 selext trx_id,trx_started,trx_requested_lock_id,trx_query,trx_mysql_thread_id from information_schema.innodb_trx

 

 

 

 

show processlist