MySQL: Long Running Active Idle Transactions
Last updated on MARCH 12, 2018
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms