--source include/galera_cluster.inc --source include/have_innodb.inc # # Ensure that transactions that do not write anything do not cause the wsrep_last_committed counter to advance # # Empty transaction --connection node_1 CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB; --connection node_2 --let $wsrep_last_committed_before = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed'` --connection node_1 SET AUTOCOMMIT=OFF; START TRANSACTION; COMMIT; --connection node_2 --let $wsrep_last_committed_after = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed'` --disable_query_log --eval SELECT $wsrep_last_committed_after = $wsrep_last_committed_before AS wsrep_last_committed_diff; --enable_query_log # START TRANSACTION READ ONLY --connection node_2 --let $wsrep_last_committed_before = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed'` --connection node_1 START TRANSACTION READ ONLY; SELECT COUNT(*) = 0 FROM t1; COMMIT; --connection node_2 --let $wsrep_last_committed_after = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed'` --disable_query_log --eval SELECT $wsrep_last_committed_after = $wsrep_last_committed_before AS wsrep_last_committed_diff; --enable_query_log # Ordinary transaction with only SELECTs --connection node_1 START TRANSACTION; SELECT COUNT(*) = 0 FROM t1; COMMIT; --connection node_2 --let $wsrep_last_committed_after = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed'` --disable_query_log --eval SELECT $wsrep_last_committed_after = $wsrep_last_committed_before AS wsrep_last_committed_diff; --enable_query_log DROP TABLE t1;