XF 2.2 More than 30 MySQL connections open at the same time

[AnjaV]

My host says That i did not close the MySQL connections properly while I'm not even aware that I seem to have more that 30 MySQL open connections at the same time. But when I do I see messages like in the attachments of another member. On a computer as well, on Mac, on iPad, with all kind of browsers, it just happen. While opening the website, switching pages, opening a photo, sending comments, it just happens. Refreshing the page will help. One time or maybe five times.
It's very frustrating.

My host recommended I should transfer from shared hosting to VPS which I can not afford.

Who is familiar with there database and server errors and who has the solution?

 

[AnjaV]

Hmm, are you sure? T

That's what they told me.

Ik moet je helaas teleurstellen dat dit config bestand niet aangepast kan worden op een shared hosting, dit bestand is namelijk van actief op server niveau en beïnvloed dus alle klanten op het platform.

Voor het aanpassen van de redis configuratie is dat wel weer mogelijk bij een VPS of Dedicated server, omdat je hier een volledig eigen hosting omgeving hebt.
Je hebt dan hierin dus meer vrijheid als het op zulke kwesties aankomt.

 

[PaulaG]

My shared hosting provider places a limit on the number of simultaneous connections per DB user. When the Forum got busy we would start seeing these errors. And as with your hosting service, they told me we would have to move to a dedicated server which we could not afford.

I modified the PHP code that sets up the MySQL connection for each user session when a user logs in. I created 10 DB User accounts in MySQL, replaced the single MySQL connection User/Password variables with a list of 10, and then the modified the PHP to randomly pick one of the 10 MySQL users when the Xenforo user session starts up. In a case like yours where you are limited to 30 simultaneous connections per MySQL, this modification effectively gives you a new limit of 300.

We’ve been running for a couple of years now on a shared server with no problems.

 

[Mr. Jinx]

That's what they told me.

Nah, you asked the wrong question or they didn't understand your question.
You cannot change the Redis config, but that is no problem. You can change the XF config (located in /src/config.php).
In there, you specify the Redis server, which you can find in your controlpanel.

 

[Abraham54]

@AnjaV - I am with Vimexx to and now I have Webhosting Extreme and I am very happy with it.

 

[MattW]

Does Matt have any servers based in USA?

Or Europe / Amsterdam?

USA / Canada and London

I have a lot of customers from here, and can provide examples if people are interested.

mattwservices.co.uk - Server Configuration / Hosting / Support

A massive thanks to Matt for being patient with me yesterday and spending most of his evening setting up a VPS for me using Centminmod with his service offerings here https://mattwservices.co.uk/resources/centos-nginx-build.4/ He's been superb from start to finish, answering any questions I had...

xenforo.com

 

[Rhody]

I'll keep that in mind. Very intrigued to be able to use the paid Enhanced Search feature of XF. This isn't an option on my current Litespeed based shared server w/cpanel.