Date: Wed, 12 Oct 2005 15:55:44 -0700 (PDT) From: NMH <drumslayer2@yahoo.com> To: justin.bastedo@gmail.com Cc: FreeBSD-DataBase <freebsd-database@freebsd.org>, questions <freebsd-questions@freebsd.org> Subject: Re: Mysql server not able to stay running on anything but Linux? Message-ID: <20051012225544.83673.qmail@web32901.mail.mud.yahoo.com>
next in thread | raw e-mail | index | archive | help
--- Justin Bastedo <justin.bastedo@gmail.com> 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20051012225544.83673.qmail>