MySQL Forums
Forum List  »  Newbie

multi instances processing performance
Posted by: Kaihao Wang
Date: March 21, 2018 04:24PM

Hi all,

I experienced some troubles on the performance of running multiple instances in MySQL Workbench at the same time.
I tried open several connections and for each connections I call the stored procedures.
The stored procedure has been tailored to create a temp table itself from the main table (Slicing the main table into multiple sub tables to process simultaneously and then join the results back to the outcome table)
Each connection wont lock each other.

For instance, when I used one connection, it took 1000s to process. Then if I have 4 connections I expect to spend 250s overall. However, the time does not scaled down as I thought and I took like 500s or something.

I am running it in AWS RDS and I have 32 VCPU, never run out of any RAM, I/O, etc.

Can anyone help to explain what limits the performance?

Much appreciate!

Options: ReplyQuote


Subject
Written By
Posted
multi instances processing performance
March 21, 2018 04:24PM


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.