Don't this see anymore with latest PXC-5.6
mysql> mysql> create table a (a int) engine=innodb; Query OK, 0 rows affected (0.05 sec)
mysql> set wsrep_on=0; Query OK, 0 rows affected (0.00 sec)
mysql> insert into a values (2); Query OK, 1 row affected (0.00 sec)
mysql> set wsrep_on=1; Query OK, 0 rows affected (0.00 sec)
mysql> select * from a; +------+ | a | +------+ | 2 | +------+ 1 row in set (0.00 sec)
mysql> delete from a; Query OK, 1 row affected (0.01 sec)
mysql> select * from a; Empty set (0.00 sec)
mysql> insert into a values (2); Query OK, 1 row affected (0.01 sec)
mysql> delete from a where a = 2; Query OK, 1 row affected (0.02 sec)
mysql>
Don't this see anymore with latest PXC-5.6
mysql>
mysql> create table a (a int) engine=innodb;
Query OK, 0 rows affected (0.05 sec)
mysql> set wsrep_on=0;
Query OK, 0 rows affected (0.00 sec)
mysql> insert into a values (2);
Query OK, 1 row affected (0.00 sec)
mysql> set wsrep_on=1;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from a;
+------+
| a |
+------+
| 2 |
+------+
1 row in set (0.00 sec)
mysql> delete from a;
Query OK, 1 row affected (0.01 sec)
mysql> select * from a;
Empty set (0.00 sec)
mysql> set wsrep_on=0;
Query OK, 0 rows affected (0.00 sec)
mysql> insert into a values (2);
Query OK, 1 row affected (0.01 sec)
mysql> set wsrep_on=1;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from a;
+------+
| a |
+------+
| 2 |
+------+
1 row in set (0.00 sec)
mysql> delete from a where a = 2;
Query OK, 1 row affected (0.02 sec)
mysql>