Hi, I’m getting deadlocks I guess due to simultaneous writes - this is fine, I understand this is part of running synchronous clustering. But try as I might, I cannot get PXC to log the deadlocks as it should do, so I can start to analyse and resolve them. I’ve added:
innodb_print_all_deadlocks = on
also tried
innodb_print_all_deadlocks = 1
to /etc/my.cnf
But if I try and verify, I get:
mysql -e ‘show global status’ |grep deadlock
Innodb_deadlocks 0
ie. no innodb_print_all_deadlocks variable.
Waddup with that? Is this setting not supported in PXC?
I’m running Percona-XtraDB-Cluster-server-56-5.6.26-25.12.1.el7.x86_64