# tMysqlCommit

Commits in one go, using a unique connection, a global transaction instead of doing that on every row or every batch and thus provides gain in performance.

tMysqlCommit validates the data processed through the Job into the connected DB.

### In this section

* [tMysqlCommit Standard properties](https://help.qlik.com/talend/en-US/components/7.2/mysql/tmysqlcommit-standard-properties)

**Related concepts**

[Getting the ID for the last inserted record with tMysqlLastInsertId](https://help.qlik.com/talend/en-US/components/7.2/mysql/tmysqlconnection-tmysqllastinsertid-tlogrow-getting-id-for-last-inserted-record-with-tmysqllastinsertid-standard-component-the)

[Sharing a database connection between a parent Job and child Job](https://help.qlik.com/talend/en-US/components/7.2/mysql/tmysqlconnection-tmysqlinput-tlogrow-sharing-database-connection-between-parent-job-and-child-job-standard-component-this)

[Inserting data in mother/daughter tables](https://help.qlik.com/talend/en-US/components/7.2/mysql/tmysqlconnection-tmysqlrollback-tfileinputdelimited-inserting-data-in-mother-daughter-tables-standard-component-the)