mysql

show transaction info

select 
    trx_id, 
    trx_started, 
    trx_wait_started, 
    trx_mysql_thread_id, 
    trx_query, 
    trx_operation_state, 
    trx_tables_locked 
from information_schema.INNODB_TRX;

show process

show full processlist;

show open tables

SHOW OPEN TABLES where `database` = 'my_database';