Is there an upper limit on the number of rollbacks in MySQL5.1 with InnoDB?
I am manipulating data with InnoDB MySQL5.1 and using transactions when I do INSERT, UPDATE on multiple tables. I sometimes bring myself by the way, but will the method, as far as the amount of data know, whether protectionism can be rolled back when I roll back protectionism at the starting point of a transaction during an INSERT failure?
However, I do not think that a rollback of protectionism is possible with a few hundred cases, several thousand cases without any restrictions, but I want to understand what seems to be some other goal, and I think I advise you. / P >
a source to share
It's variable limited max_binlog_cache_size
. If you change more data than this, you will receive an error message and the transaction will be automatically rolled back.
From a practical point of view, on a 64-bit computer, you will run out of memory and replace before the default is 16PB.
a source to share