Re: Mysql Unlinked Files
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 mysql6u VREG 4,170 09 /var (/ > > dev/aacd0s1d) > > mysqld 6179 mysql7u VREG 4,170 0 23 /var (/ > > dev/aacd0s1d) > > mysqld 6179 mysql 11u VREG 4,170 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 <[EMAIL PROTECTED]> -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: Mysql Unlinked Files
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 mysql6u VREG 4,170 09 /var (/ dev/aacd0s1d) mysqld 6179 mysql7u VREG 4,170 0 23 /var (/ dev/aacd0s1d) mysqld 6179 mysql 11u VREG 4,170 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 ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Mysql Unlinked Files
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 mysql6u VREG 4,170 09 /var (/dev/aacd0s1d) mysqld 6179 mysql7u VREG 4,170 0 23 /var (/dev/aacd0s1d) mysqld 6179 mysql 11u VREG 4,170 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? Thanks. -- Jim Flowers <[EMAIL PROTECTED]> -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"