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://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 that fills up the filesystem in which the temporary > file directory is located." > > Is there any form of see the length of the temporary files created by > MySQL? If you install the lsof program, you can ask it to print all filehandles opened by mysql with a link count less than one (i.e. deleted but still-open files): $ lsof -c mysqld -a +L1 mysqld 70195 mysql 45u VREG 0,120 463317867 0 12500 /usr (/dev/da0s1f) mysqld 70195 mysql 46u VREG 0,120 132005329 0 12520 /usr (/dev/da0s1f) -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] ______________________________________________ LLama Gratis a cualquier PC del Mundo. Llamadas a fijos y móviles desde 1 céntimo por minuto. http://es.voice.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
