From owner-freebsd-questions Thu Aug 31 14:26: 9 2000 Delivered-To: freebsd-questions@freebsd.org Received: from mw4.texas.net (mw4.texas.net [206.127.30.14]) by hub.freebsd.org (Postfix) with ESMTP id 770CA37B424 for ; Thu, 31 Aug 2000 14:26:05 -0700 (PDT) Received: from localhost.texas.net (tcnet24-032.austin.texas.net [209.99.97.158]) by mw4.texas.net (2.4/2.4) with ESMTP id QAA12801; Thu, 31 Aug 2000 16:25:37 -0500 (CDT) Received: (from dread@localhost) by localhost.texas.net (8.9.3/8.9.3) id OAA27347; Thu, 31 Aug 2000 14:42:25 -0500 (CDT) (envelope-from dread) Message-ID: X-Mailer: XFMail 1.4.0 on FreeBSD X-Priority: 3 (Normal) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit MIME-Version: 1.0 In-Reply-To: <200008311101.XAA81403@ducky.nz.freebsd.org> Date: Thu, 31 Aug 2000 14:42:24 -0500 (CDT) From: Don Read To: Dan Langille Subject: RE: /var fills up with SQL191e_0.ISD, SQL191e_0.ISM Cc: questions@FreeBSD.ORG Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On 31-Aug-00 Dan Langille wrote: > On 30 Aug 2000, at 20:34, Don Read wrote: > >> These look like temporary mysql files, is your mysql server crashing on a >> particular query ? > > Don, thanks for the reply. I think I've figured this out. I believe it was > "normal" processing. After running some tests, I noticed /var jump to > 50% easily. If more than a couple of those queries ran concurrently, I'm > sure /var would fill to 100%. /var was only 20MB, so I gave it more > space. It's been about 24hrs since that move, and all seems well so far. > > Does that explanation sound plausible? > yes it does. 20M /var partition ? very thin, unless you turn it into a link-farm. > See http://freebsddiary.org/file-system-full.html for details. > BTW, to stop mysqld : mysqladmin shutdown Regards, -- Don Read dread@texas.net --- The problem with people who have no vices is that you can be sure they're going to have some pretty annoying virtues. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message