mysql学习之-lock

SELECT
itr.trx_isolation_level,
itr.trx_id waiting_trx_id,
itr.trx_mysql_thread_id waiting_trx_thread,
itr.trx_state waiting_trx_state,
ils.lock_mode waiting_trx_lock_mode,
ils.lock_type waiting_trx_lock_type,
ils.lock_table waiting_trx_lock_table,
ils.lock_index waiting_trx_lock_index,
itr.trx_query waiting_trx_query,
itx.trx_id blocking_trx_id,
itx.trx_mysql_thread_id blocking_trx_thread,
itx.trx_state blocking_trx_state,
ilk.lock_mode blocking_trx_lock_mode,
ilk.lock_type blocking_trx_lock_type,
ilk.lock_table blocking_trx_lock_table,
ilk.lock_index blocking_trx_lock_index,
itx.trx_query blocking_query
FROM
information_schema.innodb_lock_waits w
INNER JOIN information_schema.innodb_trx itx ON itx.trx_id = w.blocking_trx_id
INNER JOIN information_schema.innodb_trx itr ON itr.trx_id = w.requesting_trx_id
INNER JOIN information_schema.innodb_locks ilk ON ilk.lock_trx_id = w.blocking_trx_id
INNER JOIN information_schema.innodb_locks ils ON ils.lock_trx_id = w.requesting_trx_id;


show open tables where In_use > 0;

show engine innodb status


select
a.thread_id,
a.event_id,
a.end_event_id,
a.event_name,
a.source,
a.timer_start,
a.timer_end,
a.timer_wait,
a.lock_time,
a.sql_text,
a.digest,
a.digest_text,
a.current_schema
from
`performance_schema`.`events_statements_current` as a
join `performance_schema`.`threads` as b on a.thread_id = b.thread_id
join `information_schema`.`processlist` as c on b.processlist_id = c.id
join `information_schema`.`innodb_trx` as d on c.id = d.trx_mysql_thread_id
where
d.trx_mysql_thread_id =？