AnsweredAssumed Answered

MySQL optimization prior to Alfresco 3.4

Question asked by rivarola on Apr 20, 2012
Latest reply on Apr 3, 2013 by rivarola
Hi,

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-config-settings.html). 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?

Outcomes