Aryan,
I faced a similar problem, as have a few other people on the list, it seems.
On the recommendation of another Mac OS X MySQL user (the extremely helpful
Tony Niesz), I compiled my own MySQL server (rather than using the one Apple
distributes or the binary Marc Liyanage maintains). Prior to running
./configure, I typed:
setenv CFLAGS -DHAVE_BROKEN_REALPATH
My MySQL server -- running on a dual 500mhz G4 averaging 25 queries per
second, which was crashing several times per day -- has run without a hitch
for nearly 3 weeks since I did this.
That's two weeks on 3.49.50, and a week on 4.0.1-alpha. Both have been
rock-solid with that -DHAVE_BROKEN_REALPATH CFLAG value set.
If you can compile on your own, I'd recommend going that route. I believe
Tony Niesz is working on compiling a bug report/"heads up" to send to the
MySQL team, Apple and Marc Liyanage. I don't know if he's sent that yet, but
in the meantime I'd recommend trying this.
Good luck!
-Clay
> From: Aryan Schmitz <[EMAIL PROTECTED]>
> Date: Tue, 18 Jun 2002 17:02:08 +0200
> To: [EMAIL PROTECTED]
> Subject: MySQL stability on OS X
>
> Hi,
>
> Is anyone using MySQL with PHP and Apache on Darwin/OS X as a dynamic
> content webserver with medium/high load?
>
> We have had al lot of MySQL crashes (once a week) on a 400Mhz G4
> getting an average of 5 SQL queries per second and eventually had to
> move the database to an old Linux 160Mhz Pentium server which has not
> had a single crash since then!
>
> Would be nice to now why MySQL seems so unstable under load on OS X.
> We tried an old G3 233 Mhz as well but then MySQL crashed already
> after some hours with the same load.
>
> Kind regards,
> Aryan
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
