max_connections will not change in ubuntu

  • Posted August 22, 2014

I have /etc/my.cnf edited like this on my Ubuntu 14.04 x64 server

open_files_limit = 8192
max_connections = 1000
# etc.

However, after restart of mysql max_connections still says it is 151

What am I doing wrong?


this post is changing open_files_limit I had posted open _ files _ limit but without the spaces

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Ubuntu has moved from Upstart to Systemd from version 15.04 and no longer respects the limits in /etc/security/limits.conf for system services. These limits now apply only to user sessions.

The limits for the MySQL service are defined in the Systemd configuration file, which you should copy from its default location into /etc/systemd and then edit the copy.

sudo cp /lib/systemd/system/mysql.service /etc/systemd/system/
sudo vim /etc/systemd/system/mysql.service # or your editor of choice

Add the following lines to the bottom of the file:


You could also set a numeric limit, eg LimitNOFILE=4096

Now reload the Systemd configuration with:

sudo systemctl daemon-reload

Restart MySQL and it should now obey the max_connections directive.

The MySQL conf file for Ubuntu is usually in the /etc/mysql directory. Try making the changes in the conf file in that directory.