mysql查看当前的innoDB事务

SELECT 
    trx_id,
    trx_state,
    trx_started,
    TIMESTAMPDIFF(SECOND, trx_started, NOW()) AS running_sec,
    trx_mysql_thread_id AS thread_id,
    trx_query,
    trx_tables_locked,
    trx_rows_locked
FROM information_schema.innodb_trx
ORDER BY trx_started;