topic MySQL optimization prior to Alfresco 3.4 in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/mysql-optimization-prior-to-alfresco-3-4/m-p/260903#M214033 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>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 </SPAN><A href="http://docs.alfresco.com/4.0/index.jsp?topic=%2Fcom.alfresco.enterprise.doc%2Fconcepts%2Fmysql-config-settings.html" rel="nofollow noopener noreferrer">http://docs.alfresco.com/4.0/index.jsp?topic=%2Fcom.alfresco.enterprise.doc%2Fconcepts%2Fmysql-config-settings.html</A><SPAN>). It prevents MySQL from locking too many rows when accessing tables, and thus eases concurrent accesses, but can cause inconsistent reads.</SPAN><BR /><SPAN>Did someone experienced this configuration in older Alfresco versions, like 3.2 or 3.3, with MySQL 5.1?</SPAN></BODY></HTML> Fri, 20 Apr 2012 08:18:06 GMT rivarola 2012-04-20T08:18:06Z MySQL optimization prior to Alfresco 3.4 https://connect.hyland.com/t5/alfresco-archive/mysql-optimization-prior-to-alfresco-3-4/m-p/260903#M214033 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 locki Fri, 20 Apr 2012 08:18:06 GMT https://connect.hyland.com/t5/alfresco-archive/mysql-optimization-prior-to-alfresco-3-4/m-p/260903#M214033 rivarola 2012-04-20T08:18:06Z Re: MySQL optimization prior to Alfresco 3.4 https://connect.hyland.com/t5/alfresco-archive/mysql-optimization-prior-to-alfresco-3-4/m-p/260904#M214034 <HTML><HEAD></HEAD><BODY><SPAN>Any idea?</SPAN></BODY></HTML> Wed, 03 Apr 2013 15:24:19 GMT https://connect.hyland.com/t5/alfresco-archive/mysql-optimization-prior-to-alfresco-3-4/m-p/260904#M214034 rivarola 2013-04-03T15:24:19Z