PHP & MySQL & Apache on Linux vs. Solaris
| From: | Boaz Yahav | Date: | Thu, 05 Sep 2002 12:43:14 +0000 |
| Subject: | PHP & MySQL & Apache on Linux vs. Solaris | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-115293@lists.php.net to get a copy of this message | ||
Hi
Since i moved from a Sun / Solaris Machine to a Compaq / Linux machine
I'm having weird problems with MySQL crashing while running reports written
in php.
The site is amazingly fast now on the Linux server but running a report
that locks the main tables for about 20 seconds raises the load and crashes
the server.
While this makes some sense (maybe) i did not have this while i was on Solaris.
Why would Solaris know how to hold the queries in the Queue till the tables are freed
and Linux does not?
Is this PHP, MySQL or maybe Linux to blame?
thanks
berber