Hello,
we have Moodle 3.7 in our university server and we have problem if we have > 1000 online users Moodle is getting very slow. In server performance overview we do not see any slow processes. What best web server performance settings do we need to set? Then do we need to think about load balancer and scale?
Sorry, we are using MySQL 5.7.30
What king of server specifications and architecture (its a lot information), can You make an example?
Are You asking this:
Server: Dell PowerEdge
CPU: 2x Intel(R)
Xeon(R) CPU E5-2620 0 @ 2.00GHz
Hardisk: 4x300GB 10k + 4x1TB 7.2k SAS
Raid: Raid10 in both cases
Ram: 48GB
Firmware versijos: the latest
Network: 10 GbE
OS: Ubuntu 18.04.2 LTS
The server operating system is written to Raid10 4x300GB 10k RPM diskus. Moodledata deployed to Raid10 4x1TB 7.2k RPM SAS disks.
We think its is not a server spec problem, but PHP configuration or/and MySQL (or all WEB server), because Moodle benchmark report always says very slow read/write to database, to file system.
'We think its is not a server spec problem,'
You may well be right, but at the moment it is hard to work from
'Moodle is getting very slow. '
Where and what is slow and for who/how i.e. >1,000 people doing what. Simply having them logged in doing nothing is unlikely to be an issue. Is it slow all the time or is there a pattern. I once spent 6 months tracing down a slowness that was linked to the cron kicking off every 15 minutes (these days it should run every 1 minute so that is unlikely to be your issue).
Also for testing I suggest installing a parallel copy of Moodle with no plugins/integrations and see if that shows the same symptoms. See if you can get some page load times.
"First of all you have to use PHP Opcache for example Zend opcache and a newer MySQL version and Nginx because Apache is slow and consumes lot of resources"
If he's using PHP 7, then he's using Opcache (unless he turned it off which is a bit unlikely)
A newer version of MySQL is MySQL 8 which comes with its own challenges. However, I doubt it would be noticeably faster than MySQL 5.7
I know it's something of a religious thing but I think saying Nginx is faster than Apache (certain so you'd notice) is open to debate. I am well aware that Nginx performs well in some circumstances but I doubt you'll see much difference with Moodle. Assuming Apache is configured correctly (but assuming Nginx is configured correctly too).
So I don't think any of these things will make any difference to the OP. However, your other points about storage, sessions and RAM may well be closer to the truth.
We have rules for all teacher that quiz one question per page must be. But hear we have problem that then student clicks second question page loads very slow about 10 - 15 sec., sometimes its brings "The page cannot be displayed".
'Staggering over a few minutes can help'
what do you mean? how could i do that? maybe you can explain more?
Can You suggest how can I tune the database and webserver?? and how can I do database for file locking and how can it help?
Performance good practice is one thing. Finding the bottleneck in a particular case is something different. The OP has yet to disclose the Moodle Benchmark results https://moodle.org/mod/forum/discuss.php?d=402542#p1625784.
P.S. We are definitely looking at the Hardware and performance forum. ;)
Hi
You wrote:
We think its is not a server spec problem, but PHP configuration or/and MySQL (or all WEB server), because Moodle benchmark report always says very slow read/write to database, to file system.
I can't follow the logic. Could you post a screen-shot of the Moodle benchmark results?
