From owner-freebsd-database@FreeBSD.ORG Wed Oct 12 22:55:45 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 E788716A41F for ; Wed, 12 Oct 2005 22:55:45 +0000 (GMT) (envelope-from drumslayer2@yahoo.com) Received: from web32901.mail.mud.yahoo.com (web32901.mail.mud.yahoo.com [68.142.206.48]) by mx1.FreeBSD.org (Postfix) with SMTP id 273F943D48 for ; Wed, 12 Oct 2005 22:55:45 +0000 (GMT) (envelope-from drumslayer2@yahoo.com) Received: (qmail 83675 invoked by uid 60001); 12 Oct 2005 22:55:44 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:Cc:MIME-Version:Content-Type:Content-Transfer-Encoding; b=2PqmFfYaF1s/NngGNVr9ryHnJRI6gk2XrV7qbf9y9u1QmvrPeXqt6Cq+5/QxFguafVSyWaemMYW7Dx0y9RU2S9O4p1ZtuAW91AANBJKjxOnZzvcnTEKBMTsXtoVL4VK89xA1OR0zvRfQgOyrFDnoqFDKlIOfvtDgdoKdsvzOixY= ; Message-ID: <20051012225544.83673.qmail@web32901.mail.mud.yahoo.com> Received: from [67.112.21.27] by web32901.mail.mud.yahoo.com via HTTP; Wed, 12 Oct 2005 15:55:44 PDT Date: Wed, 12 Oct 2005 15:55:44 -0700 (PDT) From: NMH To: justin.bastedo@gmail.com MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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 22:55:46 -0000 --- Justin Bastedo wrote: > Yeah i still have quite a way to go to catch up on > you on actual > usage, but would be good to see if the problem > persisted on the > 5.4-STABLE release. As Kris said "a number of bugs > have been fixed in > 5.4-RELEASE.." it might be a good test. Also does > this persist across > all the versions of mysql? I know they just launched > the RC of 5.0, > may be able to leverage that a bit i know they are > really pushing to > get that released, and might be nice knowing that > this problem is > fixed in the new release. Hi again :) Well we built 3 fairly identical servers for testing and to try replication. At first they all had BSD 5.4-RELEASE. One had -P4 the other 2 had -p6 So they were pretty high up there on the patch levels. Also to stop them from falling over constantly we had to insert: (as it seemed the other threads could not support it at all!) /etc/libmap.conf libpthread.so libthr.so libpthread.so.1 libthr.so.1 Also no one from Mysql seemed to think going to STABLE would do anything. It's a very very tough thing to play lets see what happens if.. On production servers. The time it takes us just to bounce from one machine to another is pretty decent. Let alone downtime etc. Hence my boss's push for Linux. "Since MYSQL says it will definatly work on Linux.. We should switch to Linux." > I'm definately interested to see what the final > solution is on this > matter. I can easily forsee our db load getting > close to that level > within the next couple of months depending on how > these contracts play > out. Well, I will post whatever happens. As I said the most annoying part to all this is that so far we have been unable to crash the 5.4 servers via any testing means we (and Mysql) could come up with. Yet in production they fell over as soon as the load started to climb and points in between. But never on the slope of decreasing load for the day. (always felt that was odd) IE it would die on the bell curve increases but never at the coresponding downward cycle of the daily busy curve. If anyone knows of any particulary evil testing programs I would love to know. It's tough to simulate 30+ servers asking lots questions and forcing tons of writes. Thanks! NMH Nicole The Large Print Giveth And The Small Print Taketh Away -- Anon __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com