MySQL Forums
Forum List  »  Newbie

Re: auto commit
Posted by: Daniel Fisher
Date: May 29, 2014 06:23AM

I was coming at this based on

http://dev.mysql.com/doc/refman/5.5/en/optimizing-innodb-bulk-data-loading.html

When importing data into InnoDB, turn off autocommit mode, because it performs a log flush to disk for every insert. To disable autocommit during your import operation, surround it with SET autocommit and COMMIT statements:

I think you are effectively saying if I have block and surrounded with start transactions and commit it will not do a log flush.

The insert itself is not that bad I am shifting 100 million rows per hour.

MySQL is so different to Oracle as you know Oracle will never do an auto commit, unless you change the instance behaviour.

I was concerned that I was causing a log flush for every row, which is hugely decremental in Oracle I assume the same in MySQL.

I will be moving this all into a stored procedure as well.

As always thanks
Daniel

Options: ReplyQuote


Subject
Written By
Posted
May 28, 2014 08:29AM
May 28, 2014 12:28PM
May 29, 2014 06:26AM
May 29, 2014 09:35AM
May 30, 2014 05:54AM
May 28, 2014 01:00PM
Re: auto commit
May 29, 2014 06:23AM
May 29, 2014 06:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.