sitepoint recently discovered when and why row-level locking (as opposed to table-level) is sometimes a must-have…
http://www.sitepoint.com/blogs/2009/09/08/free-performance-with-mysql-table-types/