William, On Mon, Aug 8, 2022 at 7:59 PM William Edwards <wedwa...@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_engine , 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 _______________________________________________ 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
