show processlist
select
*
from
information_schema.innodb_trx\G;
select
*
from
sys.innodb_lock_waits\G;
select
*
from
performance_schema.metadata_locks;
select
*
from
sys.schema_table_lock_waits\G;
select
*
from
performance_schema.table_handles where OWNER_THREAD_ID!
=
0
;
call sys.ps_setup_enable_instrument(
'sql/mdl'
);