There is more to it than RAM...could be your CPU, disk write speed, database speed...how many simultaneous users do you have and what are your full specs?
thank you for your reply
In
the day maximum 150 simultaneous connections but in the evening
normally there is more than that, is there a way (a tool) that allows me
to have this information?
What do you want to have exactly as information? Excuse me I'm not an expert in system administration
Good thing it's Linux! ;)
Suggest installing MySQLTuner.pl ... a perl script that should run on your server.
https://raw.githubusercontent.com/major/MySQLTuner-perl/master/mysqltuner.pl
above link will show the raw .pl script (perl).
Wget the URL above to your /usr/local/bin/ or /usr/bin/ directory so you can all it from any location on your server and, the .pl file does need to be made executable as well.
chmod u+x mysqltuner.pl
When one runs tuner it looks a config as well as stats that the DB server keeps.
One of the items ... max connections ... default is 151 and it's not unusual for a Moodle db server to be in need of tweaking that upwards. Tuner will provide a suggested value.
Editing my.cnf - config for MySQL DB server - will require restart of the DB server service for the changes to take affect.
'spirit of sharing', Ken
We checked some courses, we found that some of them showed the following error:
"Failed to unserialise data from file. Either failed to read, or failed to write."
By clearing all the caches the error is gone and the platform has returned to normal, it is not very very fast but acceptable. I think the problem of slowness came from that.
anyway thank you very much for your help, I will test this script, it looks interesting. In my.cnf the max_connections parameter is set to 10000