From owner-freebsd-questions@FreeBSD.ORG Wed Mar 21 18:26:42 2007 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 700F216A40E for ; Wed, 21 Mar 2007 18:26:42 +0000 (UTC) (envelope-from jflowers@ezo.net) Received: from mxgf1.ezo.net (mxgf1.ezo.net [12.156.78.18]) by mx1.freebsd.org (Postfix) with ESMTP id 1E7BD13C4D3 for ; Wed, 21 Mar 2007 18:26:41 +0000 (UTC) (envelope-from jflowers@ezo.net) Received: from mbox.ezo.net (localhost [127.0.0.1]) by mxgf1.ezo.net (8.13.6/8.13.6) with ESMTP id l2LIQGUg002277; Wed, 21 Mar 2007 14:26:16 -0400 (EDT) (envelope-from jflowers@ezo.net) Received: from 12.156.78.21 ([12.156.78.21] helo=mbox.ezo.net) by MXSentry; 21 Mar 2007 14:26:16 -0400 From: "Jim Flowers" To: Chuck Swiger Date: Wed, 21 Mar 2007 14:29:26 -0400 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> X-Mailer: OpenWebMail 2.52 20060502 X-OriginatingIP: 65.25.65.37 (jflowers@ezo.net) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-Assp-Spam-Prob: 0.00000 X-Assp-Whitelisted: Yes X-Assp-Envelope-From: jflowers@ezo.net X-MXSentry-MailScanner-Information: Please contact the ISP for more information X-MXSentry-MailScanner: Found to be clean X-MXSentry-MailScanner-SpamCheck: not spam, SpamAssassin (not cached, score=-2.106, required 4, autolearn=not spam, AWL 0.49, BAYES_00 -2.60, SPF_HELO_PASS -0.00, SPF_PASS -0.00) X-MXSentry-MailScanner-From: jflowers@ezo.net X-Spam-Status: No Cc: freebsd-questions@freebsd.org Subject: Re: Mysql Unlinked Files X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: jflowers@ezo.net List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 21 Mar 2007 18:26:42 -0000 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 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.