Optimizing connections to the database?

Optimizing connections to the database?

per Franky Vallori -
Nombre de respostes: 0

Hi,

I have a server with 4 moodle instances installed.

The Server has 8 core CPU with 128GB RAM

Server Server PHP Version 7.0.10.        Server Mysql 5.0.12.

There are 3 Moodle instances version 3.5.1 with few connections and 1 Moodle 3.1.13 instance with about 500 simultaneous connections.

Very often, lately, the mysql process on the server is under stress is the Mysql Server crash.


Do you have any advice on how to configure (settings of some parameters):
Apache (http.conf), PHP (php.ini), MYSQL MARIADB (my.cnf)?


Thanks,
Francesco



Mitjana de qualificacions: -