Quote:
|
Originally Posted by notjoe
I dont think so, atleast not in the production code they release...Googling for it seems to show noting which says myisam supports row locking.
"Currently, MySQL supports table-level locking for ISAM, INNODB, and MEMORY (HEAP) tables, page-level locking for BDB tables, and row-level locking for InnoDB tables. "
http://dev.mysql.com/doc/mysql/en/internal-locking.html |
Hrmm, I may have seen it in beta versions then perhaps of MySQL 5.....or maybe not. In any case, we prefer using InnoDB ourselves for the row-locking, transactions and performance on large tables. I only use myisam still on very small, static tables (like say a table with categories, statuses, etc...that have < 100 rows and barely ever change). I've also found myisam tables have a much greater chance for corruption than InnoDB tables do.