my wordpress blogs contains 3000 posts with 1500 daily pageviews and another one 400 posts with 1200 pageviews. i got following mail from my host. Your 2 websites are causing extreme MySQL usage. Normal websites/accounts have MySQL usage at 0.0 or 0.1 while your accounts are at 0.4 & 1.0 . Our MySQL is hence using 70% CPU on a constant basis when it should be below 10%. This increases I/O wait & decreases website loading speeds. We use 10K RPM drives & still the I/O wait is high . Please optimize your websites asap, else you will need a VPS to host them (high end) How can i solve this issue? any help?
use few plugins like delete revisions wp super cache & check your data base (wp-options) for plugins which you are not usinng (uninstalled) but it is stil generating queries