InnoDB Temporary Tablespace (ibtmp1) is Growing Very Fast; Running Out of Disk
(Doc ID 2313488.1)
Last updated on FEBRUARY 19, 2018
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