My site is experiencing high throttling and CPU rates and recently crashed for three days after daily visitors jumped from ~2500 to 5000 due to a brief PR piece.
After reviewing the recommendations from sites like GTMetrix and BlueHost support, I have optimized to the best of my ability and am thinking it may be a server issue (much to BlueHost's insisting that it is not). I would very much appreciate any suggestions for further optimization!
Current optimization plugins:
W3 Total Cache
WP Super Cache
WP Smush.It NextGEN Gallery Integration
Running mysql reports results in this error log, of which I'm unable to decipher. There are quite a few though! and it may be where my issue is?:
# Sun Jul 29 14:53:35 2012
# Query_time: 1.577355 Lock_time: 0.000034 Rows_sent: 5 Rows_examined: 10
SELECT * FROM wp_comments WHERE comment_approved = '1' AND comment_post_ID = 9529 ORDER BY comment_date_gmt ASC
# Sun Jul 29 14:53:36 2012
# Query_time: 1.025265 Lock_time: 0.000079 Rows_sent: 3 Rows_examined: 3
SELECT comment_id, meta_key, meta_value FROM wp_commentmeta WHERE comment_id IN (20060)