1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
|
--source include/have_ndb.inc
#
# Check that session and global status variables returned from
# performance schema are properly prefixed with Ndb_(using that
# exact case) and that the number of global and session status
# variables match
#
# Expected output:
# select * from performance_schema.global_status
# where VARIABLE_NAME LIKE 'Ndb\_%';
# VARIABLE_NAME VARIABLE_VALUE
# Ndb_api_wait_exec_complete_count 2
# Ndb_api_wait_scan_result_count 3
# Ndb_api_wait_meta_request_count 94
# ...
# Count number of global ndb_ status variables(ignoring case)
let $num_global_status_vars =
`select count(*) from performance_schema.global_status
where VARIABLE_NAME LIKE 'Ndb\_%'`;
#echo num_global_status_vars: $num_global_status_vars;
# Count number of global Ndb_ status variables(using case sensitive
# like to find those which start with Ndb_ exactly).
let $num_global_status_vars_case =
`select count(*) from performance_schema.global_status
where VARIABLE_NAME LIKE binary 'Ndb\_%'`;
#echo num_global_status_vars_case: $num_global_status_vars_case;
# Check that all variables have proper prefix Ndb_
if ($num_global_status_vars != $num_global_status_vars_case)
{
die Faulty prefix of some global Ndb_ status variables;
}
# Count number of session ndb_ status variables(ignoring case)
let $num_session_status_vars =
`select count(*) from performance_schema.session_status
where VARIABLE_NAME LIKE 'Ndb\_%'`;
#echo num_session_status_vars: $num_session_status_vars;
# Count number of session Ndb_ status variables(using case sensitive
# like to find those which start with Ndb_ exactly).
let $num_session_status_vars_case =
`select count(*) from performance_schema.session_status
where VARIABLE_NAME LIKE binary 'Ndb\_%'`;
#echo num_session _status_vars_case: $num_session_status_vars_case;
# Check that all variables have proper prefix Ndb_
if ($num_session_status_vars != $num_session_status_vars_case)
{
die Faulty prefix of some session Ndb_ status variables;
}
# Check that the number of status variables match between session and global
if ($num_session_status_vars != $num_global_status_vars)
{
die Difference in number of sesssion and global status variables;
}
# Check that one arbitrary global status variable can be selected
--replace_column 2 <value>
select VARIABLE_NAME, VARIABLE_VALUE
from performance_schema.global_status
where VARIABLE_NAME = 'Ndb_sorted_scan_count';
# Check that one arbitrary session status variable can be selected
--replace_column 2 <value>
select VARIABLE_NAME, VARIABLE_VALUE
from performance_schema.session_status
where VARIABLE_NAME = 'Ndb_config_from_host';
#
# Check that session and global variables returned from
# performance schema are properly prefixed with ndb_(using that
# exact case) and that the number of global and session variables match
#
# Expected output:
# select * from performance_schema.global_variables
# where VARIABLE_NAME LIKE 'ndb\_%';
# VARIABLE_NAME VARIABLE_VALUE
# ndb_allow_copying_alter_table ON
# ndb_autoincrement_prefetch_sz 1
# ...
# Count number of global ndb_ status variables(ignoring case)
let $num_global_variables_vars =
`select count(*) from performance_schema.global_variables
where VARIABLE_NAME LIKE 'ndb\_%'`;
#echo num_global_variables_vars: $num_global_variables_vars;
# Count number of global ndb_ variables(using case sensitive
# like to find those which start with Ndb_ exactly).
let $num_global_variables_vars_case =
`select count(*) from performance_schema.global_variables
where VARIABLE_NAME LIKE binary 'ndb\_%'`;
#echo num_global_variables_vars_case: $num_global_variables_vars_case;
# Check that all variables have proper prefix ndb_
if ($num_global_variables_vars != $num_global_variables_vars_case)
{
die Faulty prefix of some global ndb_ variables;
}
# Count number of session ndb_ status variables(ignoring case)
let $num_session_variables_vars =
`select count(*) from performance_schema.session_variables
where VARIABLE_NAME LIKE 'ndb\_%'`;
#echo num_session_variables_vars: $num_session_variables_vars;
# Count number of session ndb_ variables(using case sensitive
# like to find those which start with ndb_ exactly).
let $num_session_variables_vars_case =
`select count(*) from performance_schema.session_variables
where VARIABLE_NAME LIKE binary 'ndb\_%'`;
#echo num_session _status_vars_case: $num_session_variables_vars_case;
# Check that all variables have proper prefix ndb_
if ($num_session_variables_vars != $num_session_variables_vars_case)
{
die Faulty prefix of some session ndb_ variables;
}
# Check that the number of status variables match between session and global
if ($num_session_variables_vars != $num_global_variables_vars)
{
die Difference in number of sesssion and global variables;
}
# Check that one arbitrary global variable can be selected
--replace_column 2 <value>
select VARIABLE_NAME, VARIABLE_VALUE
from performance_schema.global_variables
where VARIABLE_NAME = 'ndb_version_string';
# Check that one arbitrary status variable can be selected
--replace_column 2 <value>
select VARIABLE_NAME, VARIABLE_VALUE
from performance_schema.session_variables
where VARIABLE_NAME = 'ndb_nodeid';
|
