I have several blogs on my server and they keep making MySQL hang and it always needs to be restarted. I already installed http://mnm.uib.es/gallir/wp-cache-2/ and I haven't had it up long enough to know how well it is working, but is there anything else I can do to keep this shit from hanging all the time?
-
I use this script for a large php/mysql site I have that was loading up and getting trashed on a regular basis, not sure if it would help a wordpress site but it sure works great my site
http://www.hotscripts.com/Detailed/10320.html
I run it in a cron job btw
“Ours is a world of nuclear giants and ethical infants. We know more about war than we know about peace, more about killing than we know about living. If we continue to develop our technology without wisdom or prudence, our servant may prove to be our executioner.” ― Omar Bradley (1948) -
Thats what I am basically doing at the moment...going through and optimizing all databasesComment
-
the best optimization switch from Wordpress to CuteNewsComment
-
That script will do it then, I was doing the same thing and I set up and installed this script to run in cron every 2 hours and its been running wothout a problem for about a year. Only takes about a second to run and optimize my database.Originally posted by QualityMpegs
“Ours is a world of nuclear giants and ethical infants. We know more about war than we know about peace, more about killing than we know about living. If we continue to develop our technology without wisdom or prudence, our servant may prove to be our executioner.” ― Omar Bradley (1948)Comment
-
Google the mysql query-cache if it's not already turned on in your dbComment
Comment