Can the MySQL processes on Wordpress be Optimized? - GoFuckYourself.com

QualityMpegs · 03-19-2006, 01:57 PM

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?

Nasty · 03-19-2006, 02:10 PM

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

QualityMpegs · 03-19-2006, 02:13 PM

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

Antonio · 03-19-2006, 02:35 PM

the best optimization switch from Wordpress to CuteNews

Nasty · 03-19-2006, 03:35 PM

Quote:

Originally Posted by QualityMpegs

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

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.

Gungadin · 03-19-2006, 03:56 PM

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

03-19-2006, 01:57 PM	#1
QualityMpegs Confirmed User Join Date: Feb 2003 Location: Orlando, Florida Posts: 3,521	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? __________________ PAYSITES CATEGORIZED AND THUMBNAILED BY NICHE - 69767780

03-19-2006, 02:10 PM	#2
Nasty Confirmed User Industry Role: Join Date: Aug 2002 Location: Sunny Fucking California Posts: 1,575	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)

03-19-2006, 02:13 PM	#3
QualityMpegs Confirmed User Join Date: Feb 2003 Location: Orlando, Florida Posts: 3,521	Thats what I am basically doing at the moment...going through and optimizing all databases __________________ PAYSITES CATEGORIZED AND THUMBNAILED BY NICHE - 69767780

03-19-2006, 03:56 PM	#6
Gungadin Confirmed User Join Date: Aug 2005 Location: O&A PARTY ROCK Posts: 444	Google the mysql query-cache if it's not already turned on in your db __________________ The GFY popularity contest scoreboard

03-19-2006, 02:35 PM	#4
Antonio Too lazy to set a custom title Join Date: Oct 2001 Location: Spartaaaaaaaaa Posts: 14,136	the best optimization switch from Wordpress to CuteNews