Impact of Long Transactions on Overall InnoDB Performance
(Doc ID 2070969.1)
Last updated on AUGUST 01, 2023
Applies to:MySQL Server - Version 4.0 and later
Information in this document applies to any platform.
- InnoDB shows bad performance;
- INNODB STATUS shows that long ACTIVE transactions exists;
- InnoDB purge thread doesn't progress, i.e. INNODB STATUS shows number after "Purge done for trx's n:o" much smaller than ""Trx id counter" and "state: running but idle" , e.g.:
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