InnoDB Temporary Tablespace (ibtmp1) is Growing Very Fast; Running Out of Disk (Doc ID 2313488.1)

Last updated on SEPTEMBER 04, 2023

Applies to:

MySQL Server - Version 5.7 and later
Information in this document applies to any platform.

The InnoDB temporary table tablespace file (ibtmp1) is growing and the disk is getting out of space. For example:

The issue may start after:

upgrading to MySQL 5.7 or later from MySQL 5.6 or earlier
changes to the workload/application causing a larger usage of explicit and internal temporary tables
changing default_tmp_storage_engine and/or internal_tmp_disk_storage_engine to use the InnoDB storage engine

	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

Symptoms

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