88 lines
2.2 KiB
Plaintext
88 lines
2.2 KiB
Plaintext
DROP TABLE IF EXISTS t1;
|
|
set @is_enable_default = @@global.ndb_index_stat_enable;
|
|
set @is_enable = 1;
|
|
set @is_enable = NULL;
|
|
# is_enable_on=0 is_enable_off=0
|
|
# ndb_index_stat_enable - before
|
|
show global variables like 'ndb_index_stat_enable';
|
|
Variable_name Value
|
|
ndb_index_stat_enable ON
|
|
show local variables like 'ndb_index_stat_enable';
|
|
Variable_name Value
|
|
ndb_index_stat_enable ON
|
|
# ndb_index_stat_enable - after
|
|
show global variables like 'ndb_index_stat_enable';
|
|
Variable_name Value
|
|
ndb_index_stat_enable ON
|
|
show local variables like 'ndb_index_stat_enable';
|
|
Variable_name Value
|
|
ndb_index_stat_enable ON
|
|
create table t1 (
|
|
a int primary key,
|
|
b int,
|
|
c int,
|
|
key t1x1 (b),
|
|
key t1x2 (c)
|
|
) engine=ndb
|
|
partition by key (a) partitions 1;
|
|
insert into t1 values (1,1,1),(2,1,1),(3,2,1),(4,2,1);
|
|
analyze table t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 analyze status OK
|
|
select count(*) from t1 where b = 1;
|
|
count(*)
|
|
2
|
|
select count(*) from t1 where c = 1;
|
|
count(*)
|
|
4
|
|
show status like 'ndb_index_stat_cache%';
|
|
Variable_name Value
|
|
Ndb_index_stat_cache_query 81
|
|
Ndb_index_stat_cache_clean 0
|
|
# restart cluster --initial
|
|
# wait for mysqld
|
|
set global ndb_dbg_check_shares=1;
|
|
drop table if exists t1;
|
|
Warnings:
|
|
Note 1051 Unknown table 'test.t1'
|
|
create table t1 (
|
|
a int primary key,
|
|
b int,
|
|
c int,
|
|
key t1x1 (b),
|
|
key t1x2 (c)
|
|
) engine=ndb
|
|
partition by key (a) partitions 1;
|
|
insert into t1 values (1,1,1),(2,1,1),(3,2,1),(4,2,1);
|
|
analyze table t1;
|
|
Table Op Msg_type Msg_text
|
|
test.t1 analyze status OK
|
|
select count(*) from t1 where b = 1;
|
|
count(*)
|
|
2
|
|
select count(*) from t1 where c = 1;
|
|
count(*)
|
|
4
|
|
show status like 'ndb_index_stat_cache%';
|
|
Variable_name Value
|
|
Ndb_index_stat_cache_query 81
|
|
Ndb_index_stat_cache_clean 0
|
|
drop table t1;
|
|
set @is_enable = @is_enable_default;
|
|
set @is_enable = NULL;
|
|
# is_enable_on=0 is_enable_off=0
|
|
# ndb_index_stat_enable - before
|
|
show global variables like 'ndb_index_stat_enable';
|
|
Variable_name Value
|
|
ndb_index_stat_enable ON
|
|
show local variables like 'ndb_index_stat_enable';
|
|
Variable_name Value
|
|
ndb_index_stat_enable ON
|
|
# ndb_index_stat_enable - after
|
|
show global variables like 'ndb_index_stat_enable';
|
|
Variable_name Value
|
|
ndb_index_stat_enable ON
|
|
show local variables like 'ndb_index_stat_enable';
|
|
Variable_name Value
|
|
ndb_index_stat_enable ON
|