Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

2 Answers 2

up vote 2 down vote accepted

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.

share|improve this answer

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.