set global consensus_log_cache_size = 20 * 1024 * 1024; # 20M use test; create table t1 (data longblob); --disable_query_log let $counter= 20; while ($counter) { insert into t1 values (repeat('a', 2*1024*1024)); dec $counter; } --enable_query_log set global consensus_log_cache_size = 1; # at least one log --disable_query_log let $counter= 10; while ($counter) { insert into t1 values (repeat('a', 1024)); dec $counter; } --enable_query_log --sleep 1 # wait cleaner show global status like "consensus_fifo_cache%"; set global consensus_log_cache_size = 1024*1024*1024; # 1G # in debug mode, reserve_list_size is 1024 --disable_query_log let $counter= 1025; while ($counter) { insert into t1 values ('a'); dec $counter; } --enable_query_log --sleep 1 # wait cleaner show global status like "consensus_fifo_cache%"; # check replicate log success --sleep 5 select count(distinct(match_index)) from information_schema.alisql_cluster_global; drop table t1; set global consensus_log_cache_size = 64 * 1024 * 1024; # 64M