From owner-freebsd-questions@FreeBSD.ORG Thu Jun 19 15:08:58 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 BBBBB1065671 for ; Thu, 19 Jun 2008 15:08:58 +0000 (UTC) (envelope-from prvs=pschmehl_lists=04997c689@tx.rr.com) Received: from ip-relay-002.utdallas.edu (ip-relay-002.utdallas.edu [129.110.20.112]) by mx1.freebsd.org (Postfix) with ESMTP id 7EF7A8FC15 for ; Thu, 19 Jun 2008 15:08:58 +0000 (UTC) (envelope-from prvs=pschmehl_lists=04997c689@tx.rr.com) X-Group: RELAYLIST X-IronPort-AV: E=Sophos;i="4.27,672,1204524000"; d="scan'208";a="2096231" Received: from smtp3.utdallas.edu ([129.110.20.110]) by ip-relay-002.utdallas.edu with ESMTP; 19 Jun 2008 09:40:12 -0500 Received: from utd65257.utdallas.edu (utd65257.utdallas.edu [129.110.3.28]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by smtp3.utdallas.edu (Postfix) with ESMTPSA id 8C2A223DEA for ; Thu, 19 Jun 2008 09:40:12 -0500 (CDT) Date: Thu, 19 Jun 2008 09:40:12 -0500 From: Paul Schmehl To: freebsd-questions@freebsd.org Message-ID: In-Reply-To: <4859FC8F.5020308@ibctech.ca> References: <20080619035949.GB8205@shepherd> <4859FC8F.5020308@ibctech.ca> X-Mailer: Mulberry/4.0.6 (Linux/x86) X-Munged-Reply-To: Figure it out MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Subject: Re: /var full X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: Paul Schmehl List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 19 Jun 2008 15:08:58 -0000 --On Thursday, June 19, 2008 02:28:31 -0400 Steve Bertrand wrote: > 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. I wouldn't be the one to correct you. My knowledge of inodes is rudimentary at best. :-) > > 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? > As you can see from the df -i I posted (to which you responded), inode exhaustion is not an issue. I'm leaning toward some sort of bug in mysql version 5.0.51 which creates a temporary file (in the wrong place) and then doesn't release it until it exhausts the space on the drive. In any case, I'm going to report it to the mysql folks as such and hope they can figure out what the cause is. -- Paul Schmehl As if it wasn't already obvious, my opinions are my own and not those of my employer.