Hi.
We recently upgraded to moodle 3.9.1 And started new academic year with it. Site loads fast with few users. But usually there are 300 users online. And we are having problems on handling too many queries. I turned debugging on and saw that the problem is with our db. Then we upgraded to moodle 3.9.2 but getting the same problem.
Debugger when many users online. Site loading in 103 seconds.
And with few users debugger shos this
I didn't understand what is causing a problem.
Need your help.
Your screen shots are not debugging info.
Site Admin Menu -> Development -> Debugging - all the way to developer level to see what errors Moodle might be throwing.
Also check things like web service (error log) and DB logs. Plus info on overall set up ... is DB server on a dedicated machine or is it on the same server as web server? That sort of info.
Suggest installing a tool to help with DB config ... assuming linux, there is a handy tool called 'MySQLTuner' ... a perl script - command line only - which will help check if settings for the DB are optimal or in dire need of tweaking.
'SoS', Ken
