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

• https://codepoets.co.uk/2015/mysql-max_connections-stuck-on-214/

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.