Can the MySQL processes on Wordpress be Optimized?
 

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

Thats what I am basically doing at the moment...going through and optimizing all databases

the best optimization switch from Wordpress to CuteNews

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.

Google the mysql query-cache if it's not already turned on in your db