[CentOS] MySQL/file system question

Mon Feb 13 23:59:51 UTC 2012
Boris Epstein <borepstein at gmail.com>

On Mon, Feb 13, 2012 at 6:53 PM, Ljubomir Ljubojevic <office at plnet.rs>wrote:

> On 02/13/2012 11:31 PM, Boris Epstein wrote:
> >>
> > In fact, I did look in /proc/{pid#}/fd and found the file names, thanks!
> > Coud quite figure out the size of those invisible files - but no matter,
> > hopefully I've got enough room.
> >
>
> ls -l /proc/{pid#}/fd
>
> --
>
> Ljubomir Ljubojevic
> (Love is in the Air)
> PL Computers
> Serbia, Europe
>
> Google is the Mother, Google is the Father, and traceroute is your
> trusty Spiderman...
> StarOS, Mikrotik and CentOS/RHEL/Linux consultant
> _______________________________________________
> CentOS mailing list
> CentOS at centos.org
> http://lists.centos.org/mailman/listinfo/centos
>

Ljubomir,

Here we go:

[root at gala ~]# ls -l /proc/18702/fd
total 0
lr-x------ 1 root root 64 Feb 13 18:58 0 -> /dev/null
lrwx------ 1 root root 64 Feb 13 18:58 1 -> /var/log/mysqld.log
lrwx------ 1 root root 64 Feb 13 18:58 10 -> socket:[1245288]
lrwx------ 1 root root 64 Feb 13 18:58 11 -> /home/mysql/tmp/ibEvxyKc
(deleted)
lrwx------ 1 root root 64 Feb 13 18:58 12 -> socket:[1245289]
lrwx------ 1 root root 64 Feb 13 18:58 13 ->
/home/mysql/mysql_data/mysql/host.MYI
lrwx------ 1 root root 64 Feb 13 18:58 14 ->
/home/mysql/mysql_data/mysql/host.MYD
lrwx------ 1 root root 64 Feb 13 18:58 15 ->
/home/mysql/mysql_data/mysql/user.MYI
lrwx------ 1 root root 64 Feb 13 18:58 16 ->
/home/mysql/mysql_data/mysql/user.MYD
lrwx------ 1 root root 64 Feb 13 18:58 17 ->
/home/mysql/mysql_data/mysql/db.MYI
lrwx------ 1 root root 64 Feb 13 18:58 18 ->
/home/mysql/mysql_data/mysql/db.MYD
lrwx------ 1 root root 64 Feb 13 18:58 19 ->
/home/mysql/mysql_data/mysql/tables_priv.MYI
lrwx------ 1 root root 64 Feb 13 18:58 2 -> /var/log/mysqld.log
lrwx------ 1 root root 64 Feb 13 18:58 20 ->
/home/mysql/mysql_data/mysql/tables_priv.MYD
lrwx------ 1 root root 64 Feb 13 18:58 21 ->
/home/mysql/mysql_data/mysql/columns_priv.MYI
lrwx------ 1 root root 64 Feb 13 18:58 22 ->
/home/mysql/mysql_data/mysql/columns_priv.MYD
lrwx------ 1 root root 64 Feb 13 18:58 23 ->
/home/mysql/mysql_data/mysql/procs_priv.MYI
lrwx------ 1 root root 64 Feb 13 18:58 24 ->
/home/mysql/mysql_data/mysql/procs_priv.MYD
lrwx------ 1 root root 64 Feb 13 18:58 25 ->
/home/mysql/mysql_data/mysql/servers.MYI
lrwx------ 1 root root 64 Feb 13 18:58 26 ->
/home/mysql/mysql_data/mysql/servers.MYD
lrwx------ 1 root root 64 Feb 13 18:58 27 ->
/home/mysql/mysql_data/mysql/event.MYI
lrwx------ 1 root root 64 Feb 13 18:58 28 ->
/home/mysql/mysql_data/mysql/event.MYD
lrwx------ 1 root root 64 Feb 13 18:58 29 -> socket:[1245325]
lrwx------ 1 root root 64 Feb 13 18:58 3 -> /home/mysql/mysql_data/ibdata1
lrwx------ 1 root root 64 Feb 13 18:58 30 ->
/home/mysql/mysql_data/text_sort/local_list.MYI
lrwx------ 1 root root 64 Feb 13 18:58 31 ->
/home/mysql/mysql_data/text_sort/local_list.MYD
lrwx------ 1 root root 64 Feb 13 18:58 32 ->
/home/mysql/mysql_data/text_sort/local_list_sorted.MYI
lrwx------ 1 root root 64 Feb 13 18:58 33 ->
/home/mysql/mysql_data/text_sort/local_list_sorted.MYD
lrwx------ 1 root root 64 Feb 13 18:58 34 ->
/home/mysql/mysql_data/text_sort/tar_list.MYI
lrwx------ 1 root root 64 Feb 13 18:58 35 ->
/home/mysql/mysql_data/text_sort/tar_list.MYD
lrwx------ 1 root root 64 Feb 13 18:58 36 -> /home/mysql/tmp/MYbUgIFT
(deleted)
lrwx------ 1 root root 64 Feb 13 18:58 37 -> /home/mysql/tmp/MYizt5rL
(deleted)
lrwx------ 1 root root 64 Feb 13 18:58 38 -> socket:[1249477]
lrwx------ 1 root root 64 Feb 13 18:58 39 -> socket:[1340698]
lrwx------ 1 root root 64 Feb 13 18:58 4 -> /home/mysql/tmp/ibvjZa8E
(deleted)
lrwx------ 1 root root 64 Feb 13 18:58 40 ->
/home/mysql/mysql_data/text_sort/local_list.MYD
lrwx------ 1 root root 64 Feb 13 18:58 41 ->
/home/mysql/mysql_data/text_sort/local_list_sorted.MYD
lrwx------ 1 root root 64 Feb 13 18:58 5 -> /home/mysql/tmp/ib08cXW2
(deleted)
lrwx------ 1 root root 64 Feb 13 18:58 6 -> /home/mysql/tmp/ibtcHJLq
(deleted)
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 at gala ~]#

Now the files of interest are the ones marked deleted in /home/mysql/tmp .
Now how do I tell what their size is?

Thanks.

Boris.