Jump to content

Apache Locks-Up On PHP DB Call


bitplane

Recommended Posts

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.

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.