On Mon, Jan 21, 2002 at 10:50:10PM +0200, Heikki Tuuri wrote:
>
> this is a known 'feature' which is also mentioned in the
> manual. SHOW TABLE STATUS will set an exclusive lock to the end of
> table to look at the current auto-inc column value, which SHOW TABLE
> STATUS has in its output. Since
Chris,
>Hi there,
>
>I've been experimenting with InnoDB and replication and now have a few
>questions...Firstly, is it a known bug that "SHOW TABLE STATUS" screws up
InnoDB
>transactions? To insert data into my innoDB table I've been using:
>set autocommit=0;
>INSERT ...
>INSERT ...
>...
>comm
Hi there,
I've been experimenting with InnoDB and replication and now have a few
questions...
Firstly, is it a known bug that "SHOW TABLE STATUS" screws up InnoDB
transactions? To insert data into my innoDB table I've been using:
set autocommit=0;
INSERT ...
INSERT ...
...
commit;
In total