Public bug reported:
Changing max_connections in /etc/mysql/mysql.conf.d/mysqld.cnf caps out
at 214 connections.
The max_connections setting can be adjusted down + has no effect when
value is set to more than 214.
This problem seems to have occurred when systemd was introduced.
Changing /lib/systemd/system/mysql.service LimitNOFILE=value (any value)
followed by...
systemctl daemon-reload
systemctl restart mysqld
Also has no effect, as many articles state.
Due to this problem, Ubuntu MySQL is unusable for sites with slightest
bit of traffic.
This ticket aims to have someone describe the correct way to effect
max_connections to increase past 214 connections.
Temporary fix is...
mysql --defaults-extra-file=/etc/mysql/debian.cnf -e 'SET GLOBAL
max_connections=1000'
** Affects: mysql-server (Ubuntu)
Importance: Undecided
Status: New
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1575982
Title:
MySQL max_connections ignores cnf file
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-server/+bug/1575982/+subscriptions
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
