Skip site navigation (1)Skip section navigation (2)
Date:      Thu, 23 Mar 2006 00:19:07 -0800
From:      "Justin Bastedo" <justin.bastedo@gmail.com>
To:        "Kurt Jaeger" <lists@complx.lf.net>
Cc:        freebsd-database@freebsd.org
Subject:   Re: MySQL 4.1 SIGBUS failiure with FreeBSD 6.0
Message-ID:  <8a5255240603230019r540130d5l1ec603c5a53b1683@mail.gmail.com>
In-Reply-To: <20060323054831.GA1342@complx.LF.net>
References:  <20060322215109.GC8904@gkar.earthdome.org> <20060323054831.GA1342@complx.LF.net>

next in thread | previous in thread | raw e-mail | index | archive | help
There was also this thread on ther freebsd-database list a while back.

http://www.daemonnews.org/mailinglists/FreeBSD/freebsd-database/msg01178.ht=
ml

couldn't search through the actual freebsd site for some reason but
google found it.

There the author said dropping back down to 4.11 seemed to solve the
problem. I am running a MySQL 5 server on a dual, dualcore amd 64
system with a max queries persecond i think we hit was in the 200 -
300 range. If I remember back to the conversations then, I think the
problem started to surface at about 500 or so queries persecond. I
haven't had any problems with MySQL 5 and I really think its worth the
step up. It seems some people at MySQL looked into the problem for
that thread I linked to but i don't know if any type of solution was
found on the MySQL side. It just seems the 4.x doesn't like the high
loads on FreeBSD for some reason.



On 3/22/06, Kurt Jaeger <lists@complx.lf.net> wrote:
> Hi!

--
Justin Bastedo At Gmail Dot Com
--------------------------------------------------
http://www.thebastedo.com


>
> On Wed, Mar 22, 2006 at 03:51:10PM -0600, Glenn Nielsen wrote:
> > MySQL 4.1 SIGBUS failiure with FreeBSD 6.0
> [...]
> > (gdb) bt
> > #0  0x285292b7 in pthread_testcancel () from /usr/lib/libpthread.so.2
> > #1  0x285190a2 in sigaction () from /usr/lib/libpthread.so.2
> > #2  0x2851318d in pthread_kill () from /usr/lib/libpthread.so.2
> [...]
> > We are using mysql-server-4.1.18_2 from ports with native threads.
>



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