Quote:
Originally posted by XXXstorage Jeff
In my experience, if you are actually topping out the default max connections on mysql, you are either using a poorly programmed script that isn't closing the connections properly, the hard drive is filled up, or you have overloaded the server. These are the most common causes for this problem.
Usually 100 connections for an ad program is plenty. As long as your load is low, the mysql daemon answers the request fast enough that a large amount of connections never builds up.
There is also the possibility that your hard drive is full, causing mysql to hang, check that.
Check your server load, log in and type:
w
The last 3 numbers at the end: above 1.00 is bad, time to get more servers or look for another script.
Check your disk space:
df
100% is bad
Get in touch with your host first, they can usually tell you where to begin troubleshooting.
|
No the disk isnt near full, I have about 690k in traffic to the server it self not just to that site so that could be the probem I have 4 trade scripts running, plus this ad script damn, Guess im going to have tofig out how to do mysql from one server to another eh? Thanks for ya help peeps
TOM