MySQL Bugs: #74704: Inserts into MYSQL database using ODBC Driver MYSQL ODBC 5.1 is very slow

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

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.

Hello Satish Dhangye,

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

Thanks,
Chiranjeevi.

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".