> So was SHOW and BEGIN (and I assume START TRANSACTION) always part of causal_reads? Why SHOW?
As https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1271177/comments/5 (second point there).
But as per https://bugs.launchpad.net/percona-xtradb-cluster/+bug/1271177/comments/4
it is broken for 5.6 - ie. in 5.6 you can do SHOW without blocking even with wsrep_causal_reads=1.
> So was SHOW and BEGIN (and I assume START TRANSACTION) always part of causal_reads? Why SHOW?
As https:/ /bugs.launchpad .net/percona- xtradb- cluster/ +bug/1271177/ comments/ 5 (second point there).
But as per https:/ /bugs.launchpad .net/percona- xtradb- cluster/ +bug/1271177/ comments/ 4
it is broken for 5.6 - ie. in 5.6 you can do SHOW without reads=1.
blocking even with wsrep_causal_