MariaDB [ek]> show variables like '%temp%';
|
+---------------------------+-------+
|
| Variable_name | Value |
|
+---------------------------+-------+
|
| aria_used_for_temp_tables | ON |
|
+---------------------------+-------+
|
1 row in set (0.00 sec)
|
|
MariaDB [ek]> show variables like '%tmp%';
|
+-------------------+----------+
|
| Variable_name | Value |
|
+-------------------+----------+
|
| max_tmp_tables | 32 |
|
| slave_load_tmpdir | /tmp |
|
| tmp_table_size | 33554432 |
|
| tmpdir | /tmp |
|
+-------------------+----------+
|
4 rows in set (0.00 sec)
|