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?

Average of ratings: -

Re: Moodle Database Error Too Many Requests

by Visvanath Ratnaweera - Thursday, 7 April 2022, 9:50 PM

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

Average of ratings: -

Re: Moodle Database Error Too Many Requests

by Ken Task - Friday, 8 April 2022, 6:54 AM

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

Average of ratings: -

Re: Moodle Database Error Too Many Requests

by James W - Thursday, 1 September 2022, 4:42 PM

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

Average of ratings: -