From owner-freebsd-questions Tue Aug 29 2:40:23 2000 Delivered-To: freebsd-questions@freebsd.org Received: from ducky.nz.freebsd.org (ns1.unixathome.org [203.79.82.27]) by hub.freebsd.org (Postfix) with ESMTP id 5853337B424 for ; Tue, 29 Aug 2000 02:40:19 -0700 (PDT) Received: from wocker (wocker.int.nz.freebsd.org [192.168.0.99]) by ducky.nz.freebsd.org (8.9.3/8.9.3) with ESMTP id VAA66582 for ; Tue, 29 Aug 2000 21:40:17 +1200 (NZST) Message-Id: <200008290940.VAA66582@ducky.nz.freebsd.org> From: "Dan Langille" Organization: langille.org To: questions@FreeBSD.org Date: Tue, 29 Aug 2000 21:40:16 +1200 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: /var fills up with SQL191e_0.ISD, SQL191e_0.ISM Reply-To: dan@langille.org X-mailer: Pegasus Mail for Win32 (v3.12c) Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG 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? The box is: FreeBSD set.freshports.org 4.1-STABLE FreeBSD 4.1-STABLE #0: Sat Jul 29 20:15:07 NZST 2000 root@set.freshports.org:/usr/src/sys/compile/BUFFIPSEC i386 It's running: apache-1.3.12, mod_php-3.0.16, mysql-server-3.22.32. If I stop mysqld and remove the files in question, /var goes back to about 15%. If I check the apache logs around the time at which the first "/var full" messages start appearing, I see nothing which jumps out. -- Dan Langille The FreeBSD Diary - http://www.freebsddiary.org/ FreshPorts - http://freshports.org/ To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message