Home / server / Questions / 337900
Accepted
sreimer
Asked: 2011-12-06 13:01:47 +0800 CST

Monitoring MySQL Rollback Segments

  • 772

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?

linux mysql innodb rollback

1 Answers

  1. Best Answer

    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

    • 2