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

[JW <jw@xxxxxxxxxx>]

> 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

-- 

----------------------
System Administrator - Cedar Creek Software
http://www.cedarcreeksoftware.com

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