I received the following from my ISP in regards to a crashing server, due to hihg load...I am unsure how to read this though, any help would be appreciated.
Hello,
thank you for the update I have found a couple of ings that might help out, the first thing I did was run top and then sorted it by memory usage to do this through ssh
type top and then enter to start running top and then hold down the shift button and press m to sort by memory at the top of the processes using the most memory is mysql as shown here:
PID USER PRI NI SIZE RSS SHARE %CPU %MEM TIME CPU COMMAND
605 mysql 0 0 69268 41M 3456 0.1 8.1 1098m 0 mysqld
#39929 [NEW]: Persistent connections and ODBC - PHP Bugs::
4 posts - Last post: Jan 17, 2007Symptoms are identical so it's not just ODBC issue. Previous Comments: mysql_pconnect() Do persistent connections ever die?
http://www.justskins.com/forums/39929-new-persistent-connections-and-odbc-90122.htmlHOME |
persistent connections ebook Download::
By using Digi persistent connections, users of the. Digi Connect™ WAN and Digi Connect™ Remote Gateway will be able to better .
http://www.toodoc.com/persistent-connections-ebook.htmlHOME |
now whats interesting about this is that if you do ps aux
you will see a whole bunch of mysql processes but these mysql processes do not stop by this I mean that so far this morning there are a number of mysql processes that have been running for about 20 minutes taking up 8.1 % of the memory there are a total of about 45 to 55 mysql processes currently running and more are starting up.
whats happening is that someone is visiting one of the sites and then when they are done and leave the site or close there browser the connection to mysql is staying open instead of being terminated. and then when that customer or person comes back to the site a new mysql process starts up so you have the process that is still running from the last time they visited and then when they go back a new mysql process is started up which will cause more memory to be used up. This is happening becuse someones script on the server is using what is called a persistent connection. Unfortunately this can cause mysql processes to keep running and keep using up more and more resources until either the server needs to be rebooted or until someone restarts apache or mysql.
How to limit or disable persistent connections. - phpWebSite ::
4 posts - 2 authors - Last post: Jun 25How to limit or disable persistent connections. Help with phpWebSite 0.10.xx & 0.11.
http://phpwsforums.com/showthread.php?p=32208HOME |
What I would recommend doing is to check with your clients and see if anyone is using a script to connect to mysql and is leaving the connection open, if they are they should put in a command to close the connection after a certain period of time such as 2 or 3 minutes.
If it is a dedicated machine what does your host care about how you use it?
Have you made any optmizations to mysql/php/apache since having the dedicated server setup?
You can try turning persistent connections off in your config.php:
// ****** MASTER DATABASE PERSISTENT CONNECTIONS ******
// This option allows you to turn persistent connections to MySQL on or off.
// The difference in performance is negligible for all but the largest boards.
// If you are unsure what this should be, leave it off. (0 = off; 1 = on)
$config['MasterServer']['usepconnect'] = 0;
However if this is already off then vB is not using any persistent connections.
Well did you open a support thread about it in the server config?
Yes, I have a thread open in that forum and am talking to George as well.
I am back in communication with George. He wants me to upgrade mysql/php versions, however, I was having this problem prior to the last update he urged and no change was made. I have the host looking into it as well.
No, this is not in any way related to the cookie timeout.
Since this is a dedicated server, please see this thread for help with optimizing your server:
http://www.vbulletin.com/forum/showthread.php?threadid=70117
Then post the requested info in a new thread in that forum.
Then those connnections are either not persistent, or they are coming from another application.
Zach-
It is a dedicated box, so any mysql process on the box is somehow realted to my site. All my site runs is my forum, and then some static HTML pages.
Steve-
Do you think it can be related to cookie time out and these aren't persistent?
What is clear is that I am having a problem with server load, because of inactive mysql processes. 2-3 times a day, the server load just jumps through the roof, killing all active forum connections and then reenabling them fixes the issue..
Have you tried making more changes ? Did you tell george that what you did, did not make a big impact?
Steve-
I tried that with George a few months ago. We upgraded apache, mysql, php, and made some settings changes, but there was NO appreciable change in the performance.
Zachery-
That was a response to a trouble ticket that I had made. Basically 2-3 times a day my site becomes unavailable due to spiraling load, like 50-60 load on the server. Only once I restart apache or mysql does my site become available again.
http://www.vbulletin.com/forum/showthread.php?p=1065861#post1065861 :)
How can they prove that _that_ mysql connection or process is yours? Theres no user assicated with it besides mysql.
Steve-
I was set to off already...any other ideas on what this could be related to? I mean, perhaps the host is just misinformed that it is persistent connections, think I just need to turn my timeout time lower?
 Where was the last debate on wednesday with Mccain and Obama?
 INSTANCE / WAITING FOR SPRING
|
Persistent Connections Issue?