on the page http://dev.mysql.com/doc/mysql/en/InnoDB_Locks_set.html
This statement is confusing.
"If you do not have indexes suitable for your query and MySQL has to scan the
whole table to process the query, every row of the table will become locked"
Is it saying that all at once at the beginning of the table scan a lock is
places on the entire table or is this saying that a lock for each record that
the query is on as it scans the table will be moved through the entire table as
it scans.
If it is a rolling lock then no big deal other clients can access pages of the
table that are not currently being scanned. If it is a table lock then no one
gets any records till the scan is done much the same as MyIsam
Regards
Sean Mathews Nu Tech CTO
struct SoftwareProfessional {
double salary;
long lunches;
float jobs;
char unstable;
void work;
short tempers;
};
________________________________________________________________
Sent via the WebMail system at mail.nutech.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
