MySQL Forums
Forum List  »  MyISAM

MyISAM multi queries slow performance
Posted by: Kaihao Wang
Date: June 04, 2018 05:43PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
MyISAM multi queries slow performance
252
June 04, 2018 05:43PM


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.