I have two Moodles that I manage - both running 2.6.1+ on Ubuntu 12.04 with Mysql
On one when I go the assignments> view grading it's very slow to load, upto a minute is some cases
With the other one clicking the view grading link causes Moodle to lock up completely - no one can login or move around the site. Restarting apache2 brings the site back to life. What's really odd here is that apachetop, mytop, htop and the mysql slow queries log don't show anything in particular happening when the site locks up.
Is someone able to give me some pointers on things I can look at top try and solve this please.
I can't offer any specific advice for that particular page, but a generic way of working out why a page is taking so long to load is to use a tool called xhprof. It is pretty technical and designed for developers only, but can give a lot of information about what is going on.
It's light enough to run in the background on a live site (but preferably not enabled all the time) and instructions for setting it up can be found at:
you can also find helpful instructions at:
I actually just fixed this on the server that was locking up.
I took a look at the syslog on an off chance and saw a whole bunch of errors like:
warning: mail_queue_enter: create file maildrop/106333.1850: Permission denied
So I chmod'd the folder to correct the permissions and now the problem has gone away.
The machine I'm using is a VM clone of another machine so perhaps the permissions were screwed as part of the cloning. If can't think for the life of my though why a postfix error would stop the assignment grid from working.
Hi dan attwood,
i have the same problem with slow Assignment in moodle 2.6.1+
Can u tell me, how i can check my syslog? I also u untuntu and apache.
I would be very interested in a little bit more explained solution
greeetings from germany,