We have been advised to set innodb_locks_unsafe_for_binlog=1 in the MySQL configuration since Alfresco left Hibernate for iBatis in the DAO layer (see http://docs.alfresco.com/4.0/index.jsp?topic=%2Fcom.alfresco.enterprise.doc%2Fconcepts%2Fmysql-confi...). It prevents MySQL from locking too many rows when accessing tables, and thus eases concurrent accesses, but can cause inconsistent reads. Did someone experienced this configuration in older Alfresco versions, like 3.2 or 3.3, with MySQL 5.1?
