SET SQL_LOG_BIN=0;
create table aaa (id int primary key, i int) engine xengine;
SET GLOBAL xengine_flush_log_at_trx_commit=0;
select variable_value into @a from performance_schema.global_status where variable_name='xengine_wal_synced';
insert aaa(id, i) values(1,1);
select variable_value-@a from performance_schema.global_status where variable_name='xengine_wal_synced';
variable_value-@a
0
insert aaa(id, i) values(2,1);
select variable_value-@a from performance_schema.global_status where variable_name='xengine_wal_synced';
variable_value-@a
0
insert aaa(id, i) values(3,1);
select variable_value-@a from performance_schema.global_status where variable_name='xengine_wal_synced';
variable_value-@a
0
SET GLOBAL xengine_flush_log_at_trx_commit=1;
insert aaa(id, i) values(4,1);
select variable_value-@a from performance_schema.global_status where variable_name='xengine_wal_synced';
variable_value-@a
1
insert aaa(id, i) values(5,1);
select variable_value-@a from performance_schema.global_status where variable_name='xengine_wal_synced';
variable_value-@a
2
insert aaa(id, i) values(6,1);
select variable_value-@a from performance_schema.global_status where variable_name='xengine_wal_synced';
variable_value-@a
3
SET GLOBAL xengine_flush_log_at_trx_commit=0;
insert aaa(id, i) values(7,1);
truncate table aaa;
drop table aaa;
SET GLOBAL xengine_flush_log_at_trx_commit=1;