We have Moodle 3.7 (frodson theme) +mysql(mariadb) , Centos 7 VM with 8 virtual cores and 32GB memory.
About 100 students were trying to login simultaneously but couldn't (Moodle was very slow and didn't respond) . We saw that all cores were on 100% occupation (with htop command) and we had only 6GB memory use.
eventually we had to restart nginx .
Is someone can help us and understand why it happens? and how can I prevent this problem for next time?
Dose our hardware information suites to Moodle requirements?
We noticed that mysql procceses were mostly used, is there any way to add my mysql more resources , and how?
Any help will be appreciated