Re: InnoDB & Replication questions...

2002-01-21 Thread Jeremy Zawodny
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

Re: InnoDB & Replication questions...

2002-01-21 Thread Heikki Tuuri
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