Date: Wed, 21 Mar 2007 14:29:26 -0400 From: "Jim Flowers" <jflowers@ezo.net> To: Chuck Swiger <cswiger@mac.com> Cc: freebsd-questions@freebsd.org Subject: Re: Mysql Unlinked Files Message-ID: <20070321181449.M32585@ezo.net> In-Reply-To: <89B49790-595F-4082-8D0B-26589BE4FE4F@mac.com> References: <20070321141600.M10788@ezo.net> <89B49790-595F-4082-8D0B-26589BE4FE4F@mac.com>
next in thread | previous in thread | raw e-mail | index | archive | help
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@ezo.net> -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20070321181449.M32585>