On Wed, Apr 7, 2010 at 11:45 PM, shamubro@stripped <shamubro@stripped>wrote:
> Below is my MySQL Server's status and configuration. But I can not see
> anything under /tmpfs/, it is showing empty to me.
>
> here is the result of "ls -al"
>
> drwxrwxrwx 2 mysql mysql 60 Apr 7 17:43 tmpfs
> Could anyone tell me how to check the status of temp files and temp tables
> on disk?
>
Tmp files get deleted as soon as MySQL is done with them. Some applications
will even delete them while they still have them open as a safety measure.
Install the "lsof" utility, and execute "lsof | grep DEL" to see
delete-but-still-open files.
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
