Skip site navigation (1)Skip section navigation (2)
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>