Group active transactions

group_active_transactions.sql

SELECT p.user 
, substring(p.host, 1, IF( (locate(':', p.host)-1)<0, LENGTH(p.host), locate(':', p.host)-1 ) ) as host
, Substring(p.info, 1, 56) as snippet
, count(*) 
FROM information_schema.processlist p 
LEFT OUTER JOIN information_schema.innodb_trx t 
ON p.id = t.trx_mysql_thread_id 
WHERE p.command not in ('Binlog Dump GTID', 'Binlog Dump') 
AND p.user NOT IN ('system user') 
AND p.id <> connection_id() 
AND t.trx_started IS NOT NULL 
GROUP BY 1,2,3 
ORDER BY 4
;