1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
# test that flush global status; clears global status;
flush global status;
use test;
--disable_warnings
drop table if exists t1;
--enable_warnings
create table t1 (a int);
insert into t1 values (1),(2),(3);
select * from t1;
select * from t1;
select * from t1;
show global status like 'Handler%';
connect (con1,localhost,root,,);
connection con1;
use test;
select * from t1;
select * from t1;
select * from t1;
show global status like 'Handler%';
flush global status;
# should show reset counters;
show global status like 'Handler%';
|