[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 2-5 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

[adilbhai]

Dear Andre,

Plz check if ur members scripts are making persistant connections to MYSQL using pconnect instead of connect.

persistent connections are only needed very rare and generally all other functionality is possible using normal connect method.

i have no idea where but if u can plz check the number of mysql connections
This should give u an idea or search for scripts containing the php function
mysql_pconnect


------Just for ur info---------
resource mysql_pconnect ( [string server [, string username [, string password [, int client_flags]]]] )


Establishes a persistent connection to a MySQL server.

mysql_pconnect() acts very much like mysql_connect() with two major differences.

First, when connecting, the function would first try to find a (persistent) link that's already open with the same host, username and password. If one is found, an identifier for it will be returned instead of opening a new connection.

Second, the connection to the SQL server will not be closed when the execution of the script ends. Instead, the link will remain open for future use (mysql_close() will not close links established by mysql_pconnect()).

This type of link is therefore called 'persistent'.

------end for your info--

And its quite possible that someone is using mysql to store files for eg hivemail uses mysql to store emails of all site users

So also keep an eye on teh size of mysql dbs

[gryffin]

mysql can do this to apache because if DNS is mysql based then if mysql becomes overloaded pages will not load, it is not apache it just appears to be apache, it is named.

just use flatfile instead of mysql for DNS, any tech can do this for $25

per user query limits may help as it may be an abusive user as the post above highlighed, but the above cause is HIGHLY likley