On Sat, May 10, 2008 at 4:24 PM, JW <[EMAIL PROTECTED]> wrote: >> Table locking will occur with MyISAM tables when any row(s) of the table is >> being updated (Update,Delete,Insert,Load Data etc). >> If you are only executing Select statements, then they can be executed in >> parallel and won't be blocked. > > > Just curious: you say "with MyISAM tables" - do any of the other table types > (InnoDB, Falcon, etc) behave differently? > > Thanks, > > JW
"When locks are necessary, InnoDB uses row-level locking." MySQL 5.0 Certification Study Guide, page 419 -- Rob Wultsch [EMAIL PROTECTED] wultsch (aim) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]