MySQL: InnoDB History List Length and the Shared Tablespace (ibdata1) Keeps Growing Under Heavy Workloads, Before Version 5.5.8, 5.1.53 or 5.0.70 (Doc ID 1475296.1)

Last updated on OCTOBER 18, 2016

Applies to:

MySQL Server - Version 5.0 to 5.5 [Release 5.0 to 5.5]
MySQL Server - Version 5.1 to 5.1 [Release 5.1]
Information in this document applies to any platform.

Symptoms

In the following MySQL versions using the InnoDB storage engine:

After a period of with heavy workload the InnoDB history list does not reduce in size again and the shared tables space continues to grow even if innodb_file_per_table is used.

Cause

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