On Mon, 2012-02-13 at 18:59 -0500, Boris Epstein wrote:
Here we go: [root@gala ~]# ls -l /proc/18702/fd total 0
...
lrwx------ 1 root root 64 Feb 13 18:58 7 -> /home/mysql/tmp/ibE0DGCO (deleted) lrwx------ 1 root root 64 Feb 13 18:58 8 -> /home/mysql/mysql_data/ib_logfile0 lrwx------ 1 root root 64 Feb 13 18:58 9 -> /home/mysql/mysql_data/ib_logfile1 [root@gala ~]# Now the files of interest are the ones marked deleted in /home/mysql/tmp . Now how do I tell what their size is?
I wouldn't bother pursuing this angle further; I am not an MySQL admin, but it must provide performance reporting, statistics, and explain information [PostgreSQL does, as do most other database engines]. Check the MySQL docs for how you monitor the utilization of temp spaces. If it can't provide this information choose another solution.
It is best not to dig around under engines. Use the tools and let them tell you, otherwise you will build around implementation details.