> Britt> o Lock optimization - MySQL executor acquired > Britt> more locks than required for common queries. > > Just a note: The extra locks are only relevant for Gemini and BDB tables, > not for MyISAM or InnoDB tables.
The extra locks issue does apply to InnoDB for update statements and select for update statements. Of course it does not apply to MyISAM since MyISAM has neither row level locking or transactions. -regards Richard Tucker http://www.nusphere.com Gemini team member --------------------------------------------------------------------- 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