Re: transaction limits?

On Fri, Oct 21, 2005 at 12:25:36PM +0200, Nicolas Barbier wrote:
> On 10/21/05, Richard Huxton <dev@archonet.com> wrote:
> > jeff sacksteder wrote:
> > > Are there known limits to how many rows can be inserted by one transaction,
>
> > Well, the system will need to be able to roll back the transaction, ...
>
> Just by not indicating that a transaction did commit, others will keep
> ignoring its rows. There is nothing to rollback here, thanks to MVCC.

Also, I've just done 300 million row INSERTs, from a 'mysqldump', inside
a single transaction. So there doesn't appear to be any implementation
problems that would stop you from reaching the theoretical table limits.

    -Mark