Posted by ketyung
on Apr/22/2008
at 11:40 am
After several times of server outrage and we’ve created indexes on several major mysql tables of the Wordpress
This post is the private post just for testing if having created indexes will degrade posting/inserting/updating performance…
Our host has told us that TechChee.com has too many slow SQL queries. In fact these sqls are all from what Wordpress has. Suspected could be the site is growing with more and more content, without proper indexes on certain columns of heavily queried tables will cause those sql queries perform extremely slow, which would have caused many spikes in CPU’s load for our web host, and caused our site suspended….Hope those created indexes help improve the performance of the sql queries……
Leave a Reply