Mysql temporary files

If the file system containing your temporary file directory is too small, you can use the mysqld --tmpdir option to specify a directory in a file system where you have enough space.

The --tmpdir option can be set to a list of several paths that are used in round-robin fashion. Paths should be separated by colon characters : on Unix and semicolon characters ; on Windows. To spread the load effectively, these paths should be located on different physical disks, not different partitions of the same disk. This directory should be in a disk-based file system not a memory-based file system so that the temporary files used to replicate LOAD DATA can survive machine restarts.

The directory also should not be one that is cleared by the operating system during the system startup process. However, replication can now continue after a restart if the temporary files have been removed. MySQL arranges that temporary files are removed if mysqld is terminated. On platforms that support it such as Unix , this is done by unlinking the file after opening it. If the file system containing your temporary file directory is too small, you can use the mysqld --tmpdir option to specify a directory in a file system where you have enough space.

The --tmpdir option can be set to a list of several paths that are used in round-robin fashion. Paths should be separated by colon characters : on Unix and semicolon characters ; on Windows. To spread the load effectively, these paths should be located on different physical disks, not different partitions of the same disk. CyberDem0n CyberDem0n Elijah Lynn Elijah Lynn The other answers are much better since they explain how to set tmpdir in the MySQL configuration file instead of relying upon environment variables.

Blaise Blaise Works for 5. Will T 4 4 silver badges 16 16 bronze badges. Vacy Vacin Vacy Vacin 1 2 2 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. However, we can create a stored procedure that checks if a temporary table exists or not as follows:. In this procedure, we try to select data from a temporary table. In this tutorial, you have learned about the MySQL temporary tables and how to manage temporary tables such as creating and removing a new temporary table.

Even though a temporary table can have the same name as a permanent table, it is not recommended. Because this may lead to confusion and potentially cause an unexpected data loss.