Gradebook taking too much memory to run

Picture of Saad Zaman
Gradebook taking too much memory to run

Hi Guys,

We are using moodle for various schools and the course is shared among them. There are about 8000 users enrolled atm ( expected to rise ). 

The main issue i am facing is when due to some unknown reasons the course is set to regrading. It takes forever to complete regrading and it is consuming a lot of memory

1) Is the memory consumption normal ? ( like 2GB ) 
2) Can it be optimized ? or done in a modular way ? 
3) Can we know which particular grade / user / quiz is causing the regrade and instead of full regrading, just regrade that ?


I would really appreciate the help of the community. in deep sea with this atm.

Picture of Tammy Moore
Re: Gradebook taking too much memory to run

It still can take a while in large enrollment courses, but we found that boosting max allowed packets for the database was the most significant positive step we tried. We actually had a course locked up after a teacher did a grade recalculation and this change was what got that course accessible and allowed it to finish up the task. You can try this even as a temporary setting since you can update that one without a server restart (dynamic). The maximum setting is 1073741824, but make sure you have plenty of RAM if you go that high (32GB or more). You may find that this setting boost will also help with restoring to a new course in those courses with large question banks and lots of quizzes. 

We also found that increasing max_heap-table_size and tmp_table_size was a big help. Those are also settings you can try without a server restart. 

Just remember that if those setting changes do end up helping that you set them temporarily. They will go away in the next server restart. If they help, make them permanent by changing them in my.cnf

set global max_heap_table_size =33554432

set global tmp_table_size = 33554432

set global max_allowed_packet=1073741824

I recommend increasing your setting slowly, but the above values are what we finally settled on since we do have really large question bank courses (5,000 to 10,000 questions) and large enrollment courses (many hundreds of students). We might be able to lower them now. We found out that our remote host accidentally set us up on a file system that had been deprecated. We were on that server two years all the while boosting settings to try to help with those large processes. When they caught their error and moved us to a server with the current file system, we found many things ran much faster. I have not explored if we now can set those settings lower and get as good a result. We definitely needed them on the original server though.