We have problem on Moodle performance, it's very slow and sometimes not responding.
concurrent users : 400
total users : 6000
Number of schools DBs : 29 every school have DB
CPU: 6 * 4 cores 2.50GHz
RAM: 64GB
OS : CentOS (CloudLinux 7.6)
PHP: 5.5
Mysql Server: 5.7
Apache: 2.4.41
Database and code on same server
Versions of Moodle?
Does your php 5.5.x have opcache extension? Can you upgrade PHP to 7.x? Don't just do that without checking compat with Moodle versions.
Sounds like server needs MySQL Tuner to see what tweaks needed for DB server. Running tuner with superuser creds will render a report which includes things like:
[OK] Maximum reached memory usage: % of installed RAM)
[OK] Maximum possible memory usage: % of installed RAM)
[OK] Overall possible memory usage with other process is compatible with memory available
As well as InnoDB metrics.
https://github.com/major/MySQLTuner-perl
'SoS', Ken
Thanks Mr. Ken,
Moodle Version 3.1.5
Moodle Version 3.1.5
All your initial pointers are in the forum documentation https://docs.moodle.org/en/Performance_recommendations.