[thelist] Strange behaviour: MySQL or PHP to blame?

[s t e f]

Hi all,

Strange behaviour, that at first I thought was linked to IIS, but this
morning Apache got touchy about the subject too.

Here's the setup at the office:
- MySQL server on a w2k server
- IIS with PHP on the same machine (Machine 1)
- Apache with PHP on another machine with w2k too (Machine 2)

Every once in a while, 14 php threads are opened on Machine 1 and use 0%
of the CPU. The site becomes unreachable (because 14 looks like the
maximum of php threads), as if the web server was purely and simply down,
although Windows tells me the Web publishing service is running fine. It's
as if IIS and PHP are running fine, but the 14 php scripts hang.

So at first I thought maybe there was an incompatibility of some kind,
somewhere between IIS, PHP and MySQL. I just stopped/restarted the IIS
service and everything went back to normal. Then failed again. Repeat for
a few hours (then get mad).

This morning Machine 2 has begun to behave strangely too. Actually it
*did* behave strangely in the past but we did not pay too much attention
(the Apache on Machine 2 is running side-by-side with an old version of
WebSphere, so we thought maybe Apache and WebSphere shared some processes
they should share). Anyway, the trouble was not that bothering, so we
didn't look too much into the issue. But then, this morning Machine 2 hung
its PHP scripts at the same time as Machine 1. So maybe the trouble
Machine 2 was having is linked with MySQL too.

So I'm more and more inclined to believe there is a MySQL problem.

Has anyone experienced this kind of trouble before and/or could provide
pointers to possible causes/solutions? And all in all, can anyone provide
an educated guess? :)

TIA

-- 
s t e f
personal: http://nota-bene.org/
org: http://evolt.org/
french org: http://pompage.net/