show connections active transactions

[expired user #5322]'s profile image [expired user #5322] posted 9 years ago in General Permalink
Hi, sometimes I'm forced to search and kill connections with ACTIVE TRANSACTIONs. It would be very usefull to see such connections in connection list in host/processes tab. There could be new column with name "transaction time" - that would be great. We are using MySQL. Active transactions are discoverable by SHOW ENGINE INNODB STATUS.
Thank you!

Please login to leave a reply, or register at first.