Get information about active transactions

gistfile1.txt

SELECT t.trx_id 
, t.trx_mysql_thread_id 
, p.User 
, SUBSTRING(p.Host, 1, LOCATE(':', p.Host) -1) AS Host
, SUBSTRING(p.Host, LOCATE(':', p.Host) + 1) AS Port
, t.trx_state 
, t.trx_started 
, ROUND(p.Time/60, 2) Mins 
, p.command 
, p.State 
, p.rows_sent 
, p.rows_examined 
, round(p.rows_sent/p.rows_examined, 4) Percent_Complete 
, SUBSTRING(t.trx_query, 1, 50) AS Query
FROM information_schema.innodb_trx t 
INNER JOIN information_schema.processlist p 
ON t.trx_mysql_thread_id = p.id;