Is this too much memory for mysql on ubuntu?
I had a question about mysql memory usage in a ubuntu server.
I have an AWS EC2 server that hosts about 20 wordpress sites, all conencted to 1 mysql instance. They aren't huge sites by any means, but they are crashing a bit because of memory usage.
I was checked out the memory usage with htop, and noticed a bunch of mysql threads that were spawned.
They mysql process is showing about 11.7% of memory usage. Is that typically too high? I recently added a swapfile to make sure the memory doesn't continue to crash, but I wanted to be sure that I have everything optimized.
free -m
total used free shared buff/cache available
Mem: 1998 766 547 99 684 937
Swap: 1023 5 1018
Thanks
Brendan
server apache2 mysql ram amazon-ec2
edited 50 mins ago
anonymous2
3,33741847
asked 2 hours ago
BrendanBrendan
1
New contributor
Brendan 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 |
I had a question about mysql memory usage in a ubuntu server.
I have an AWS EC2 server that hosts about 20 wordpress sites, all conencted to 1 mysql instance. They aren't huge sites by any means, but they are crashing a bit because of memory usage.
I was checked out the memory usage with htop, and noticed a bunch of mysql threads that were spawned.
They mysql process is showing about 11.7% of memory usage. Is that typically too high? I recently added a swapfile to make sure the memory doesn't continue to crash, but I wanted to be sure that I have everything optimized.
free -m
total used free shared buff/cache available
Mem: 1998 766 547 99 684 937
Swap: 1023 5 1018
Thanks
Brendan
server apache2 mysql ram amazon-ec2
edited 50 mins ago
anonymous2
3,33741847
asked 2 hours ago
BrendanBrendan
1
New contributor
Brendan 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 |
I had a question about mysql memory usage in a ubuntu server.
I have an AWS EC2 server that hosts about 20 wordpress sites, all conencted to 1 mysql instance. They aren't huge sites by any means, but they are crashing a bit because of memory usage.
I was checked out the memory usage with htop, and noticed a bunch of mysql threads that were spawned.
They mysql process is showing about 11.7% of memory usage. Is that typically too high? I recently added a swapfile to make sure the memory doesn't continue to crash, but I wanted to be sure that I have everything optimized.
free -m
total used free shared buff/cache available
Mem: 1998 766 547 99 684 937
Swap: 1023 5 1018
Thanks
Brendan
server apache2 mysql ram amazon-ec2
edited 50 mins ago
anonymous2
3,33741847
asked 2 hours ago
BrendanBrendan
1
New contributor
Brendan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I had a question about mysql memory usage in a ubuntu server.
I have an AWS EC2 server that hosts about 20 wordpress sites, all conencted to 1 mysql instance. They aren't huge sites by any means, but they are crashing a bit because of memory usage.
I was checked out the memory usage with htop, and noticed a bunch of mysql threads that were spawned.
They mysql process is showing about 11.7% of memory usage. Is that typically too high? I recently added a swapfile to make sure the memory doesn't continue to crash, but I wanted to be sure that I have everything optimized.
free -m
total used free shared buff/cache available
Mem: 1998 766 547 99 684 937
Swap: 1023 5 1018
Thanks
Brendan
server apache2 mysql ram amazon-ec2
server apache2 mysql ram amazon-ec2
edited 50 mins ago
anonymous2
3,33741847
asked 2 hours ago
BrendanBrendan
1
New contributor
Brendan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 50 mins ago
anonymous2
3,33741847
asked 2 hours ago
BrendanBrendan
1
New contributor
Brendan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 50 mins ago
anonymous2
3,33741847
edited 50 mins ago
anonymous2
3,33741847
edited 50 mins ago
anonymous2
3,33741847
3,33741847
asked 2 hours ago
BrendanBrendan
1
New contributor
Brendan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 2 hours ago
BrendanBrendan
1
asked 2 hours ago
BrendanBrendan
1
1
New contributor
Brendan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Brendan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Brendan 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 |
0
active
oldest
votes
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
});
}
});
Brendan is a new contributor. Be nice, and check out our Code of Conduct.
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%2f1121831%2fis-this-too-much-memory-for-mysql-on-ubuntu%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Brendan is a new contributor. Be nice, and check out our Code of Conduct.
Brendan is a new contributor. Be nice, and check out our Code of Conduct.
Brendan is a new contributor. Be nice, and check out our Code of Conduct.
Brendan is a new contributor. Be nice, and check out our Code of Conduct.
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%2f1121831%2fis-this-too-much-memory-for-mysql-on-ubuntu%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
