mysql事务锁表进程排查

-- 查找没提交的事物

SELECT * FROM information_schema.INNODB_TRX ORDER BY trx_started ASC;

-- 查找指定事务进程的执行sql

SELECT
    a.sql_text,c.id,d.trx_started
FROM
    performance_schema.events_statements_current a
JOIN performance_schema.threads b ON a.thread_id = b.thread_id
JOIN information_schema.processlist c ON b.processlist_id = c.id
JOIN information_schema.innodb_trx d ON c.id = d.trx_mysql_thread_id
WHERE
    c.id = 123456  -- trx_mysql_thread_id
ORDER BY
    d.trx_started