--source testconf.inc USE test; --disable_warnings drop table if exists t1; --enable_warnings create table t1 (id integer); set autocommit=0; # open transaction begin; insert into t1 values(1); # write to master commit; select count(*) from t1; # read from master since autocommit is disabled drop table t1;