mySQL not reading max_connections configuration
I am trying to change the max_connections configuration for a mysql instance running on a Ubuntu 16.04 server. I have tried placing this configuration...
[mysqld]
max_connections = 400
...in the following files already: /etc/my.cnf, /etc/mysql/my.cnf, /etc/mysql/mysql.conf.d/mysqld.cnf, /etc/mysql/conf.d/mysql.cnf.
I also added the following lines to /etc/apparmor.d/usr.sbin.mysqld and restarted apparmor:
/etc/mysql/mysql.conf.d/* rl,
/etc/mysql/conf.d/* rl,
Nevertheless, every time I restart the mysql service, I am getting a value of 214 from the following query:
show global variables like "max_connections";
The mysql version is mysql Ver 14.14 Distrib 5.7.19, for Linux (x86_64) using EditLine wrapper.
What am I missing?
16.04 mysql
asked Oct 11 '17 at 15:25
rreyes1979rreyes1979
12618
add a comment |
I am trying to change the max_connections configuration for a mysql instance running on a Ubuntu 16.04 server. I have tried placing this configuration...
[mysqld]
max_connections = 400
...in the following files already: /etc/my.cnf, /etc/mysql/my.cnf, /etc/mysql/mysql.conf.d/mysqld.cnf, /etc/mysql/conf.d/mysql.cnf.
I also added the following lines to /etc/apparmor.d/usr.sbin.mysqld and restarted apparmor:
/etc/mysql/mysql.conf.d/* rl,
/etc/mysql/conf.d/* rl,
Nevertheless, every time I restart the mysql service, I am getting a value of 214 from the following query:
show global variables like "max_connections";
The mysql version is mysql Ver 14.14 Distrib 5.7.19, for Linux (x86_64) using EditLine wrapper.
What am I missing?
16.04 mysql
asked Oct 11 '17 at 15:25
rreyes1979rreyes1979
12618
I changed mine in/etc/mysql/my.cnfand restarted mysql and it changed
– George Udosen
Oct 11 '17 at 15:51
add a comment |
I am trying to change the max_connections configuration for a mysql instance running on a Ubuntu 16.04 server. I have tried placing this configuration...
[mysqld]
max_connections = 400
...in the following files already: /etc/my.cnf, /etc/mysql/my.cnf, /etc/mysql/mysql.conf.d/mysqld.cnf, /etc/mysql/conf.d/mysql.cnf.
I also added the following lines to /etc/apparmor.d/usr.sbin.mysqld and restarted apparmor:
/etc/mysql/mysql.conf.d/* rl,
/etc/mysql/conf.d/* rl,
Nevertheless, every time I restart the mysql service, I am getting a value of 214 from the following query:
show global variables like "max_connections";
The mysql version is mysql Ver 14.14 Distrib 5.7.19, for Linux (x86_64) using EditLine wrapper.
What am I missing?
16.04 mysql
asked Oct 11 '17 at 15:25
rreyes1979rreyes1979
12618
I am trying to change the max_connections configuration for a mysql instance running on a Ubuntu 16.04 server. I have tried placing this configuration...
[mysqld]
max_connections = 400
...in the following files already: /etc/my.cnf, /etc/mysql/my.cnf, /etc/mysql/mysql.conf.d/mysqld.cnf, /etc/mysql/conf.d/mysql.cnf.
I also added the following lines to /etc/apparmor.d/usr.sbin.mysqld and restarted apparmor:
/etc/mysql/mysql.conf.d/* rl,
/etc/mysql/conf.d/* rl,
Nevertheless, every time I restart the mysql service, I am getting a value of 214 from the following query:
show global variables like "max_connections";
The mysql version is mysql Ver 14.14 Distrib 5.7.19, for Linux (x86_64) using EditLine wrapper.
What am I missing?
16.04 mysql
16.04 mysql
asked Oct 11 '17 at 15:25
rreyes1979rreyes1979
12618
asked Oct 11 '17 at 15:25
rreyes1979rreyes1979
12618
asked Oct 11 '17 at 15:25
rreyes1979rreyes1979
12618
asked Oct 11 '17 at 15:25
rreyes1979rreyes1979
12618
asked Oct 11 '17 at 15:25
rreyes1979rreyes1979
12618
12618
I changed mine in/etc/mysql/my.cnfand restarted mysql and it changed
– George Udosen
Oct 11 '17 at 15:51
add a comment |
I changed mine in/etc/mysql/my.cnfand restarted mysql and it changed
– George Udosen
Oct 11 '17 at 15:51
I changed mine in
/etc/mysql/my.cnf and restarted mysql and it changed– George Udosen
Oct 11 '17 at 15:51
I changed mine in
/etc/mysql/my.cnf and restarted mysql and it changed– George Udosen
Oct 11 '17 at 15:51
add a comment |
1 Answer
1
active
oldest
votes
In Ubuntu 16.04 the limits for the MySQL service are defined in the Systemd configuration file. To force MySQL read the value defined in your mysqld.cnf edit the service config:
sudo systemctl edit mysql.service
Add the following lines then save the file:
[Service]
LimitNOFILE=infinity
Restart the service:
sudo systemctl daemon-reload
sudo systemctl restart mysql.service
MySQL should use now the value defined in you config files.
answered Jan 29 at 22:47
Florin RFlorin R
11
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "89"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f963978%2fmysql-not-reading-max-connections-configuration%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
In Ubuntu 16.04 the limits for the MySQL service are defined in the Systemd configuration file. To force MySQL read the value defined in your mysqld.cnf edit the service config:
sudo systemctl edit mysql.service
Add the following lines then save the file:
[Service]
LimitNOFILE=infinity
Restart the service:
sudo systemctl daemon-reload
sudo systemctl restart mysql.service
MySQL should use now the value defined in you config files.
answered Jan 29 at 22:47
Florin RFlorin R
11
add a comment |
In Ubuntu 16.04 the limits for the MySQL service are defined in the Systemd configuration file. To force MySQL read the value defined in your mysqld.cnf edit the service config:
sudo systemctl edit mysql.service
Add the following lines then save the file:
[Service]
LimitNOFILE=infinity
Restart the service:
sudo systemctl daemon-reload
sudo systemctl restart mysql.service
MySQL should use now the value defined in you config files.
answered Jan 29 at 22:47
Florin RFlorin R
11
add a comment |
In Ubuntu 16.04 the limits for the MySQL service are defined in the Systemd configuration file. To force MySQL read the value defined in your mysqld.cnf edit the service config:
sudo systemctl edit mysql.service
Add the following lines then save the file:
[Service]
LimitNOFILE=infinity
Restart the service:
sudo systemctl daemon-reload
sudo systemctl restart mysql.service
MySQL should use now the value defined in you config files.
answered Jan 29 at 22:47
Florin RFlorin R
11
In Ubuntu 16.04 the limits for the MySQL service are defined in the Systemd configuration file. To force MySQL read the value defined in your mysqld.cnf edit the service config:
sudo systemctl edit mysql.service
Add the following lines then save the file:
[Service]
LimitNOFILE=infinity
Restart the service:
sudo systemctl daemon-reload
sudo systemctl restart mysql.service
MySQL should use now the value defined in you config files.
answered Jan 29 at 22:47
Florin RFlorin R
11
answered Jan 29 at 22:47
Florin RFlorin R
11
answered Jan 29 at 22:47
Florin RFlorin R
11
answered Jan 29 at 22:47
Florin RFlorin R
11
11
add a comment |
add a comment |
Thanks for contributing an answer to Ask Ubuntu!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f963978%2fmysql-not-reading-max-connections-configuration%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
I changed mine in
/etc/mysql/my.cnfand restarted mysql and it changed– George Udosen
Oct 11 '17 at 15:51