On Thu, 2 Sep 2004 15:19:44 -0400, Sun, Jennifer <[EMAIL PROTECTED]> wrote: > Thanks Marc, > > What version of myisam table you are talking about? We are on 4.0.20, when I ran the > big table query, I tried to insert to it twice without any issues. > The -q worked good for mysql client. Thanks.
There is an optimization that can allow inserts (note: not updates) and selects to happen at the same time, which may be what you are seeing. There are lots of corner cases, etc. so your best bet is to check out the documentation which does a reasonable job of explaining them, in particular: http://dev.mysql.com/doc/mysql/en/Internal_locking.html http://dev.mysql.com/doc/mysql/en/Table_locking.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
