Re: Why is mysql locking tables on insert

2001-09-26 Thread Jeremy Zawodny
On Mon, Sep 24, 2001 at 10:14:59AM +0200, Rafal Jank wrote: > Hi, > > Why is mysql locking table during insert operastion? The version is > 3.23.22, so it shouldn't behave like this... Have you ever deleted records from the table (and not run an OPTIMIZE TABLE afterward)? If there are "holes" i

Re: Why is mysql locking tables on insert

2001-09-24 Thread Rafal Jank
Fred van Engen wrote: > > Rafal, > > On Mon, Sep 24, 2001 at 10:14:59AM +0200, Rafal Jank wrote: > > Why is mysql locking table during insert operastion? The version is 3.23.22, so > > it shouldn't behave like this... > > > > If you mean it shouldn't behave like this because it does concurrent

Re: Why is mysql locking tables on insert

2001-09-24 Thread Fred van Engen
Rafal, On Mon, Sep 24, 2001 at 10:14:59AM +0200, Rafal Jank wrote: > Why is mysql locking table during insert operastion? The version is 3.23.22, so > it shouldn't behave like this... > If you mean it shouldn't behave like this because it does concurrent inserts, then note that they work only o