Drupal 7 high mysql CPU usage – what more can I cache?

Hello

Due to a mistake I reserved an aws RDS instance with 1 CPU and 3.75 RAM – not ideal, but I did this for a year in advance. Crap! Naturally, Drupal the resource hog as it can be is dancing on the 90%-100% CPU usage line here. I was planning on at least 7.5 RAM and TWO CPU’s I’m fucked!

I have Varnish 4 installed and working
I have Drupal default cache on (when I turn on Authcache, default fails and Varnish 4 fails)
90% of traffic is anonymous so caching as much as possible is obviously ideal.

The Drupal 7 install that I have is Pressflow optimized.

What else can I do to help the CPU issue and try to ride this out?

Drupal version: 


Source: https://www.drupal.org/taxonomy/term/34/feed

Leave a Reply