I have a Linux server & MariaDB v10.0.33, where tmpdir is tmpfs (ram), for fast temporary table access; tmpfs is obviously limited in size.
MariaDB seems to use the same tmpdir location for alter table operations (table copy), that require a table copy; these can require large amounts of space if tables are many Gb.
Old MySQL versions configure ‘table copy’ and ‘temp table’ separately;
Table copy written to tablespace & temporary tables written to tmpdir.
I am aware I can set ‘innodb_tmpdir’ per command.
Can MariaDB configured so that table copy & temporary tables use different locations?
I think it is a bad idea to rob space in RAM for things other than
Furthermore, your example is flawed. An
ALTER that needs to copy works this way:
Step 2 is the issue:
Answered by Rick James on November 11, 2021
1 Asked on August 13, 2020 by gio
1 Asked on August 12, 2020 by g-iannello
1 Asked on August 3, 2020 by shr
Get help from others!