From owner-freebsd-questions@FreeBSD.ORG Fri Sep 10 17:12:35 2004 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 328CC16A4CE for ; Fri, 10 Sep 2004 17:12:35 +0000 (GMT) Received: from mx.tele-kom.ru (mx.tele-kom.ru [213.80.148.6]) by mx1.FreeBSD.org (Postfix) with SMTP id CBA5A43D49 for ; Fri, 10 Sep 2004 17:12:33 +0000 (GMT) (envelope-from doublef@tele-kom.ru) Received: (qmail 866 invoked by uid 555); 10 Sep 2004 17:13:39 -0000 Received: from shark (213.80.148.205) by t-k.ru with TeleMail/2 id 1094836418-812 for jerrymc@clunix.cl.msu.edu; Fri, 10 Sep 21:13:38 2004 +0400 (MSD) Received: by shark (Postfix, from userid 1000) id B670A31F; Fri, 10 Sep 2004 21:12:17 +0400 (MSD) Date: Fri, 10 Sep 2004 21:12:16 +0400 From: Sergey Zaharchenko To: Paul Schmehl Message-ID: <20040910171216.GA2288@shark.localdomain> References: <200409101523.i8AFNCr07551@clunix.cl.msu.edu> <6EF10372BDC3E432AA51B3AF@utd49554.utdallas.edu> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="d6Gm4EdcadzBjdND" Content-Disposition: inline In-Reply-To: <6EF10372BDC3E432AA51B3AF@utd49554.utdallas.edu> User-Agent: Mutt/1.4.2.1i X-Listening-To: /Machina_Vremeni/Tam_gde_budet_noviy_den cc: Jerry McAllister cc: FreeBSD-questions cc: shahid@zonewave.net Subject: Re: Phantom /var full messages X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 10 Sep 2004 17:12:35 -0000 --d6Gm4EdcadzBjdND Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Sep 10, 2004 at 11:57:57AM -0500, Paul Schmehl probably wrote: > --On Friday, September 10, 2004 11:23:11 AM -0400 Jerry McAllister=20 > wrote: > >If you are doing database stuff, then I can't imagine having a /var > >of less than a few GB, unless you move a lot of stuff out of /var and > >create links. See some recent previous posts on the subject. >=20 > (BTW, /var is 31GB) > ^^^^^^^^^^^^^^^^^^^ > Did you miss this? Actually, I mentioned that 31 is `a few' for some values of `a few' earlier. I have no experience with mysql, but I'd think something is creating tons of smaller files and not closing them, rather than a program keeping a 31G file open (inflating 400M to 31G should be difficult even for mysql). Try (yet another ugly fstat hack) # fstat | grep /var | grep mysqld | wc -l to show the number of files open by the mysqld process (or any other process if you change the name) in the /var fs. Did you try asking on a mysql-related list? > > > > >=20 > Paul Schmehl (pauls@utdallas.edu) > Adjunct Information Security Officer > The University of Texas at Dallas > AVIEN Founding Member > http://www.utdallas.edu > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.o= rg" --=20 DoubleF "There was a boy called Eustace Clarence Scrubb, and he almost deserved it." -- C. S. Lewis, The Chronicles of Narnia --d6Gm4EdcadzBjdND Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (FreeBSD) iD8DBQFBQeBvwo7hT/9lVdwRAsjOAJ0U9hD9ULDLQRPfqG3BavqBZitKvwCfeKn/ KNJx5x7p3+hNZklk7xhfUJw= =SXpi -----END PGP SIGNATURE----- --d6Gm4EdcadzBjdND--