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]
