Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 01 May 2007 22:44:42 +0200
From:      Olivier Mueller <om-lists-bsd@omx.ch>
To:        Tom Evans <tevans.uk@googlemail.com>
Cc:        freebsd-stable@freebsd.org
Subject:   Re: mysql frequently crash on 6.2
Message-ID:  <1178052282.1279.6.camel@bigapple.omnis.ch>
In-Reply-To: <1178033180.1239.13.camel@zoot.mintel.co.uk>
References:  <d018a9bd0704301811n47a34e7ax457f527f083e49e0@mail.gmail.com> <20070501020721.GA44472@icarus.home.lan> <d018a9bd0704302358h1cb35046i2c4498fcb8fec5d7@mail.gmail.com> <53892.209.47.38.69.1178028723.squirrel@wettoast.dyndns.org> <1178033180.1239.13.camel@zoot.mintel.co.uk>

next in thread | previous in thread | raw e-mail | index | archive | help
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




Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1178052282.1279.6.camel>