Vanilla Grinding To A Halt
I'm hoping someone can give me some bright ideas to solve my performance problem.
I have a vanilla forum running 2.1b1
It's here for anyone that wants to take a look: http://www.thefretboard.co.uk/
It's been running for about 6 months and started at about 25k page impressions /day and recently gone up to around 44k /day
It's running on a 2GB Linode box under Apache Prefork with APC enabled.
Performance was fine, but now even though we are sitting at 25% RAM usage and 5% CPU usage the page load times have gone through the roof, from a second or so we were getting in the early days to anything from 6-10 seconds, or sometimes more.
We've had a look at the DB traffic and none of the queries are taking a long time and those that were a big slow we've added some indexes and sorted them.
I'm getting a bit stumped, but our users are getting unhappy so I need to do something ASAP.