# wsrep\_slave\_threads and deprecated variable innodb\_locks\_unsafe\_for\_binlog

**URL:** <https://forums.percona.com/t/wsrep-slave-threads-and-deprecated-variable-innodb-locks-unsafe-for-binlog/4752>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [March 2, 2016, 3:14am UTC](https://forums.percona.com/t/wsrep-slave-threads-and-deprecated-variable-innodb-locks-unsafe-for-binlog/4752 "2016-03-02T03:14:34Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mrdr](https://avatars.discourse-cdn.com/v4/letter/m/3ab097/32.png) [@mrdr](https://forums.percona.com/u/mrdr)\
**Post date:** [March 2, 2016, 3:14am UTC](https://forums.percona.com/t/wsrep-slave-threads-and-deprecated-variable-innodb-locks-unsafe-for-binlog/4752/1 "2016-03-02T03:14:34Z")

</div>

Hi!

In the documentation for ​the Galera Cluster, [galeracluster.com/documentation-webpages/performance.html#setting-parallel-slave-threads](http://galeracluster.com/documentation-webpages/performance.html#setting-parallel-slave-threads), it’s stated that you need to set the following two variables:

innodb\_autoinc\_lock\_mode = 2  
innodb\_locks\_unsafe\_for\_binlog = 1

Now it turns out that the second variable is deprecated.

[dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar\_innodb\_locks\_unsafe\_for\_binlog](http://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_locks_unsafe_for_binlog)

Should one set innodb\_locks\_unsafe\_for\_binlog = 0? In a master-slave configuration, will it then have any effect to set wsrep\_slave\_threads \> 1?

Best regards

David

---

<div class="post-metadata">

**Author:** ![vadimtk](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadimtk/32/9528_2.png) [@vadimtk](https://forums.percona.com/u/vadimtk)\
**Post date:** [March 11, 2016, 6:22pm UTC](https://forums.percona.com/t/wsrep-slave-threads-and-deprecated-variable-innodb-locks-unsafe-for-binlog/4752/2 "2016-03-11T18:22:04Z")

</div>

It is deprecated in 5.7.  
In Percona XtraDB Cluster 5.6 you should keep

---

<div class="post-metadata">

**Author:** ![mrdr](https://avatars.discourse-cdn.com/v4/letter/m/3ab097/32.png) [@mrdr](https://forums.percona.com/u/mrdr)\
**Post date:** [September 3, 2016, 3:02am UTC](https://forums.percona.com/t/wsrep-slave-threads-and-deprecated-variable-innodb-locks-unsafe-for-binlog/4752/3 "2016-09-03T03:02:19Z")

</div>

Hi again and sorry for the late reply!

Thank you for your answer.

[url][Redirecting to Google Groups](https://groups.google.com/forum/#!topic/codership-team/dY0KFiu-1r8%5B/url%5D)  
By this page one can see that this setting is no longer (since 2014) a requirement, neither recommended to be used anymore.

The question is answered by a member of the CoderShip team who develop the Galera Cluster, so I assume it’s safe to assume he’s correct.

Best regards

David