How to optimize MySQL queries

Hi everyone,
I was asked by my host that to reduce the load considerably, please optimize the MySQL queries to the database 'xxxx_wrdp1 '. We could see many sleep queries associated with this.

How on earth do I optimize MySQL in my wordpress database? Do we have plugin?
Thanks in advance to any advices.

 

I would recommend using wp super cache.

I can't submit live links yet but just go to wordpress extend -> plugins and search wp super cache

 

Hi,
thanks fir the reply but I am already using super cache, any thing else?

 

What plugins are you using if any? How much traffic does your site get?

 

Around 250K per month, I am on a vps.

 

plis try this plugin dbchace reload compare with plugin wpsuperchace......thanx

 

Obviously you have more going on with the database than just WordPress. Either it is a plugin, or your host can't handle it, or a host of other things. Everyone's thought of throwing another plugin on top of the situation is inane.

Who is your webhost, what version of WP are you running, what version of MySQL are you running, what plugins are you running, what is the Url of the website, and I have a host of other questions. The more info you have, the better to help you resolve the situation.

 

i suggest you to always update your plugin mate

 

Use CSS sprites . Though its not related to Mysql but the use of css sprites reduces the number of http requests sent . For the mysql optimization fry to reduce the number of plugins you are using .