19 lines
920 B
Plaintext
19 lines
920 B
Plaintext
# TestDropStatsFromKV
|
|
drop table if exists t;
|
|
create table t (c1 varchar(20), c2 varchar(20));
|
|
insert into t values("1","1"),("2","2"),("3","3"),("4","4");
|
|
insert into t select * from t;
|
|
insert into t select * from t;
|
|
analyze table t all columns with 2 topn;
|
|
set @a = (select tidb_table_id from information_schema.tables where table_name = "t" and table_schema = "executor__kv");
|
|
select modify_count, count from mysql.stats_meta where table_id = @a;
|
|
select hist_id from mysql.stats_histograms where table_id = @a;
|
|
select count(*)>0 from mysql.stats_buckets where table_id = @a;
|
|
select count(*)>0 from mysql.stats_top_n where table_id = @a;
|
|
drop stats t;
|
|
select modify_count, count from mysql.stats_meta where table_id = @a;
|
|
select hist_id from mysql.stats_histograms where table_id = @a;
|
|
select hist_id, bucket_id from mysql.stats_buckets where table_id = @a;
|
|
select hist_id from mysql.stats_top_n where table_id = @a;
|
|
|