title: how to utilise multiple processing in MySQL Workbench in the Server
body: <p>I am currently using MySQL Workbench of AWS to process data. I created my code as stored procedures with parameters so that I can call it to process. The thought of this function is that it sliced the main tables into multiple sub_tables based on the parameters entered and created their own temp tables to process.</p>
  
  <p>Lets say that without splitting the jobs it takes 312sto complete
  and when I split it into 7 instances to run simultaneously, it takes 183s for them to complete ( I was expecting to achieve a similar result like 312/7 = 45s around).</p>
  
  <p>I tried to triggered the process through python and manually open multiple connections in MySQL both and they delivered similar results, which was not as good as I thought.</p>
  
  <p>Can anyone help to explain?</p>
  
  <p>Appreciated</p>