MySQL max_connections ignores cnf file
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mysql-server (Ubuntu) |
New
|
Undecided
|
Unassigned |
Bug Description
Changing max_connections in /etc/mysql/
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/
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-