mysql innodb max size of transaction
Posted
by chris
on Stack Overflow
See other posts from Stack Overflow
or by chris
Published on 2010-04-27T18:53:43Z
Indexed on
2010/04/27
19:03 UTC
Read the original article
Hit count: 333
Using mysql 5.1.41 and innodb
I'm doing some data import, but can't use load data infile, so I'm manually issuing insert statements. I found that it's much faster to disable auto commit and issue say, 100 insert statements and then commit, instead of the implicit commit after each insert.
It got me thinking, what limits are there to how much data I can put into a transaction? Is there a limit on the number of statements, or does it have to do with the size in bytes etc...?
© Stack Overflow or respective owner