MySQL: Long Running Active Idle Transactions
(Doc ID 1312358.1)
Last updated on JULY 13, 2020
Applies to:MySQL Server - Version 4.0 and later
Information in this document applies to any platform.
MySQL is increasingly slow . CPU is high. Some client connections time out.
The error log contains aborted connection warnings :
In the SHOW ENGINE INNODB STATUS output, you can see :
History list length very high > 1K.
The history list length of each InnoDB status is increasingly large.
Transaction history is increasing.
The bottom of the transaction list displays long running transactions doing nothing.
MySQL thread id 3148, query id 1347630
<server name> <ip> <user>
Trx read view will not see trx with id >= 7DAF7, sees < 7DAF5
The longest running active transaction does not run any SQL statement.
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