From owner-freebsd-questions Wed Aug 30 19:21:50 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 C8A9937B42C for ; Wed, 30 Aug 2000 19:21:48 -0700 (PDT) Received: from localhost.texas.net (tcnet24-031.austin.texas.net [209.99.97.157]) by mw4.texas.net (2.4/2.4) with ESMTP id VAA02764; Wed, 30 Aug 2000 21:21:40 -0500 (CDT) Received: (from dread@localhost) by localhost.texas.net (8.9.3/8.9.3) id UAA10847; Wed, 30 Aug 2000 20:35:06 -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: <200008290940.VAA66582@ducky.nz.freebsd.org> Date: Wed, 30 Aug 2000 20:34:36 -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 29-Aug-00 Dan Langille wrote: > Twice, in the past 24 hours, one of my webservers has filled up on /var. > When I check /var/tmp, I see lots of these (ignore the owner/group, I've > since changed that): > > -rw-rw---- 1 dan dan 2097152 Aug 29 19:44 SQL17ac_0.ISD > -rw-rw---- 1 dan dan 1024 Aug 29 19:00 SQL17ac_0.ISM > -rw-rw---- 1 dan dan 1966080 Aug 29 19:45 SQL17ae_0.ISD > -rw-rw---- 1 dan dan 1024 Aug 29 19:01 SQL17ae_0.ISM > -rw-rw---- 1 dan dan 1572864 Aug 29 19:44 SQL17b0_0.ISD > -rw-rw---- 1 dan dan 1024 Aug 29 19:01 SQL17b0_0.ISM > -rw-rw---- 1 dan dan 1441792 Aug 29 19:44 SQL17b2_0.ISD > -rw-rw---- 1 dan dan 1024 Aug 29 19:01 SQL17b2_0.ISM > > In all, there are 70 such files. Most of the .ISD have size zero. Many of > the .ISM are 1024 but a few are large like the above. > > What are these files? Why are they being created? > These look like temporary mysql files, is your mysql server crashing on a particular query ? check /var/db/mysql/*.err (default, your data-dir may be elsewhere). 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