Sample Header Ad - 728x90

MariaDB tmpdir & table copy operations

0 votes
1 answer
527 views
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?
Asked by user120053 (9 rep)
Jan 24, 2018, 11:12 AM
Last activity: Sep 30, 2024, 06:08 PM