INSERT/UPDATE and MyISAM table

[Nat Sakimura]

Hi. In the MyISAM table without any deleted rows, I read in the documentation that INSERT and SELECT can occur concurrently. What about UPDATE? I presume update will issue exclusive lock to the table unlike insert, but I wanted to know for sure. Also, after deleting some rows in the table, if I do the OPTIMIZE TABLE, does the concurrent INSERT/SELECT property return? Best regards, Nat --------------------------------------------------------------------- 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