MySQL Forums
Forum List  »  MySQL in Oracle Cloud

MYSQL Performance Issue in CLOUD
Posted by: Ravindra Mallina
Date: February 28, 2017 03:55AM

Hi Folks,

We are facing performance issue in MYSQL. We are inserting the data to the tables using stored procedures, where we fetch the data from a table present in another schema and perfrom small validations using single sub query (which is having 1 million records) and load the data into the table.

It is taking 25k to 30k records to load per hour, earlier the same process used to load 80k to 0.1 million records per hour. Not sure what is causing the issue.

Note: MYSQL RDS system is present in Cloud and we are accessing it through client VPN.

Still we need to load 10 Million records for each table, there total of 7 Tables with such huge amount of data.

Please can some one help us on this.

Regards,
Ravindra M

Options: ReplyQuote


Subject
Written By
Posted
MYSQL Performance Issue in CLOUD
February 28, 2017 03:55AM


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.