Mysql innodb maximum transaction size

Question

Using mysql 5.1.41 and innodb

I am importing some data, but I can’t use the data load data, so I manually issue the insert instructions. I found it much faster to turn off auto-commit and the problem of, say, 100 insert statements and then commit, instead of implicit commit after each insert.

This made me wonder what limitations exist for how much data I can contribute to a transaction. Is there a limit on the number of operators, or is it related to the size in bytes, etc. ??

Answer 1

for innodb, the transaction is limited only by the size of the redo log - so if you are making very large transactions, make sure you set innodb_log_file_size = 256M (or more). Please note that in case of failure, the flaw will take some time ...