From owner-freebsd-database@FreeBSD.ORG Wed Oct 12 21:08:07 2005 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 66F0916A41F; Wed, 12 Oct 2005 21:08:07 +0000 (GMT) (envelope-from kris@obsecurity.org) Received: from elvis.mu.org (elvis.mu.org [192.203.228.196]) by mx1.FreeBSD.org (Postfix) with ESMTP id 9750543D6A; Wed, 12 Oct 2005 21:08:00 +0000 (GMT) (envelope-from kris@obsecurity.org) Received: from obsecurity.dyndns.org (elvis.mu.org [192.203.228.196]) by elvis.mu.org (Postfix) with ESMTP id 54EA71A3C24; Wed, 12 Oct 2005 14:08:00 -0700 (PDT) Received: by obsecurity.dyndns.org (Postfix, from userid 1000) id 2DC505132E; Wed, 12 Oct 2005 17:07:58 -0400 (EDT) Date: Wed, 12 Oct 2005 17:07:57 -0400 From: Kris Kennaway To: NMH Message-ID: <20051012210757.GA97184@xor.obsecurity.org> References: <20051012201622.49704.qmail@web32905.mail.mud.yahoo.com> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="wac7ysb48OaltWcw" Content-Disposition: inline In-Reply-To: <20051012201622.49704.qmail@web32905.mail.mud.yahoo.com> User-Agent: Mutt/1.4.2.1i Cc: FreeBSD-DataBase , questions Subject: Re: Mysql server not able to stay running on anything but Linux? 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: Wed, 12 Oct 2005 21:08:07 -0000 --wac7ysb48OaltWcw Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Oct 12, 2005 at 01:16:22PM -0700, NMH wrote: > Hi > I am stuck with a delema and I feel like a damn > troll. But.. I have a Mysql Database that I posted > about earlier. It seems that it is only able to not > die by running on BSD 4.11 with Linux Threads. My boss > is convinced this means that Linux is better for MySQL > and wants that installed now. > We even got a support contact from Mysql that so far > has gotten us nothing for almost a month while our > production database server died up to 3 times a day. > (and lots of we're looking into it's) > =20 > We were running fine but a little slow on FreeBSD > 5.1-P11 and MySQL 4.0.18.(apperantly before a big Lib > change) We had to move quicker than we wanted to a new > server running FreeBSD 5.4 and MySQL 4.11 (becouse of > a dual HD death) Under production load the new 5.4 > server fell over regulary. It has only now become > stable by wiping it and running it on FreeBSD 4.11 > with Linux Threads. (it regularly has over 400+ > threads) Unfortunately you'll need to provide details of how it "fell over" (e.g. panic messages + backtraces). You might have better luck with 6.0-RELEASE or 5.4-STABLE, since a number of bugs have been fixed in 5.4-RELEASE..but without more details it's impossible to say whether that will help, or if you're encountering something genuinely new. > Can anyone help or offer assistance to help track > this down? Perhaps also any annecdotes or examples I > can show my boss that other people have as busy MYSQL > databases on BSD 5.X. We paid 3K to Mysql for help and > so far they have been unable to offer any clues as to > why ours will not stay stable on anything but Linux > threads. I feel really sad that so far no one has > responded to my posts and it feels like a victory for > linux.=20 If I was your boss I'd be asking why mysql hasn't delivered on their support contract. Kris --wac7ysb48OaltWcw Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (FreeBSD) iD8DBQFDTXssWry0BWjoQKURAlzeAKDW0m8IVWSGepPVTYbnvDtP9p7pPQCguIBa 91ehGxFGTyfWLwqaGyaB03k= =wYZi -----END PGP SIGNATURE----- --wac7ysb48OaltWcw--