List:General Discussion« Previous MessageNext Message »
From:<informatica Date:September 8 2006 8:36am
Subject:RE: View hidden temporary files
View as plain text  
Thanks. That works for me.

-----Mensaje original-----
De: Dan Nelson [mailto:dnelson@stripped] 
Enviado el: jueves, 07 de septiembre de 2006 19:05
Para: informatica@stripped
CC: MySql Mail List
Asunto: Re: View hidden temporary files

In the last episode (Sep 07), informatica@stripped said:
> In 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
mysqld  70195 mysql   46u  VREG  0,120 132005329     0 12520 /usr

	Dan Nelson
View hidden temporary filesinformatica7 Sep
  • Re: View hidden temporary filesDan Nelson7 Sep
    • RE: View hidden temporary filesinformatica8 Sep
  • Re: View hidden temporary filesVisolve DB Team8 Sep