Problem with Xibo on xampp SQLSTATE[HY000] [1040] Too Many connections

Get Help
1

Hello,

I use CMS Xibo 1.7.8 and i have 15 players with 10 differents users, but sometimes i have an error “SQLSTATE[HY000] [1040] Too Many connections”. I reboot MySQL all days
I don’ t think that all my users connect lot of time in the same day to 151 connexion simultaneously.
I can change in my.cnf to max_connections=250 or more but i want to know how avoid this

My Xampp version is old, but i don’t know to update without loose my data.

thanks for your answers

2

How frequently are your Players connecting in?

Your users won’t make much difference, it’ll be the Players connecting repeatedly that puts load on the CMS.

3

All 6 min, players connected to CMS to verify data. I need a check all 6 minutes.
I think that player disconnected after check to the CMS

4

Yes they do disconnect between checks, but each check will use between 5 and 10 connections to the database depending on how you have it configured.

You should probably have a look at the MySQL process list and see what the open connections are doing and work back from there.