Investigate 'Waiting for table metadata lock'
Try these information_schema queries:
select * from innodb_lock_waits;
select *
from innodb_locks
where lock_trx_id in (
select blocking_trx_id from innodb_lock_waits
);;
select a.*
from innodb_locks a
join innodb_lock_waits b on a.lock_trx_id = b.blocking_trx_id;
select * from innodb_locks where lock_table = ...
select trx_id, trx_requested_lock_id, trx_mysql_thread_id, trx_query
from innodb_trx
where trx_state = 'lock wait';
|
|