Atomicorp

Is there any way to speed up the refresh time on this CP? 30-60 seconds to refresh page after you click a link... annoying..

Thanks.

This is a deep seeded question and to answer it responsibly one would first have to ask.."why is your control panel taking 30-60 seconds to refresh?"

Here are some ideas, but PLEASE DO YOUR HOMEWORK FIRST. I TAKE NO RESPONSIBILITY FOR ANYTHING THAT CAN GO WRONG!

mysqlcheck -uadmin -p`cat /etc/psa/.psa.shadow` --optimize -A

This will optimize your tables across all your databases. If you have been up a long time, maybe you just need to tidy up.

Also, do a search for: mysqltuner.pl

Why search for it?

yum install mysqltuner

As for GZ... I'd try restarting the psa process first before optimizing mysql.