Bug #74704 Inserts into MYSQL database using ODBC Driver MYSQL ODBC 5.1 is very slow
Submitted: 5 Nov 2014 22:09 Modified: 18 Jun 2015 7:13
Reporter: Satish Dhangye Email Updates:
Status: No Feedback Impact on me:
None 
Category:Connector / ODBC Severity:S2 (Serious)
Version:MYSQL ODBC 5.1 OS:Other (AWS)
Assigned to: Assigned Account CPU Architecture:Any
Tags: Informatica, MYSQL ODBC Slow inserts, Slow Inserts into MYSQL, Slow Writes into MYSQL

[5 Nov 2014 22:09] Satish Dhangye
Description:
I am using Informatica as ETL tool which reads data from different sources. I have my Data Warehouse in MYSQL and my informatica workflow write data into MYSQL tables using MYSQL 5.1 ODBC driver. The inserts are at very slow rate (6-7 rows per second) which is very low compared to any other database. When I insert into the same table using a file then it is much faster. Is this some issue with ODBC driver?? Please let me know a resolution for this.

How to repeat:
Try loading a MYSQL table using informatica mapping with MYSQL 5.1 ODBC driver.
[18 May 2015 7:13] Chiranjeevi Battula
Hello Satish Dhangye,

Thank you for the bug report.
Please try with latest versions MySQL Connector / ODBC 5.3.4.

Thanks,
Chiranjeevi.
[19 Jun 2015 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".