Moodle Performance Tuning

Question

Our Moodle site is starting to get a lot of traffic. As a result, the site slows down. What are some configuration options that I should check right after the bit when tuning for Moodle performance? I know that this is specific to this site, since others on it have no problems with large workloads.

Answer 1

On the Moodle website, they have an extensive performance tuning web page . I have included a list of several sentences that look intersting:

• If you go to: http://YOURSERVERNAME.com/admin/dbperformance.php , moodle will give some performance statistics.
• Consider adding more RAM or clustering your web server.
• Consider adding a php accelerator like APC, PHPA, Xcache or eAccelerator.
• Try to determine if the bottleneck is a web server or a database server.

The moodle user also developed good script load testing (this script is very heavy and will tell you the maximum load your server can handle). You can find it here.

Answer 2

Adding the APC php accelerator increased the performance of our server by 250-300%. right away (amazing!) we use CentOS 5.4, so it was only " yum install php-apc " (simple)

we also used mysqltuner.pl (blog.mysqltuner.com/) to configure the MySQL server settings. it's hard to say how much we got here. he feels better.

we are changing the MySQL DB Engine for the mdl_user table from MYISAM to InnoDB after we have reached 12,000 users (we now have 16,000), this has had a huge positive effect on queries related to mdl_user. (example: loading 600 new users now takes 1 minute, where 12 minutes were used before).

Answer 3

Use the "Universal Moodle Cache". To a certain extent, it speeds up the mood. This feature is available moodle 2.4 onwards. Here is the link to the official documentation http://docs.moodle.org/24/en/Caching

You can also try using memcached with moodle. Although not directly out of the box, memcache is one of the standard ways to use ram to speed up database access.