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

Why is mysql locking tables on insert

2001-09-24 Thread Rafal Jank
Hi, I have strange problem with mysql. When I run mysqladmin processlist i get output (I cut off selects): | 4045633 | konkursy | targi1.wp.pl | konkursy2 | Query | 14| Locked | insert into bb2_ludzie_tak values ('Marzena')