Linux Archive

Linux Archive (http://www.linux-archive.org/)
-   CentOS (http://www.linux-archive.org/centos/)
-   -   MySQL/file system question (http://www.linux-archive.org/centos/632624-mysql-file-system-question.html)

Adam Tauno Williams 02-14-2012 01:37 AM

MySQL/file system question
 
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.

--
System & Network Administrator [ LPI & NCLA ]
<http://www.whitemiceconsulting.com>
OpenGroupware Developer <http://www.opengroupware.us>
Adam Tauno Williams

_______________________________________________
CentOS mailing list
CentOS@centos.org
http://lists.centos.org/mailman/listinfo/centos


All times are GMT. The time now is 06:16 AM.

VBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2007, Crawlability, Inc.