As soon as MYSQL is started, HTTPD slows to total halt in 10-30 mins..

[astounding]

Hey,

I've been having issues with member hosted sites. Especially during peak traffic, their site becomes slow, eventually to total inaccessibility.

When I restart httpd, their sites go back to normal speed. But then slow down again within 2 minutes. So I pretty much have to restart httpd every 10-30 minutes to keep member sites from running.

But today I found the real cause.

As soon as I stopped MySQL, their sites immediately started working again, and never again slowed down, until I started MYSQL again.

There's no load or memory change while sites slow down or are fast. There's no change in anything at all infact.

All I know is MYSQL (I have v5 installed) is causing this to happen.

But I really can't see how httpd and mysql can be related, and how can MYSQL do this to entire apache.

Can anyone help me on this. What should I do to fix this?

Thanks.
Andre

 

[sleipnir214]

What versions of Apache and MySQL? On what platform?



Want the best answers? Ask the best questions! TANSTAAFL!

 

[danomac]

If there is a lot of scripts that use mysql, then it is possible for mysql to cause this, if it runs out of resources. I'd check the mysql error logs, maybe you'll find some information there.