Not the answer you need?
Register and ask your own question!

Deadlock logging not working

domdom EntrantInactive User Role Beginner
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

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.