I happen to check my error logs and found a folder named mysql_slow_queries and found daily a log was generated for the slow mysql queries.
I have 4 wordpress (WP2.2.3) blogs running under my hosting account (on Hostmonster). They do not have much traffic. Usually 500 visitors per day in all (total for 4 blogs) with 2000 page views per day (total for 4).
Wordpress seems to be consuming lots of CPU resources as well. My account gets frequently suspended due to excessive CPU usage.
Is any one facing similar problem ?
Is there any way to improve the speed of mysql queries and reduce CPU load ?