flush status; create table t1 (a int); insert into t1 (a) values (1); create table t2 (b int); insert into t2 (b) values (2); select * from t1; a 1 show status like 'Opened_views'; Variable_name Value Opened_views 1 flush status; select * from t2; b 2 show status like 'Opened_views'; Variable_name Value Opened_views 0 drop table t1, t2;