Troubleshooting max user connections

sapiro · Post by **sapiro** » Fri Apr 09, 2021 9:14 pm

Title/Job Description:Troubleshooting why I often get max user connections

Target audience: Everyone with very good knowledge

Reward:Payment on success

Deadline:as quickly as possible

Preferred contact method: PM or E-Mail

Link to the board:www.arcade-zockerbande.de

Detailed description of the tasks:Find the reason why I often get the following error message: max user connection
It is probably because there are sometimes too many connections in my DB on sleep (see picture)
[img] www.arcade-zockerbande.de/Bilder/Unbenannt.PNG [/ img]
Max user connection is set to 25 by the provider

Madalin10 · Post by **Madalin10** » Sat Apr 10, 2021 1:57 pm

Contact your hosting provider and tell them to increase the number, from 25 to much more than that.

sapiro · Post by **sapiro** » Sat Apr 10, 2021 3:09 pm

That is the problem, they dont want to do that.

david63 · Post by **david63** » Sat Apr 10, 2021 3:19 pm

sapiro wrote: ↑Sat Apr 10, 2021 3:09 pm That is the problem, they dont want to do that.

Then your only other option is to find a better host.

There is nothing within phpBB that can reduce the number of connections.

sapiro · Post by **sapiro** » Sat Apr 10, 2021 3:58 pm

Maybe someone knows where i can only rent a mysql database without web space.
Then I could use this as an external database

Post by **KevC** » Sat Apr 10, 2021 5:02 pm

That would be hugely more complicated than just finding a decent host without such a tiny limit.

Ger · Post by **Ger** » Sun Apr 11, 2021 6:45 am

The point is that for every request, there is a database connection. That includes real persons as well as bots like Google and such.
You can try to prevent people and bots to visit your board, but what's the point in having a board than?

Just find a decent host with 21st century settings.

sapiro · Post by **sapiro** » Tue Apr 13, 2021 5:21 am

This topic can be closed.
Thx too user zonstraal for the hint with htacess

Post by **KevC** » Tue Apr 13, 2021 11:44 am

sapiro wrote: ↑Tue Apr 13, 2021 5:21 am Thx too user zonstraal for the hint with htacess

which was....?

janus_zonstraal · Post by **janus_zonstraal** » Tue Apr 13, 2021 7:54 pm

See: https://www.johnlarge.co.uk/blocking-ag ... pers-bots/

sapiro · Post by **sapiro** » Wed Apr 14, 2021 1:25 pm

He gave me a code witch blocked those nasty bots

Post by **KevC** » Wed Apr 14, 2021 1:31 pm

Just be aware that a limit of 25 is still pitifully low for a forum. As your site gains momentum, sooner or later you will hit the limit again and you'll have to move hosts. Sometimes bots are a good thing in terms of indexing and spreading the news of your site. That code is only delaying the inevitable.