Luigi123 Posted July 23, 2017 Author Posted July 23, 2017 Still not working and I can't join my Game Server because of the error.
wolstech Posted July 23, 2017 Posted July 23, 2017 Seeing Krydos said there wasn't any open after you stopped the game server, the game server itself is likely to blame. The connections probably reopened when you relaunched the game server. Krydos will have to confirm what he sees with the game server running again, but I suspect the game server is either buggy, broken, or poorly designed and is not closing them after use as it should...your next step would probably be to troubleshoot/update/replace the game server software.
Krydos Posted July 23, 2017 Posted July 23, 2017 Yep, you're maxed out on sleeping connections again.
wolstech Posted July 23, 2017 Posted July 23, 2017 The game server is broken, so your best bet is to talk to whoever makes/runs the game server software that's running at the IP Krydos posted, and ask why it doesn't close its SQL connections like it should. It's likely either a bug or poor design, especially since the connections sit there open with absolutely no usage.
Luigi123 Posted July 23, 2017 Author Posted July 23, 2017 Wait, can you increase MySQL connections? I found this site where you can increase MySQL connections: https://stackoverflow.com/questions/22297773/how-to-increase-mysql-connectionsmax-connections
wolstech Posted July 23, 2017 Posted July 23, 2017 If the server is broken, it'll just eat up the additional ones and leave them open too. Krydos might be willing to try increasing it, but it wont actually fix the problem (properly made software will close unused connections when done with them), it'd just delay or hide the problem.
Luigi123 Posted July 23, 2017 Author Posted July 23, 2017 I ask my Game Server host and ask why I can't join my server and he said: "the issue i'm seeing is that the database you're using only allows few connections" "in fact, max_user_connections is triggered" "basically either your database host increases the limit or you have to move your databases elsewhere" Will just see if Krydos can increase MySQL connections.
Krydos Posted July 23, 2017 Posted July 23, 2017 How many open connections does this software think it needs? If I increase the max open connections and the software just sits with that many more connections open it just degrades the performance of everyone else on the server even more and you'll still get the error.
Luigi123 Posted July 24, 2017 Author Posted July 24, 2017 Just increased 350 and we'll see what happens. If not, changed it back to default.
Luigi123 Posted July 24, 2017 Author Posted July 24, 2017 Did you increased yet? Actually Krydos, just increased 900. Because it has more space.
Krydos Posted July 24, 2017 Posted July 24, 2017 How about you ask whomever it is that wrote the software how many simultaneous open mysql connections it needs?
Luigi123 Posted July 25, 2017 Author Posted July 25, 2017 Just got a message from my Game host saying "i really don't know, that depends on your setup... everything is fine if you leave the value as default to 150, i guess they're using something like 5 now"
Krydos Posted July 26, 2017 Posted July 26, 2017 150 is a no. I've got an idea. How about I write a script to kill the broken mysql connections every few seconds that this buggy software opens and never closes? Want to try that? I'm not going to let your account hog the entire server's worth of mysql connections without even transferring any data for hours. That's completely ridiculous.
Recommended Posts