Roland Häder (roland)'s status on Monday, 19-Jan-2015 22:19:53 CET
-
Roland Häder (roland)'s status on Monday, 19-Jan-2015 22:19:53 CET Roland Häder In case you have #InnoDB performance problems: Set innodb_locks_unsafe_for_binlog=ON Reason: For UPDATE or DELETE statements, InnoDB holds locks only for rows that it updates or deletes. Record locks for nonmatching rows are released after MySQL has evaluated the WHERE condition. This greatly reduces the probability of deadlocks, but they can still happen. #MySQL http://dev.mysql.com/doc/refman/5.0/en/innodb-parameters.html#sysvar_innodb_locks_unsafe_for_binlog