What plugins do you have installed and enabled? What generates your thumbnails?
Plugins with poorly written sql can kill a system. Generating thumbnails on the fly can kill a system.
Hi Ogre
Thanks for the reply.
The plugins i have activated are as follows:
AWSOM PixGallery
Blogroll Links
Clean Options
Deko Boko
DMSGuestbook
DMSGuestbook widget
Downloads Manager
FeedWordPress
General Header
Genki Announcement
Global Translator
Google XML Sitemaps
HB Social Bookmarks
MiniMeta Widget
MultiFeedSnap
Page Links To
Random Image Widget
Register Plus
SimplePie Core
SimplePie Plugin for WordPress
Snap My Roll
Snazzy Archives
Title Case
UsersOnline
Vote It Up
WordBay
WP-AddonChat
Unfortunately I am no expert so have no idea on what is causing this!, I just dont want to be suspended from yet another hosting company!!
It may sound painful, but this is the only way. You have to enable each plugin one by one, and look for the one which is using up a huge amount of resources. Sometimes, some plugins are the culprits, and this is all down to plugin’s author.
I’m going to guess that the resource over use is caused by multiple plugins.
The ones to take a hard look at are the ones that do stuff on the front page. For example, a plugin that generates a history of comments that uses unindexed queries is very bad (just an example). Actually, any query executed for every page that uses unindex queries is very bad.
It might be possible to ask your provider to help you narrow down the search. Ask them if the problem is mysql related or something else.