Hello,
Recently, our department got a new server to run our Moodle on and would like to transition to it. I have installed Moodle 2.9 on the new server. Most of the functions seem to work well, but grading has some problems. When I entered grades into the gradebook or the assignment, Moodle takes between 2-4 minutes to update and load the page. I'm concerned that this is quite an increase from our last Moodle server.
The server is set up as follows:
Moodle 2.9.1+ (Build: 20150813)
CentOS 6
MySQL 5.5.45
PHP 5.5.28
Apache 2.2.15
I used xhprof to figure out what's slowing it down. Here is a breakdown of what it found:
Total incl. Wall Time: 145,150,151 microsecs
Total Incl. CPU: 23,755,389 microsecs
Total Incl. MemUse: 15,152,328 bytes
Total Incl. PeakMemUse: 15,514,928 bytes
Number of Function Calls: 5,033,061
If I read it right, the graph shows that the problem is MySQLi. I have compared the httpd.conf, php.ini, and mysqli_native_moodle_database.php files and they seem similar. I'm worried that I missed installing or configuring something, but when I looked over the Moodle installation guides I couldn't find anything. I'd appreciate any ideas about what could be wrong.
