wolstech Posted February 9, 2020 Posted February 9, 2020 Tommy's MySQL has been throwing lots of "Too many connections" errors over the past few days. As of this post, most sites on Tommy are throwing that error... It usually clears up after a few minutes, but it has come and gone a few times throughout the day. When it happens, all sites show mysql errors, and I even got one in the shell running an unarchive for zmzmuazz (which failed because of it and had to be retried)... Any idea what's been going on lately with this? I ran into it a few times last week as well. Is someone abusing MySQL and burying it in connections?
Krydos Posted February 11, 2020 Posted February 11, 2020 Is someone abusing MySQL and burying it in connections?Probably. Every two hours mysql closes all the connections so that helps clear out the people who might be abusing the server. I have seen error logs showing the too many connections error, but I've never been at a computer when it was happening. For now I doubled the number of total available connections so that should help a little, but if someone is determined to try to crash the server they will still be able to since we don't have a per user limit. If you see this while it's happening run the command ./mysql_connections and it'll print them all out for you. I can set up automated logging if neither of us are able to run that command while the server is maxed out on connections.
Recommended Posts