Long Running Transactions Can Appear Suddenly in SHOW ENGINE INNODB STATUS Output/InnoDB Monitor
(Doc ID 2768570.1)
Last updated on JULY 14, 2021
Applies to:MySQL Server - Version 8.0 and later
Information in this document applies to any platform.
When you collect SHOW ENGINE INNODB STATUS command output periodically, duration of active transactions increase gradually. For example, if you collect SHOW ENGINE INNODB STATUS once per minute, duration of active transactions increase by 1 minute upon every collection. However, there can be one possible exception, and transactions with very long duration can appear suddenly in SHOW ENGINE INNODB STATUS output.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document