William, On Mon, Aug 8, 2022 at 7:59 PM William Edwards <wedwards@cyberfusion.nl> wrote:
Hi,
User-created temporary tables are stored in ibtmp1. Are internal temporary tablespaces (those created by MariaDB while executing queries) too?
From https://mariadb.com/kb/en/server-system-variables/#default_tmp_storage_engin... , its the https://mariadb.com/kb/en/aria-system-variables/#aria_used_for_temp_tables variable that controls internal temporary tables (which aren't innodb).
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
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp