Mixing
MySQL 5.7 uses more memory than specified (in LinuxMint 19)
up vote
0
down vote
favorite
On a 2GByte machine, Linuxmint 19 is using about 1,5GByte of memory in MySQL5.7 but is only adding a few lines in the database for an app which adds few lines per minute.
I specified key_buffer_size =512M in the configuration file
/etc/mysql/mysql.conf.d/mysql.cnf
What can cause this behavior? For sure my machine has not enough memory with this, should MySQL not see this also?
I am using INNODB, does it have separate settings for MySQL5.7 for this issue?
mysql linux linuxmint
asked 2 days ago
Bart Mensfort
190212
add a comment |
up vote
0
down vote
favorite
On a 2GByte machine, Linuxmint 19 is using about 1,5GByte of memory in MySQL5.7 but is only adding a few lines in the database for an app which adds few lines per minute.
I specified key_buffer_size =512M in the configuration file
/etc/mysql/mysql.conf.d/mysql.cnf
What can cause this behavior? For sure my machine has not enough memory with this, should MySQL not see this also?
I am using INNODB, does it have separate settings for MySQL5.7 for this issue?
mysql linux linuxmint
asked 2 days ago
Bart Mensfort
190212
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
On a 2GByte machine, Linuxmint 19 is using about 1,5GByte of memory in MySQL5.7 but is only adding a few lines in the database for an app which adds few lines per minute.
I specified key_buffer_size =512M in the configuration file
/etc/mysql/mysql.conf.d/mysql.cnf
What can cause this behavior? For sure my machine has not enough memory with this, should MySQL not see this also?
I am using INNODB, does it have separate settings for MySQL5.7 for this issue?
mysql linux linuxmint
asked 2 days ago
Bart Mensfort
190212
On a 2GByte machine, Linuxmint 19 is using about 1,5GByte of memory in MySQL5.7 but is only adding a few lines in the database for an app which adds few lines per minute.
I specified key_buffer_size =512M in the configuration file
/etc/mysql/mysql.conf.d/mysql.cnf
What can cause this behavior? For sure my machine has not enough memory with this, should MySQL not see this also?
I am using INNODB, does it have separate settings for MySQL5.7 for this issue?
mysql linux linuxmint
mysql linux linuxmint
asked 2 days ago
Bart Mensfort
190212
asked 2 days ago
Bart Mensfort
190212
asked 2 days ago
Bart Mensfort
190212
asked 2 days ago
Bart Mensfort
190212
asked 2 days ago
Bart Mensfort
190212
190212
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
up vote
0
down vote
To use more ram can be result of number of connections to the DB. Make sure all the connections are properly closed after execution and you can check number of process by
SHOW FULL PROCESSLIST; on MYSQL console.
You can change the connections by,
set global max_connections = 200;
When you restart MySQL the next time it will use this setting instead of the default.
answered 2 days ago
vish
8710
add a comment |
up vote
0
down vote
You can use the official Documentation of mysql where they have clearly explained about memory usage.
answered 2 days ago
Kasun Piyasena
1
New contributor
Kasun Piyasena is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
To use more ram can be result of number of connections to the DB. Make sure all the connections are properly closed after execution and you can check number of process by
SHOW FULL PROCESSLIST; on MYSQL console.
You can change the connections by,
set global max_connections = 200;
When you restart MySQL the next time it will use this setting instead of the default.
answered 2 days ago
vish
8710
add a comment |
up vote
0
down vote
To use more ram can be result of number of connections to the DB. Make sure all the connections are properly closed after execution and you can check number of process by
SHOW FULL PROCESSLIST; on MYSQL console.
You can change the connections by,
set global max_connections = 200;
When you restart MySQL the next time it will use this setting instead of the default.
answered 2 days ago
vish
8710
add a comment |
up vote
0
down vote
up vote
0
down vote
To use more ram can be result of number of connections to the DB. Make sure all the connections are properly closed after execution and you can check number of process by
SHOW FULL PROCESSLIST; on MYSQL console.
You can change the connections by,
set global max_connections = 200;
When you restart MySQL the next time it will use this setting instead of the default.
answered 2 days ago
vish
8710
To use more ram can be result of number of connections to the DB. Make sure all the connections are properly closed after execution and you can check number of process by
SHOW FULL PROCESSLIST; on MYSQL console.
You can change the connections by,
set global max_connections = 200;
When you restart MySQL the next time it will use this setting instead of the default.
answered 2 days ago
vish
8710
answered 2 days ago
vish
8710
answered 2 days ago
vish
8710
answered 2 days ago
vish
8710
8710
add a comment |
add a comment |
up vote
0
down vote
You can use the official Documentation of mysql where they have clearly explained about memory usage.
answered 2 days ago
Kasun Piyasena
1
New contributor
Kasun Piyasena is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
up vote
0
down vote
You can use the official Documentation of mysql where they have clearly explained about memory usage.
answered 2 days ago
Kasun Piyasena
1
New contributor
Kasun Piyasena is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
up vote
0
down vote
up vote
0
down vote
You can use the official Documentation of mysql where they have clearly explained about memory usage.
answered 2 days ago
Kasun Piyasena
1
New contributor
Kasun Piyasena is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
You can use the official Documentation of mysql where they have clearly explained about memory usage.
answered 2 days ago
Kasun Piyasena
1
New contributor
Kasun Piyasena is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 2 days ago
Kasun Piyasena
1
New contributor
Kasun Piyasena is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 2 days ago
Kasun Piyasena
1
answered 2 days ago
Kasun Piyasena
1
1
New contributor
Kasun Piyasena is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Kasun Piyasena is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Kasun Piyasena is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
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%2fstackoverflow.com%2fquestions%2f53373111%2fmysql-5-7-uses-more-memory-than-specified-in-linuxmint-19%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
