Monday, June 3, 2019

Max_connections 214 4.15.0-46-generic #49-Ubuntu

So the issue of max_connections dropping from the value set in your my.cnf file down to 214 has been around for a little while on Ubuntu.

As an example, it was noted here back in 2015

I ran into this again recently and was resolved with the following steps.

# cp /lib/systemd/system/mysql.service /etc/systemd/system/
# cd /etc/systemd/system/
# vi mysql.service


# systemctl daemon-reload
# systemctl restart mysql

Once those steps completed the MySQL connections were stable at the given parameter in the my.cnf file. 

No comments:

Post a Comment