Mysql Unlinked Files

[Jim Flowers]

mysql-server stop removes unreferenced files and links, however, mysql-server
start just creates them again (of course with higher inodes).  The link count
does go down some over time (now at 54).

Must be something in the startup routine.  Just thought someone might have run
into it before and figured it out.

Thanks for responding.

On Wed, 21 Mar 2007 10:49:06 -0700, Chuck Swiger wrote
> On Mar 21, 2007, at 7:24 AM, Jim Flowers wrote:
> > On startup of mysql-server 5.0.12 on FBSD 5.4-RELEASE my server  
> > always has 3
> > 0-size unreferenced files with 69 links reported by lsof +L1.
> >
> > 23 groups of:
> > mysqld  6179 mysql    6u  VREG   4,17        0     0    9 /var (/ 
> > dev/aacd0s1d)
> > mysqld  6179 mysql    7u  VREG   4,17        0     0   23 /var (/ 
> > dev/aacd0s1d)
> > mysqld  6179 mysql   11u  VREG   4,17        0     0   24 /var (/ 
> > dev/aacd0s1d)
> >
> > This doesn't cause problems but I am curious as to what is causing  
> > it and if I
> > could do anything to fix it?
> 
> Do they go away if you kill mysqld?  If not, consider rebooting to  
> single-user mode or off of a CD, and running fsck by hand on /var...
> 
> -- 
> -Chuck
> 
> -- 
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.


--
Jim Flowers <jflowers at ezo.net>


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.