is it normal for there to be 30+ MySQL connections (sleeping) for the ispconfig user at all times? I’m having an issue recently where MySQL is reaching the maximum number of connections almost immediately after restarting MySQL or the entire server. Max connections was not set on my config file so my understanding is that it would default to 100. Not really sure where the other ~65 connections might be unless they were opening and closing very quickly that I didn’t see them in the list. I changed config to allow 200 but want to make sure I’m not just putting a band aid on a bigger issue. There have been no config changes or updates done recently and the only thing that was added was another db and site a few weeks ago but should literally have 0 traffic going to it as it was just for development. Currently have version 3.0.5.4p9 running on Ubuntu 14.04
Yes, that's normal. This is not just ispconfig, actually it is not ispconfig at all unless you are currently logged into the interface, the user with the name 'ispconfig' is user by many services on your server to connect to mysql like postfix, dovecot, amavis and pure-ftpd. You can safely set the max connectiosn to 500.
Thanks, Any idea why it would run fine for many years and now all of a sudden having this issue? Was I just skating by under the max number of connections and now the demand increased just enough to put me over? Any common security concerns to check that could also cause this beyond simply normal usage? Thanks again!
This is quite likely. A sudden mail boost (e.g. incoming spam) or a short traffic boost to a hosted website might cause this. I won't be concerned that a live searcher hits the 100 connection limit, that's in the normal range.
