set autocommit=1;
create database db_1;
create table db_1.t1(
id int primary key auto_increment,
col1 varchar(100),
col2 int
)engine= innodb;
select count(*) from db_1.t1 as of gcn 2048 where id > 0;
count(*)
100
select count(*) from db_1.t1 as of gcn 2048 where id > 0;
count(*)
100
show global status like '%tcn_cache%';
Variable_name	Value
Lizard_block_tcn_cache_hit	0
Lizard_block_tcn_cache_miss	0
Lizard_block_tcn_cache_evict	0
Lizard_session_tcn_cache_hit	0
Lizard_session_tcn_cache_miss	0
Lizard_session_tcn_cache_evict	0
Lizard_global_tcn_cache_hit	200
Lizard_global_tcn_cache_miss	0
Lizard_global_tcn_cache_evict	113
select count(*) from db_1.t1 as of gcn 2048 where id > 0;
count(*)
100
select count(*) from db_1.t1 as of gcn 2048 where id > 0;
count(*)
100
show global status like '%tcn_cache%';
Variable_name	Value
Lizard_block_tcn_cache_hit	0
Lizard_block_tcn_cache_miss	0
Lizard_block_tcn_cache_evict	0
Lizard_session_tcn_cache_hit	0
Lizard_session_tcn_cache_miss	0
Lizard_session_tcn_cache_evict	0
Lizard_global_tcn_cache_hit	400
Lizard_global_tcn_cache_miss	0
Lizard_global_tcn_cache_evict	113
drop table db_1.t1;
drop database db_1;