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

LimitNOFILE=infinity
LimitMEMLOCK=infinity

# 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

@AnotherMySQLDBA