SELECT i.trx_started, -- 事務(wù)開(kāi)始時(shí)間
i.trx_mysql_thread_id, -- 線程號(hào)丁恭,有緊急需要處理的時(shí)候kill這個(gè)線程彬伦,慎用
p.HOST, -- 機(jī)器ip
p.COMMAND , -- 運(yùn)行狀態(tài)
p.`TIME` , -- 執(zhí)行時(shí)間
c.SQL_TEXT -- sql語(yǔ)句
FROM INFORMATION_SCHEMA.INNODB_TRX i
left join information_schema.PROCESSLIST p on i.trx_mysql_thread_id = p.ID
left join performance_schema.threads t on i.trx_mysql_thread_id =
t.PROCESSLIST_ID
left join performance_schema.events_statements_current c on c.THREAD_ID =
t.THREAD_ID
order by i.trx_started desc
image.png