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