Debian Codegraph @

mysql-test/suite/ndb_opt/index_stat_restart_auto.result

raw
1 create table t1 (
2 a int primary key,
3 b int,
4 c int,
5 key t1x1 (b),
6 key t1x2 (c)
7 ) engine=ndb
8 partition by key (a) partitions 1;
9 insert into t1 values (1,1,1),(2,1,1),(3,2,1),(4,2,1);
10 Waiting for the index stats to be updated
11 Index stats updated
12 select count(*) from t1 where b = 1;
13 count(*)
14 2
15 select count(*) from t1 where c = 1;
16 count(*)
17 4
18 show status like 'ndb_index_stat_cache%';
19 Variable_name Value
20 Ndb_index_stat_cache_query 81
21 Ndb_index_stat_cache_clean 0
22 # restart cluster --initial
23 # wait for mysqld
24 set global ndb_dbg_check_shares=1;
25 drop table if exists t1;
26 Warnings:
27 Note 1051 Unknown table 'test.t1'
28 create table t1 (
29 a int primary key,
30 b int,
31 c int,
32 key t1x1 (b),
33 key t1x2 (c)
34 ) engine=ndb
35 partition by key (a) partitions 1;
36 insert into t1 values (1,1,1),(2,1,1),(3,2,1),(4,2,1);
37 Waiting for the index stats to be updated
38 Index stats updated
39 select count(*) from t1 where b = 1;
40 count(*)
41 2
42 select count(*) from t1 where c = 1;
43 count(*)
44 4
45 show status like 'ndb_index_stat_cache%';
46 Variable_name Value
47 Ndb_index_stat_cache_query 81
48 Ndb_index_stat_cache_clean 0
49 Check if events were detected in the other MySQL Server as well
50 Waiting for the index stats to be updated
51 Index stats updated
52 select count(*) from t1 where b = 1;
53 count(*)
54 2
55 select count(*) from t1 where c = 1;
56 count(*)
57 4
58 show status like 'ndb_index_stat_cache%';
59 Variable_name Value
60 Ndb_index_stat_cache_query 81
61 Ndb_index_stat_cache_clean 0
62 drop table t1;