40 lines
879 B
Plaintext
40 lines
879 B
Plaintext
--source include/have_binlog_format_row.inc
|
|
connect(conn1, localhost, root,,);
|
|
|
|
connection conn1;
|
|
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;
|
|
|
|
|
|
--disable_query_log
|
|
let $loop=100;
|
|
while($loop)
|
|
{
|
|
eval insert into db_1.t1(col1, col2) values(concat('test', $loop), $loop);
|
|
dec $loop;
|
|
}
|
|
--enable_query_log
|
|
|
|
select count(*) from db_1.t1 as of gcn 2048 where id > 0;
|
|
select count(*) from db_1.t1 as of gcn 2048 where id > 0;
|
|
show global status like '%tcn_cache%';
|
|
|
|
|
|
disconnect conn1;
|
|
|
|
connect(conn2, localhost, root,,);
|
|
connection conn2;
|
|
select count(*) from db_1.t1 as of gcn 2048 where id > 0;
|
|
select count(*) from db_1.t1 as of gcn 2048 where id > 0;
|
|
show global status like '%tcn_cache%';
|
|
|
|
drop table db_1.t1;
|
|
drop database db_1;
|
|
disconnect conn2;
|