Date: Thu, 31 Aug 2000 14:42:24 -0500 (CDT) From: Don Read <dread@texas.net> To: Dan Langille <dan@langille.org> Cc: questions@FreeBSD.ORG Subject: RE: /var fills up with SQL191e_0.ISD, SQL191e_0.ISM Message-ID: <XFMail.000831144224.dread@texas.net> In-Reply-To: <200008311101.XAA81403@ducky.nz.freebsd.org>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?XFMail.000831144224.dread>