We have a lot of free space (801GB free/ 1.12TB used).
Output from show variables like "%tmpdir";
=
mysql> show variables like "%tmpdir";
+---------------------+-------+
| Variable_name | Value |
+---------------------+-------+
| innodb_tmpdir | |
| replica_load_tmpdir | /tmp |
| slave_load_tmpdir | /tmp |
| tmpdir | /tmp |
+---------------------+-------+
4 rows in set (0.64 sec)
/tmp isn’t provisioned on a separate part.
Thanks in advance for your help on this.