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" in your table, then MySQL will not allow concurrent inserts (yet?). There is some talk about possibly allowing "dirty reads" on MyISAM tables. Basically, it means that MyISAM tables will respect the "READ UNCOMMITTED" isolation level. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 21 days, processed 395,245,024 queries (217/sec. avg) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
