Re: MySQL Temp Files

[Umesh Shastry]

Hi!!

MySQL by default limits tmp_table_size to 32MB which is normally in memory, however when a tmp table exceeds that size MySQL automatically converts it to a temp on disk table.

If you are running out disk space then you 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(I guess MySQL5.0 onwards)

Pls go thru the manual for more details..

http://dev.mysql.com/doc/refman/5.0/en/temporary-files.html

Regards,
Umesh Shastry
http://www.blogger.com/profile/02551756983528645221