Re: Table Locking (Was: Best CPU config for a busy DB server)

["Rob Wultsch" <wultsch@xxxxxxxxx>]

On Sat, May 10, 2008 at 4:24 PM, JW <jw@xxxxxxxxxx> 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
wultsch@xxxxxxxxx
wultsch (aim)

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx