MyISAM multi queries slow performance
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.
Lets say that without splitting the jobs it takes 312s to 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).
I manually open multiple connections in MySQL both and they delivered similar results, which was not as good as I thought.
Can anyone help to explain?
Appreciated
Subject
Views
Written By
Posted
MyISAM multi queries slow performance
1442
June 04, 2018 05:43PM
845
June 04, 2018 09:58PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.