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