I have a quiz students are supped to undertake with more than 300 students, the moment they log in and the number raises to 150, the system goes offline, how can i address this issue
running moodle on Linux, 60GB ram
Moodle version 4.0
Hi
Yes, a synchronous on-line exam imposes a huge peak load on the server. The initial pointers on how to look for the bottleneck are in the documentation linked to the Hardware and performance forum https://moodle.org/mod/forum/view.php?id=596. Also you will find many similar discussions in that forum. Please go through all that and come back with your analysis for further details. In the meantime the moderator may move this discussion there.
Is this is the Moodle 3.9 mentioned in this discussion https://moodle.org/mod/forum/discuss.php?d=410800#p1656896 ? What was the problem that time? Has it been updated to 3.9.latest or upgraded (to another major release 3.10, 3.11, etc.)?
Yes, a synchronous on-line exam imposes a huge peak load on the server. The initial pointers on how to look for the bottleneck are in the documentation linked to the Hardware and performance forum https://moodle.org/mod/forum/view.php?id=596. Also you will find many similar discussions in that forum. Please go through all that and come back with your analysis for further details. In the meantime the moderator may move this discussion there.
Is this is the Moodle 3.9 mentioned in this discussion https://moodle.org/mod/forum/discuss.php?d=410800#p1656896 ? What was the problem that time? Has it been updated to 3.9.latest or upgraded (to another major release 3.10, 3.11, etc.)?
Generally it is much appreciated if you describe how you solved a problem and close the discussion. Unfortunately that discussion is locked now.
The default for both MySQL and MariaDB for max_connections is 151.
As super user for your DB server verify:
mysql> show variables like 'max_connections';
to handle 300 at same time, suggest a little over ... like 351
in my.cnf file under [mysqld]
max_connections=351
max_connections=351
then restart DB server.
There will probably be other needed tweaks upwards so suggest installing MySQL Tuner and run it with super user creds to see what it might have to recommend in settings.
Above not to say you shouldn't read/review the forums etc. related - do - you might find other things as well.
'SoS', Ken