From owner-freebsd-database@FreeBSD.ORG Thu Mar 23 08:19:32 2006 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 8D38E16A41F for ; Thu, 23 Mar 2006 08:19:32 +0000 (UTC) (envelope-from justin.bastedo@gmail.com) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.198]) by mx1.FreeBSD.org (Postfix) with ESMTP id 16C6C43D4C for ; Thu, 23 Mar 2006 08:19:31 +0000 (GMT) (envelope-from justin.bastedo@gmail.com) Received: by wproxy.gmail.com with SMTP id i5so603351wra for ; Thu, 23 Mar 2006 00:19:31 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=q9CcxDZHMGuR0s1SBTuOaTWeMEgK/p2Cpgw83ULraPk3ofJETICXAdAQUZNfemjPDx/EsD74bDBuhDRlzyS+I7Cgm7KDqM6+lQMB+sKyHJY467ytFx8f8bYUzZd8YSFVdko53gT7KXoJbMQnYpphKE6brJsPxFmvUwv+CNnc8TQ= Received: by 10.35.50.9 with SMTP id c9mr2361995pyk; Thu, 23 Mar 2006 00:19:07 -0800 (PST) Received: by 10.35.131.1 with HTTP; Thu, 23 Mar 2006 00:19:07 -0800 (PST) Message-ID: <8a5255240603230019r540130d5l1ec603c5a53b1683@mail.gmail.com> Date: Thu, 23 Mar 2006 00:19:07 -0800 From: "Justin Bastedo" To: "Kurt Jaeger" In-Reply-To: <20060323054831.GA1342@complx.LF.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <20060322215109.GC8904@gkar.earthdome.org> <20060323054831.GA1342@complx.LF.net> Cc: freebsd-database@freebsd.org Subject: Re: MySQL 4.1 SIGBUS failiure with FreeBSD 6.0 X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 23 Mar 2006 08:19:32 -0000 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 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. >