RE: View hidden temporary files

2006-09-08 Thread informatica
Thanks. That works for me. -Mensaje original- De: Dan Nelson [mailto:[EMAIL PROTECTED] Enviado el: jueves, 07 de septiembre de 2006 19:05 Para: [EMAIL PROTECTED] CC: MySql Mail List Asunto: Re: View hidden temporary files In the last episode (Sep 07), [EMAIL PROTECTED] said: > In h

Re: View hidden temporary files

2006-09-07 Thread Visolve DB Team
Hi, MySQL creates temporary table to complete the query. However, it doesn't tell you whether that temporary table will be in memory or on disk. MySQL's tmp_table_size variable will control the temporary table size.The default tmp_table_size size is 32 MB Temporary tables can either be in th

Re: View hidden temporary files

2006-09-07 Thread Dan Nelson
In the last episode (Sep 07), [EMAIL PROTECTED] said: > In http://dev.mysql.com/doc/refman/4.1/en/temporary-files.html says > > "MySQL creates all temporary files as hidden files. This ensures that > the temporary files are removed if mysqld is terminated. The > disadvantage of using hidden files