From owner-freebsd-questions@FreeBSD.ORG Thu Jun 19 06:27:22 2008 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 21E151065676 for ; Thu, 19 Jun 2008 06:27:22 +0000 (UTC) (envelope-from steve@ibctech.ca) Received: from ibctech.ca (v6.ibctech.ca [IPv6:2607:f118::b6]) by mx1.freebsd.org (Postfix) with SMTP id CEA478FC15 for ; Thu, 19 Jun 2008 06:27:21 +0000 (UTC) (envelope-from steve@ibctech.ca) Received: (qmail 22253 invoked by uid 89); 19 Jun 2008 06:27:36 -0000 Received: from unknown (HELO ?IPv6:2607:f118::5?) (steve@ibctech.ca@2607:f118::5) by 2607:f118::b6 with ESMTPA; 19 Jun 2008 06:27:36 -0000 Message-ID: <4859FC8F.5020308@ibctech.ca> Date: Thu, 19 Jun 2008 02:28:31 -0400 From: Steve Bertrand User-Agent: Thunderbird 2.0.0.14 (Windows/20080421) MIME-Version: 1.0 To: Paul Schmehl References: <20080619035949.GB8205@shepherd> In-Reply-To: X-Enigmail-Version: 0.95.6 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cc: freebsd-questions@freebsd.org Subject: Re: /var full X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 19 Jun 2008 06:27:22 -0000 Paul Schmehl wrote: > --On June 18, 2008 11:59:49 PM -0400 Sahil Tandon wrote: >> Also, what is the output of 'df -i /var'? >> > > # df -i /var/ > Filesystem 1K-blocks Used Avail Capacity iused ifree %iused > Mounted on > /dev/da1s1d 283737842 5397568 255641248 2% 20350 36673664 0% /var > >> See recent thread on FreeBSD Forums for context: >> >> http://www.freebsdforums.org/forums/printthread.php?t=58071 > > Thanks. At least I know I'm not the only one to have run into this oddity. > > I'm not that knowledgeable of inodes. My understanding is they are > destroyed once a file is no longer in use. Is that correct? Is there > any sort of history kept of file system activity that would identify > what filename was identified by the inumbers listed in dmesg.today? Or > is that vain hope? > > This is a 6.2 RELEASE system. (Looks like it's time to upgrade to 7.0 > STABLE.) I am not in any which way certain changing major revision numbers will affect the file system in any which way. I am also not very knowledgeable in regards to inodes, but I do know that they can run out before disk space does. From what I understand, 1MB of filespace will take up X inodes. If 1MB of file size is fragmented, it could take up X multiplied by N number of inodes, that could include a large portion of wasted whitespace. Please correct me if I am wrong. Off the top of my head, with no testing or researching behind me, what happens if: - stop mysqld - note perms of filesystem - cp -R /var/db /another/location/with/space - rm -r /var/db/* - fsck /dev/location-of-var - cp -R /copy/of/db/dir /var/db - reset perms - start mysqld ... does that free up some inodes? Steve