Autocommit in tMysqlConnection

One Star

Autocommit in tMysqlConnection

I have designed one job where data is inserted in parent and child tables and I have used tMysqlcommit component to commit the records at a time. So while processing, it is taking huge time to commit as I have crores records and in between if I get any exception whole time getting wasted. So can I use Autocommit option in tMysqlConnection component to commit every single transaction or shall I create connection in tMysqlOutput separately for each table instead of using existing connection to process the data fastly? Can you please help me to resolve it?
One more thing is if we create connection in tMysqlOutput for each table instead of using existing connection, Do id's whatever inserting in parent and child maintain correctly?

Re: Autocommit in tMysqlConnection

Hi sabitha566,
Could you please post your current job design screenshots into forum which will be helpful for us to understand your problem?
Best regards
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now


Introduction to Talend Open Studio for Data Integration.


Downloads and Trials

Test drive Talend's enterprise products.


Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.