coufused about ibtmp1
i read 8.0/8.4 documents, the user created temp tables are in #innodb_temp dir, the parameter innodb_temp_tablespaces_dir defines the #innodb_temp dir.
but why i also see the below description about user-created temporary tables will be in ibtmp1:
InnoDB user-created temporary tables and on-disk internal temporary tables are created in a temporary tablespace file named ibtmp1 in the MySQL data directory.
https://dev.mysql.com/doc/refman/8.4/en/temporary-files.html
Subject
Written By
Posted
coufused about ibtmp1
August 13, 2025 11:23PM
September 03, 2025 01:41AM
November 13, 2025 04:37AM
November 14, 2025 12:34AM
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.