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?