← Back to team overview

maria-discuss team mailing list archive

Re: ibtmp1 for internal temporary tablespaces

 

William,

On Mon, Aug 8, 2022 at 7:59 PM William Edwards <wedwards@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp


References