My Oracle Support Banner

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.

Goal

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.
 

Solution

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.