Innodb: When bulk inserting or updating - how to disable transactions?
You cannot turn off transactions.

It is assumed that ROLLBACK is the exception, not the rule.  Are you trying to make it the "normal" path?

5 days vs 2 hours -- this is far more extreme than I would expect.  Perhaps you are running out of RAM?  Or swapping?

Please provide more details on the task; we may be able to help you 'solve' the problem in a way other than "turning off transactions".