MySQL Workbench do not use all the cpu cores












0

















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










share|improve this question



























    0

















    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










    share|improve this question

























      0












      0








      0










      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










      share|improve this question
















      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






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 13 '18 at 16:56









      gabry010gabry010

      1




      1
























          1 Answer
          1






          active

          oldest

          votes


















          0














          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.






          share|improve this answer
























          • But in that moment mysql is not used, cause i haven't sent any query to the DB

            – gabry010
            Nov 14 '18 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 '18 at 15:55











          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
          });


          }
          });














          draft saved

          draft discarded


















          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









          0














          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.






          share|improve this answer
























          • But in that moment mysql is not used, cause i haven't sent any query to the DB

            – gabry010
            Nov 14 '18 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 '18 at 15:55
















          0














          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.






          share|improve this answer
























          • But in that moment mysql is not used, cause i haven't sent any query to the DB

            – gabry010
            Nov 14 '18 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 '18 at 15:55














          0












          0








          0







          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.






          share|improve this answer













          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.







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Nov 14 '18 at 4:42









          Rick JamesRick James

          67.5k558100




          67.5k558100













          • But in that moment mysql is not used, cause i haven't sent any query to the DB

            – gabry010
            Nov 14 '18 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 '18 at 15:55



















          • But in that moment mysql is not used, cause i haven't sent any query to the DB

            – gabry010
            Nov 14 '18 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 '18 at 15:55

















          But in that moment mysql is not used, cause i haven't sent any query to the DB

          – gabry010
          Nov 14 '18 at 14:05





          But in that moment mysql is not used, cause i haven't sent any query to the DB

          – gabry010
          Nov 14 '18 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 '18 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 '18 at 15:55


















          draft saved

          draft discarded




















































          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.




          draft saved


          draft discarded














          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





















































          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







          Popular posts from this blog

          Bressuire

          Vorschmack

          Quarantine