Moodle in English: Moodle Database Error Too Many Requests

We conducted a test process with 450 synchronous participants. We encountered database error when everyone tried to login at the same time. At the same time, we get the same error when even a person refreshes the page for a long time. There is no problem with our connection. It only happens when the number of requests increases.

What solution do I need to find?

Mittelwert: -

Re: Moodle Database Error Too Many Requests

von Visvanath Ratnaweera - Donnerstag, 7. April 2022, 21:50

Did you find the https://docs.moodle.org/en/Performance documentation, especially https://docs.moodle.org/en/Performance_recommendations ?

Mittelwert: -

Re: Moodle Database Error Too Many Requests

von Ken Task - Freitag, 8. April 2022, 06:54

If linux OS, suggest installing MySQLTuner ... a perl script ... and run it with superuser creds for the DB server. It will look at config for MySQL/MariaDB and stats/usage of DB server. Makes recommendations for tweaking config of DB server. Default for max_allowed_connections is 151 ...

'SoS', Ken

Mittelwert: -

Re: Moodle Database Error Too Many Requests

von James W - Donnerstag, 1. September 2022, 16:42

Recently, one of our customers approached us with the below moodle error:
Error: Database connection failed
Our Support Engineers started troubleshooting this error by checking the database in the account.

We checked the MySQL availability using the command :
$telnet database_host_name 3306
As a result, we got to know that MySQL is up and working well.

We then checked the database settings which is set in the configuration file config.php using the commands
cd /var/www/html/moodle
vi config.php
We could find that the database set in the file was having a spelling mistake in it. So we set it with the right one.

Regards,
John

Mittelwert: -