From owner-freebsd-stable@FreeBSD.ORG Tue May 1 20:44:47 2007 Return-Path: X-Original-To: freebsd-stable@freebsd.org Delivered-To: freebsd-stable@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 0428116A400 for ; Tue, 1 May 2007 20:44:47 +0000 (UTC) (envelope-from om-lists-bsd@omx.ch) Received: from omega.omnis.ch (omega.omnis.ch [195.134.143.43]) by mx1.freebsd.org (Postfix) with SMTP id 48AB613C45B for ; Tue, 1 May 2007 20:44:45 +0000 (UTC) (envelope-from om-lists-bsd@omx.ch) Received: (qmail 30007 invoked from network); 1 May 2007 20:44:42 -0000 Received: from bigapple.omnis.ch ([195.134.148.35]) by omega.omnis.ch ([195.134.143.43]) with ESMTP via TCP; 01 May 2007 20:44:42 -0000 From: Olivier Mueller To: Tom Evans In-Reply-To: <1178033180.1239.13.camel@zoot.mintel.co.uk> References: <20070501020721.GA44472@icarus.home.lan> <53892.209.47.38.69.1178028723.squirrel@wettoast.dyndns.org> <1178033180.1239.13.camel@zoot.mintel.co.uk> Content-Type: text/plain Date: Tue, 01 May 2007 22:44:42 +0200 Message-Id: <1178052282.1279.6.camel@bigapple.omnis.ch> Mime-Version: 1.0 X-Mailer: Evolution 2.6.0 Content-Transfer-Encoding: 7bit Cc: freebsd-stable@freebsd.org Subject: Re: mysql frequently crash on 6.2 X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 01 May 2007 20:44:47 -0000 Hi, On Tue, 2007-05-01 at 16:26 +0100, Tom Evans wrote: > On Tue, 2007-05-01 at 10:12 -0400, Mike Jakubik wrote: > > I've had problems with 6.2 and mysql on a large server as well. High CPU > > usage and crashes. I switched the threading library to libthr and the > > problems went away. > If you don't know how to switch what threading library is used, > libmap.conf(5) should explain it, or here is what we use: [...] Thanks for the input! Do you have to recompile the mysql server after the change, or just to restart it to validate the change? And does anyone know if it will help in case of such errors (FreeBSD) 6.0 and 6.1, latest 5.x mysqld) : 070426 0:11:30 [ERROR] /usr/local/libexec/mysqld: Incorrect key file for table './pia/pia_ads.MYI'; try to repair it [root@pidb1 /var/db/mysql/pia]# ls -la pia_ads.* -rw-rw---- 1 mysql mysql 216427164 Apr 25 23:59 pia_ads.MYD -rw-rw---- 1 mysql mysql 561668096 Apr 26 00:15 pia_ads.MYI -rw-rw---- 1 mysql mysql 40200 Feb 25 23:38 pia_ads.frm The table is not that big, but there are 48 (!) indexes. And the problem only occurs on high load, after a few minutes/hours, it's hard to reproduce "on request" (I wish I could, to submit a bugreport to the mysql devs). Regards, Olivier