Moodle website performance tuning

Moodle website performance tuning

by jimmy Octavious -
Number of replies: 7

hi there all moodle users and moderators,

my office had been using moodle for almost 2 years already and serve bunch of users arround +26k. at first the site is running well since there's not much people accessing the site. but in these 2 weeks i've been troubled with users were complaining on how super slow the site is going. but from what i investigate the proccessor and memory consumed is never higher than 30% and 10%. seems like theres bootleneck someware

this is the lastest configuration modified on my server:

query cache size = 256M

temp table size = 256M

key buffer size = 512M

innodb log buffer size = 256M

innodb buffer pool size = 512M

is there any variable / parameter that i can tweak to increase my server performance? you can see that i have bunch of resource

 

for information these is my HW spec:

Dell PowerEdge 2950

Intel(R) Xeon(R) CPU E5450 @ 3.00GHz (dual CPU)

16 GB Memory

Windows Server 2003 Enterprise Edition SP 2

 

server traffic

8-Dec-10 Last 2 week last 1 month all year
Unique IP 991 3,236 5,326 10,146
total visitor 1,800 15,298 24,418 50,947
avg. no of visit 1,800 1,390 626 205
Average of ratings: -
In reply to jimmy Octavious

Re: Moodle website performance tuning

by jimmy Octavious -

oh yes i forgot im using moodle 1.9.3 and mysql 5.1

Average of ratings: -
In reply to jimmy Octavious

Re: Moodle website performance tuning

by Cesar Sanchez -

Hi, Jimmy:

You sould consider to upgrade your moodle very seriously. I had a similar problems and found that there are issues reported with this version, that affects performance specially when it comes to grading options. We tried many fixes but the only fair option is upgrading.

You can see this issues in the bugtrack, maybe those refer to your problem.

http://tracker.moodle.org/browse/MDL-18484

http://tracker.moodle.org/browse/MDL-16238

http://tracker.moodle.org/browse/MDL-16785

http://server3.moodle.com/browse/MDL-13403?page=com.atlassian.jira.plugin.system.issuetabpanels%3Achangehistory-tabpanel

 


Regards

Average of ratings: -
In reply to Cesar Sanchez

Re: Moodle website performance tuning

by jimmy Octavious -

hi cesar,

what is grading options? im sorry if the question is so obvious smile and seems like your given link are broken. what is your main reason to upgrade? and is there any document guide on upgrading?

Average of ratings: -
In reply to jimmy Octavious

Odp: Moodle website performance tuning

by Bartosz Cisek -

Hi,

First of all, increase innodb_buffer_pool_size at least to 4GB. Make sure all your tables are InnoDB type.

To properly manage your site you should at least know:

  • how much data you store in DB
  • DB query rate
  • IO rate
  • http request rate
  • RAM usage
Average of ratings: -
In reply to Bartosz Cisek

Re: Odp: Moodle website performance tuning

by jimmy Octavious -

ok noted about innodb_buffer_pool_size to 4GB


how much data you store in DB <-- when i backup using sqlyog its arround 1.5GB
DB query rate <-- how do i get this?
IO rate <-- how do i get this?
http request rate <-- how do i get this?
RAM usage <-- average is not more than 10%

Average of ratings: -
In reply to jimmy Octavious

Re: Odp: Moodle website performance tuning

by Bartosz Cisek -

I recomend you to install munin or cacti or other software that graph all those values in time. Single values don't say much about your typical workload.

Average of ratings: -