Home / server / Questions / 79492
Accepted
Kyle Smith
Asked: 2009-10-30 05:27:33 +0800 CST

MySQL: Temporary table storage location

  • 772

I have been reading about temporary tables and how if you exceed tmp_table_size, it is converted on an on-disk MyISAM table. What I can't find is where that table is stored. I assume it's the MySQL datadir. Can anyone confirm this?

mysql

2 Answers

  1. Best Answer

    The variable is called tmpdir and has a system default of /tmp, /var/tmp or /usr/tmp.

    You should note though the paragraph about hidden files. You won't be able to actually see the files/tables on disk during operation. And that ALTER TABLE behaves slightly differently.

    • 2

  2. It should be created in the mysql temp directory, as specified by the tmpdir clause in my.cnf

    • 1