MySQL Forums
Forum List  »  General

coufused about ibtmp1
Posted by: victor victor
Date: August 13, 2025 11:23PM

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

Options: ReplyQuote


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.