Bug #85150 MYSQL Performance Issue in CLOUD
Submitted: 23 Feb 2017 13:06 Modified: 23 Feb 2017 14:51
Reporter: Ravindra Mallina Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S5 (Performance)
Version: OS:Any
Assigned to: CPU Architecture:Any

[23 Feb 2017 13:06] Ravindra Mallina 
Description:
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.

How to repeat:
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.
[23 Feb 2017 14:51] MySQL Verification Team 
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.