Monitoring MySQL Rollback Segments

Question

I recently discovered the default open transaction ceiling of 1024 in MySQL. I have since increased the limit using innodb_extra_rsegments. However, I would like to keep my eye on this moving forward. My MySQL version is 5.1.48. Is there a way to monitor the open transactions at a point in time?

score 2 · Accepted Answer · edited May 23 '17 at 12:41

2

SHOW ENGINE INNODB STATUS will give insight as to how far back your history list is, how many transactions are pending/active and other super useful diagnostics.

You can get the full rundown here

Also, this has already been answered: https://stackoverflow.com/questions/3172127/can-i-retrieve-pending-queries-during-an-innodb-transaction

edited May 23 '17 at 12:41

Community

1

answered Dec 05 '11 at 21:09

thinice

4,676
20
38

Monitoring MySQL Rollback Segments

1 Answers1