From owner-freebsd-stable@FreeBSD.ORG Wed May 2 08:34:27 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 DE90C16A400 for ; Wed, 2 May 2007 08:34:26 +0000 (UTC) (envelope-from tevans.uk@googlemail.com) Received: from ik-out-1112.google.com (ik-out-1112.google.com [66.249.90.180]) by mx1.freebsd.org (Postfix) with ESMTP id 6694D13C4AE for ; Wed, 2 May 2007 08:34:26 +0000 (UTC) (envelope-from tevans.uk@googlemail.com) Received: by ik-out-1112.google.com with SMTP id b35so57480ika for ; Wed, 02 May 2007 01:34:25 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=googlemail.com; s=beta; h=domainkey-signature:received:received:subject:from:to:cc:in-reply-to:references:content-type:date:message-id:mime-version:x-mailer; b=l3sM5pXuFUSXzMmuoyQAe9qrp1fWJyvODA/kQVUIM3Qf6EJB2VnG+P7f3zmaKDuYWosHoPrl+GlQwBV7ec0PaWtyHQjU6S+KeHAeKTTyFBUhA0b7OYzXOPOqz5K7f4sn6+f3EDXfhBinqr3CVu3SHjuTf5sP5YSYzbRKRPGpZEQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=googlemail.com; s=beta; h=received:subject:from:to:cc:in-reply-to:references:content-type:date:message-id:mime-version:x-mailer; b=tSq/ZwvyKE5GfMfWm67kp5uRYK6YwyVsNdPUtBh8CdZqlKGFf4jx+e19G3xX91HLj/A5+foxMkPidTq6Lov3P9lhCkzG6bkQiBdYEiQpK2qpq7Qdf5JziPflUrqwxdRubDOsBRM0ePAu7t+fiGDGRoQb/8S1ayjUeyhnXsZWnQQ= Received: by 10.82.188.15 with SMTP id l15mr927308buf.1178094865276; Wed, 02 May 2007 01:34:25 -0700 (PDT) Received: from ?127.0.0.1? ( [217.206.187.79]) by mx.google.com with ESMTP id b33sm1852901ika.2007.05.02.01.34.21; Wed, 02 May 2007 01:34:24 -0700 (PDT) From: Tom Evans To: Olivier Mueller In-Reply-To: <1178052282.1279.6.camel@bigapple.omnis.ch> References: <20070501020721.GA44472@icarus.home.lan> <53892.209.47.38.69.1178028723.squirrel@wettoast.dyndns.org> <1178033180.1239.13.camel@zoot.mintel.co.uk> <1178052282.1279.6.camel@bigapple.omnis.ch> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-yarqMf8V0Pmp+IBD25NH" Date: Wed, 02 May 2007 09:34:18 +0100 Message-Id: <1178094858.1217.5.camel@zoot.mintel.co.uk> Mime-Version: 1.0 X-Mailer: Evolution 2.10.0 FreeBSD GNOME Team Port 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: Wed, 02 May 2007 08:34:27 -0000 --=-yarqMf8V0Pmp+IBD25NH Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Tue, 2007-05-01 at 22:44 +0200, Olivier Mueller wrote: > Hi, >=20 > 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: [...] >=20 > Thanks for the input! Do you have to recompile the mysql server after > the change, or just to restart it to validate the change?=20 >=20 >=20 > And does anyone know if it will help in case of such errors (FreeBSD) > 6.0 and 6.1, latest 5.x mysqld) : >=20 > 070426 0:11:30 [ERROR] /usr/local/libexec/mysqld: Incorrect key file > for table './pia/pia_ads.MYI'; try to repair it > =20 > [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 >=20 > 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).=20 >=20 > Regards, > Olivier >=20 You shouldn't have to recompile mysql, just restart (as long as it is dynamically linked; default from ports is). I'd always use mysql from ports, as it is more targeted to freebsd. We saw key file errors when using mysql 5.0(.27 iirc), but we have in fact moved all of our production boxes back to mysql 4.0, as 5.0 branch seemed far too unstable, slow and error prone (not wanting to start a holy war here, just our experiences :). Cheers Tom --=-yarqMf8V0Pmp+IBD25NH Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (FreeBSD) iD8DBQBGOE0GlcRvFfyds/cRAljcAJ9BtVoCYzhcjvP8k1Pdnz0wUmX3YQCghps5 Bb5qWKzKqTZxShGSNKI6Axw= =Hr3c -----END PGP SIGNATURE----- --=-yarqMf8V0Pmp+IBD25NH--