Re: coufused about ibtmp1
ibtmp1 is the system temporary tablespace used by InnoDB for internal temporary tables and some user-created temporary tables that cannot be fully held in memory.
Memory-based temp tables go to #innodb_temp (controlled by innodb_temp_tablespaces_dir).
On-disk or larger temporary tables automatically go into ibtmp1.
So both statements are correct: small in-memory temp tables use #innodb_temp, while larger or internal temp tables are stored in ibtmp1.
Subject
Written By
Posted
September 03, 2025 01:41AM
November 13, 2025 04:37AM
November 14, 2025 12:34AM
Re: coufused about ibtmp1
November 20, 2025 02:22PM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.