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 http

RV: View hidden temporary files

2006-09-08 Thread iagosineiro
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 http

View hidden temporary files

2006-09-07 Thread informatica
Hi. 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 is that you do not see a big temporary file

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

Re: View hidden temporary files

2006-09-07 Thread Visolve DB Team
Message - From: [EMAIL PROTECTED] To: MySql Mail List mysql@lists.mysql.com Sent: Thursday, September 07, 2006 8:00 PM Subject: View hidden temporary files Hi. In http://dev.mysql.com/doc/refman/4.1/en/temporary-files.html says MySQL creates all temporary files as hidden files

RE: mysql fills the disk with temporary files?

2002-10-31 Thread Jan Steinman
From: Lars Andersson [EMAIL PROTECTED] Thanks for your advices, but I don't want to solve this problem on the OS/shell level. Assuming MySQL is installed properly, with its own user and group, I don't see why you should not want to solve the problem this way. -- SQL SQL SQL SQL SQL SQL

temporary files,

2002-08-15 Thread samia_driss
Hi, It's my first time for using MySQL. I would know, why does it generate such giant temporary files. And what should i do to save my disk from getting filled by these files. Regards Semia - Before posting, please check

temporary files

2002-08-15 Thread samia_driss
Hi, It's my first time for using MySQL. I would know, why does it generate such giant temporary files. And what should i do to save my disk from getting filled by these files. Regards Semia - Before posting, please check

Re: temporary files,

2002-08-15 Thread Egor Egorov
samia, Thursday, August 15, 2002, 3:45:27 PM, you wrote: s It's my first time for using MySQL. s I would know, why does it generate such giant temporary files. And what should i do to save my disk from getting s filled by these files. MySQL uses temporary tables in some queries. So, if you

FW: temporary files

2002-08-15 Thread samia_driss
-Original Message- From: DRISSI,SAMIA (Non-A-hsgGermany,ex1) Sent: Thursday, August 15, 2002 4:06 PM To: [EMAIL PROTECTED] Subject: Hi, Bei running one application on MySQL, the server generates a giant temporary file. At the same time i call the application again, and keep all old

temporary files

2002-08-15 Thread samia_driss
HI, MySQL keep the temporary files until it's closed down. Is there somme possibility to remove them as soon as they are no longer needed?? - Before posting, please check: http://www.mysql.com/manual.php (the manual

Temporary Files?

2001-10-01 Thread Isaac Wagner
Could someone explain to me how/when mysql uses temp files.. running a new dedicated db server with twice as much ram as the old one, and the new one keeps dumping 400+mb data into a temp file when the database is searched, both with LIKE and MATCH/AGAINST statements... i have never looked to

Re: Temporary Files?

2001-10-01 Thread Benjamin Pflugmann
Hi. A quick search for temporary files results in http://www.mysql.com/doc/T/e/Temporary_files.html The best guess is that it is the result of massive sorting. Why this happens (or better: is noticible) only on the new server, I have no idea of. Bye, Benjamin. On Mon, Oct 01, 2001