Debian Codegraph @

mysql-test/suite/ndb_opt/index_stat_enable.inc

raw
1 # turn ndb_index_stat_enable ON or OFF
2 # caller sets @is_enable 0/1
3 # based on global variable, local follows global
4 # do nothing if value is already correct
5
6 let is_enable_on = `select @is_enable and not @@global.ndb_index_stat_enable`;
7 let is_enable_off = `select not @is_enable and @@global.ndb_index_stat_enable`;
8 set @is_enable = NULL;
9
10 --echo # is_enable_on=$is_enable_on is_enable_off=$is_enable_off
11
12 --echo # ndb_index_stat_enable - before
13 show global variables like 'ndb_index_stat_enable';
14 show local variables like 'ndb_index_stat_enable';
15
16 if ($is_enable_on)
17 {
18 # first global
19 eval set @@global.ndb_index_stat_enable = 1;
20 eval set @@local.ndb_index_stat_enable = 1;
21
22 # stats thread creates stats tables in NDB
23 }
24
25 if ($is_enable_off)
26 {
27 # first local
28 eval set @@local.ndb_index_stat_enable = 0;
29 eval set @@global.ndb_index_stat_enable = 0;
30 }
31
32 --echo # ndb_index_stat_enable - after
33 show global variables like 'ndb_index_stat_enable';
34 show local variables like 'ndb_index_stat_enable';
35
36 # wait for stats thread to notice any change
37 source suite/ndb/include/ndb_index_stat_wait.inc;