Home / server / Questions / 402779
In Process
Bobby Jack
Asked: 2012-06-28 09:00:08 +0800 CST

Joomla performance problems on AWS

  • 772

I'm running a site on AWS with the following setup:

  1. Single m1.small instance (web server)
  2. Single RDS m1.small db
  3. Joomla 1.5

Generally, the site is performant, but is fairly low-traffic - say around 50-100 visits / hour. However, at peak time, we see about double that traffic. During peak time, pretty much every day:

  1. CPU usage on the web server slowly climbs to 100%
  2. CPU usage on the RDS server climbs quite quickly to about 30%, from an average of about 15
  3. Database connections shoot up to about 140, from a normal average of about 2 or 3

The site is then occasionally unreachable, certainly according to pingdom monitoring.

Does anyone recognise this behaviour? Can you point me in the right direction to begin investigating? Of course, RDS makes it difficult to do things like slow query logging, so I've started by regularly dumping the mysql process list into a file to see if there's anything I can spot there, but it would be good to have something more concrete to investigate.

UPDATE

At least, can someone confirm that I'm definitely right in saying that the level of traffic implies the problem must be a specific type of query taking way longer than it should to execute? This would happen if a table gets locked, and many queries need to write to it, right? For this very reason, I've already changed the __session table type to InnoDB.

performance joomla amazon-web-services

2 Answers

  1. Rather than dumping queries, you can enable slow query logging using RDS DB Parameter Groups. RDS saves slow queries in table mysql.slow_log. Here is a helpful thread.

    To boost the performance, use some caching mechanism like Joomla System Cache plugin.

    There might not be issue with MySQL. You also need to consider other things like images size and number of images being served from web server, performance of extensions being used with Joomla.

    • 1

  2. I don't think this is a MySQL issue. What you describe is what I've experienced on Joomla websites when the memory allocation for the instance (slice) isn't sufficient. I suggest increasing the memory allocation and then monitor the results for improvement.

    If you still think this is a MySQL issue, I would create a dummy application using MySQL and do load testing on it.

    • 0