← Back to team overview

maria-discuss team mailing list archive

ibtmp1 for internal temporary tablespaces

 

Hi,

User-created temporary tables are stored in ibtmp1. Are internal temporary tablespaces (those created by MariaDB while executing queries) too? I am unable to find the answer in the documentation[1].

Context: I'd like to store ibtmp1 in a different path using innodb_temp_data_file_path, but ONLY for user-created temporary tables.

William Edwards

[1]: https://mariadb.com/kb/en/innodb-temporary-tablespaces/

--
With kind regards,

William Edwards



Follow ups