Apache Locks-Up On PHP DB Call

[bitplane]

I have a strange problem where ever 2nd or 3rd request to my site will hang for upwards of 60 seconds.

During that time I can't access any other pages through apache, even ones that have no DB calls.

Only pages that have DB calls trigger the hanging-behavior.

Strangely, the lock-up seems tired to the browser which initiated it.

While firefox locks-up I can use IE and vice versa.

 

This problem first appeared when I was setting up a new production webserver.

I've reproduced the problem on VMWare also.

[PFMaBiSmAd]

Start by checking your web server log for any php or server errors.

 

It sounds like the database client or the the database is faulting.

 

Can you access the database server using a third party tool, that is not dependent on php, like mysql.com's Mysql Administrator?

[bitplane]

yes, I can connect and query from the command line.

I can also query from PHP.

Everything works when I use myisam, but when using NDB (mysql cluster) the problem occurs.

I can query the cluster, there seems to be no problem with it.

 

I echo's the time() at the beginning and end of the php script.

The seconds matched even though there was a delay of about 60 seconds.

[bitplane]

nevermind on this, it was a script error