MariaDB High Performance

Temporary tables

Temporary tables show you how many temporary files are created in the disk because they couldn't be set in memory. To show them, you can use the global status information:

MariaDB [(none)]> show global status like 'Created_tmp%';
+-------------------------+--------+
| Variable_name           | Value  |
+-------------------------+--------+
| Created_tmp_disk_tables | 13363  |
| Created_tmp_files       | 6      |
| Created_tmp_tables      | 107681 |
+-------------------------+--------+
3 rows in set (0.00 sec)

You can see all the temporarily created disk tables, files, and tables here. Here is a description of them to better understand how they work:

• Created_tmp_disk_tables: This value should stay at 0 instead of getting BLOB or TEXT columns in your databases. ...