List all long running transactions on a mysql database server

mysql-long-running-transactions.sql

SELECT 
    a.trx_id, a.trx_state, a.trx_started, 
    TIMESTAMPDIFF(SECOND,a.trx_started, now()) as "Seconds Transaction Has Been Open",
    a.trx_rows_modified, 
    b.USER, b.host, b.db, b.command, b.time, b.state
FROM 
    information_schema.innodb_trx a 
INNER JOIN 
    information_schema.processlist b ON b.id = a.trx_mysql_thread_id
ORDER BY 
    trx_started;