MySQL Workbench do not use all the cpu cores
I have a little problem with my Workbench on Ubuntu 16.04.
I noticed while I am copying a multiple csv-row on a table (not INSERT), workbench became grey and then stack for a while, usually more the 10/15 min.
I know that there are other way to import csv etc... but the problem is that while he is copying the data in the table, just to show to myself how beautifull is gonna be the table after the insert, the CPU1 goes straigth to 100% and all the other cpu stays around 5% to 10% and then after a while it switch to another cpu and same story happened. Cause is not mysql doing the job, but the software, why the software doesn't use all 4 core to get a boost?
I have an Intel® Core™ i7-3537U CPU @ 2.00GHz × 4 and 8GB RAM
mysql performance ubuntu cpu workbench
asked Nov 13 at 16:56
gabry010
1
add a comment |
I have a little problem with my Workbench on Ubuntu 16.04.
I noticed while I am copying a multiple csv-row on a table (not INSERT), workbench became grey and then stack for a while, usually more the 10/15 min.
I know that there are other way to import csv etc... but the problem is that while he is copying the data in the table, just to show to myself how beautifull is gonna be the table after the insert, the CPU1 goes straigth to 100% and all the other cpu stays around 5% to 10% and then after a while it switch to another cpu and same story happened. Cause is not mysql doing the job, but the software, why the software doesn't use all 4 core to get a boost?
I have an Intel® Core™ i7-3537U CPU @ 2.00GHz × 4 and 8GB RAM
mysql performance ubuntu cpu workbench
asked Nov 13 at 16:56
gabry010
1
add a comment |
I have a little problem with my Workbench on Ubuntu 16.04.
I noticed while I am copying a multiple csv-row on a table (not INSERT), workbench became grey and then stack for a while, usually more the 10/15 min.
I know that there are other way to import csv etc... but the problem is that while he is copying the data in the table, just to show to myself how beautifull is gonna be the table after the insert, the CPU1 goes straigth to 100% and all the other cpu stays around 5% to 10% and then after a while it switch to another cpu and same story happened. Cause is not mysql doing the job, but the software, why the software doesn't use all 4 core to get a boost?
I have an Intel® Core™ i7-3537U CPU @ 2.00GHz × 4 and 8GB RAM
mysql performance ubuntu cpu workbench
asked Nov 13 at 16:56
gabry010
1
I have a little problem with my Workbench on Ubuntu 16.04.
I noticed while I am copying a multiple csv-row on a table (not INSERT), workbench became grey and then stack for a while, usually more the 10/15 min.
I know that there are other way to import csv etc... but the problem is that while he is copying the data in the table, just to show to myself how beautifull is gonna be the table after the insert, the CPU1 goes straigth to 100% and all the other cpu stays around 5% to 10% and then after a while it switch to another cpu and same story happened. Cause is not mysql doing the job, but the software, why the software doesn't use all 4 core to get a boost?
I have an Intel® Core™ i7-3537U CPU @ 2.00GHz × 4 and 8GB RAM
mysql performance ubuntu cpu workbench
mysql performance ubuntu cpu workbench
asked Nov 13 at 16:56
gabry010
1
asked Nov 13 at 16:56
gabry010
1
asked Nov 13 at 16:56
gabry010
1
asked Nov 13 at 16:56
gabry010
1
asked Nov 13 at 16:56
gabry010
1
1
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
No.
A single connection in MySQL will use only a single CPU core.
If you could determine what underlying SQL is involved, perhaps we could help you find a more efficient way to do the task.
answered Nov 14 at 4:42
Rick James
66k55897
But in that moment mysql is not used, cause i haven't sent any query to the DB
– gabry010
Nov 14 at 14:05
@gabry010 - "he is copying the data in the table" -- How is this done? For that matter, what do you mean? "reading the data", "copying the data from one tale to another", "copying the data to the screen", "using a pencil to copy the data"???
– Rick James
Nov 14 at 15:55
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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%2fstackoverflow.com%2fquestions%2f53285976%2fmysql-workbench-do-not-use-all-the-cpu-cores%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
No.
A single connection in MySQL will use only a single CPU core.
If you could determine what underlying SQL is involved, perhaps we could help you find a more efficient way to do the task.
answered Nov 14 at 4:42
Rick James
66k55897
But in that moment mysql is not used, cause i haven't sent any query to the DB
– gabry010
Nov 14 at 14:05
@gabry010 - "he is copying the data in the table" -- How is this done? For that matter, what do you mean? "reading the data", "copying the data from one tale to another", "copying the data to the screen", "using a pencil to copy the data"???
– Rick James
Nov 14 at 15:55
add a comment |
No.
A single connection in MySQL will use only a single CPU core.
If you could determine what underlying SQL is involved, perhaps we could help you find a more efficient way to do the task.
answered Nov 14 at 4:42
Rick James
66k55897
But in that moment mysql is not used, cause i haven't sent any query to the DB
– gabry010
Nov 14 at 14:05
@gabry010 - "he is copying the data in the table" -- How is this done? For that matter, what do you mean? "reading the data", "copying the data from one tale to another", "copying the data to the screen", "using a pencil to copy the data"???
– Rick James
Nov 14 at 15:55
add a comment |
No.
A single connection in MySQL will use only a single CPU core.
If you could determine what underlying SQL is involved, perhaps we could help you find a more efficient way to do the task.
answered Nov 14 at 4:42
Rick James
66k55897
No.
A single connection in MySQL will use only a single CPU core.
If you could determine what underlying SQL is involved, perhaps we could help you find a more efficient way to do the task.
answered Nov 14 at 4:42
Rick James
66k55897
answered Nov 14 at 4:42
Rick James
66k55897
answered Nov 14 at 4:42
Rick James
66k55897
answered Nov 14 at 4:42
Rick James
66k55897
66k55897
But in that moment mysql is not used, cause i haven't sent any query to the DB
– gabry010
Nov 14 at 14:05
@gabry010 - "he is copying the data in the table" -- How is this done? For that matter, what do you mean? "reading the data", "copying the data from one tale to another", "copying the data to the screen", "using a pencil to copy the data"???
– Rick James
Nov 14 at 15:55
add a comment |
But in that moment mysql is not used, cause i haven't sent any query to the DB
– gabry010
Nov 14 at 14:05
@gabry010 - "he is copying the data in the table" -- How is this done? For that matter, what do you mean? "reading the data", "copying the data from one tale to another", "copying the data to the screen", "using a pencil to copy the data"???
– Rick James
Nov 14 at 15:55
But in that moment mysql is not used, cause i haven't sent any query to the DB
– gabry010
Nov 14 at 14:05
But in that moment mysql is not used, cause i haven't sent any query to the DB
– gabry010
Nov 14 at 14:05
@gabry010 - "he is copying the data in the table" -- How is this done? For that matter, what do you mean? "reading the data", "copying the data from one tale to another", "copying the data to the screen", "using a pencil to copy the data"???
– Rick James
Nov 14 at 15:55
@gabry010 - "he is copying the data in the table" -- How is this done? For that matter, what do you mean? "reading the data", "copying the data from one tale to another", "copying the data to the screen", "using a pencil to copy the data"???
– Rick James
Nov 14 at 15:55
add a comment |
Thanks for contributing an answer to Stack Overflow!
- 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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2fstackoverflow.com%2fquestions%2f53285976%2fmysql-workbench-do-not-use-all-the-cpu-cores%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
