Debian Codegraph @

mysql-test/suite/perfschema/t/show_sanity.test

raw
1 ################# suite/perfschema/t/show_sanity.test ##########################
2 # #
3 # Compare global/session status and system variables in the Information Schema #
4 # to those in Performance Schema. Do this once with SHOW_COMPATIBILITY_56 = ON #
5 # again with SHOW_COMPATIBILITY_56 = OFF. #
6 # #
7 # Status and system variables may have a scope of: #
8 # #
9 # GLOBAL - System level only. #
10 # SESSION - Applies at both the global and session level. #
11 # Status variables with SESSION scope are totaled across all #
12 # threads for global queries such as SHOW GLOBAL STATUS. #
13 # System variables with SESSION scope have a global default #
14 # that can be changed at the session level. #
15 # SESSION-ONLY - Client connection level only. #
16 # #
17 #==============================================================================#
18 # This test consists of two phases: #
19 # #
20 # COLLECTION - Gather results from SHOW commands and SELECTs on the I_S/P_S #
21 # tables into a single table. Tag each variable with the source (SHOW, SELECT, #
22 # P_S, I_S) and compatibility mode setting (OFF, ON). #
23 # #
24 # VERIFICATION - Compare and cross-reference the results between and across #
25 # sources and compatibility modes, factoring in the known variances. #
26 # #
27 # The verification phase assumes that there will be no variation between the #
28 # 5.6 and 5.7 results as long as known discrepancies in scope handling are #
29 # accounted for. Expected variations are tagged as "JUNK" and filtered from #
30 # the comparisons. #
31 # #
32 # The expected scope for each variable was initially determined from the MySQL #
33 # system and status variable documentation and then further verified by the #
34 # actual implementation. #
35 # #
36 # The difference between how 5.6 and 5.7 manage query scope vs. variable scope #
37 # are summarized as follows: #
38 # #
39 # *** SHOW_COMPATIBILITY_56 = ON *** #
40 # #
41 # SHOW GLOBAL STATUS / I_S.GLOBAL_STATUS #
42 # GLOBAL - Yes #
43 # SESSION - Yes, totaled across all threads #
44 # SESSION-ONLY - Yes, current session #
45 # #
46 # SHOW SESSION STATUS / I_S.SESSION_STATUS #
47 # GLOBAL - Yes #
48 # SESSION - Yes, current session #
49 # SESSION-ONLY - Yes #
50 # #
51 # SHOW GLOBAL VARIABLES / I_S.GLOBAL_VARIABLES #
52 # GLOBAL - Yes #
53 # SESSION - Yes #
54 # SESSION-ONLY - No #
55 # #
56 # SHOW SESSION VARIABLES / I_S.SESSION_VARIABLES #
57 # GLOBAL - Yes #
58 # SESSION - Yes, current session #
59 # SESSION-ONLY - Yes #
60 # #
61 # *** SHOW_COMPATIBILITY_56 = OFF *** #
62 # #
63 # Information Schema status and system tables are disabled #
64 # (ER_FEATURE_DISABLED_SEE_DOC). #
65 # #
66 # SHOW GLOBAL STATUS / P_S.GLOBAL_STATUS #
67 # GLOBAL - Yes #
68 # SESSION - Yes (totaled across all threads for SHOW STATUS) #
69 # SESSION-ONLY - No #
70 # #
71 # SHOW SESSION STATUS / P_S.SESSION_STATUS, STATUS_BY_THREAD #
72 # GLOBAL - No #
73 # SESSION - Yes #
74 # SESSION-ONLY - Yes #
75 # #
76 # P_S.STATUS_BY_USER / HOST / ACCOUNT #
77 # GLOBAL - No #
78 # SESSION - Yes (totaled across all related threads) #
79 # SESSION-ONLY - No #
80 # #
81 # SHOW GLOBAL VARIABLES / P_S.GLOBAL_VARIABLES #
82 # GLOBAL - Yes #
83 # SESSION - No #
84 # SESSION-ONLY - No #
85 # #
86 # SHOW SESSION VARIABLES / P_S.SESSION_VARIABLES, VARIABLES_BY_THREAD #
87 # GLOBAL - No #
88 # SESSION - Yes #
89 # SESSION-ONLY - Yes #
90 # #
91 # In addition to the differences in how variable scope is handled, comparisons #
92 # between 5.6 and 5.7 must also account for differences in how variables are #
93 # represented based upon the variable type or meaning. For example, #
94 # SESSION-ONLY variables such as "Last Query Cost" have no meaning when #
95 # aggregated by user, account or host. #
96 # #
97 # These additional differences are summarized as follows: #
98 # #
99 # I_S.GLOBAL_STATUS vs. P_S.GLOBAL_STATUS #
100 # - Remove SESSION-ONLY #
101 # - Remove SLAVE-ONLY #
102 # #
103 # I_S.SESSION_STATUS vs. P_S.SESSION_STATUS #
104 # - Remove GLOBAL-only vars #
105 # - Remove SLAVE-ONLY #
106 # #
107 # P_S.SESSION_STATUS vs. P_S.STATUS_BY_USER/HOST/ACCOUNT #
108 # - Remove SESSION-ONLY #
109 # - Remove non-aggregatable #
110 # #
111 ################################################################################
112 --source include/have_perfschema.inc
113 --source include/not_embedded.inc
114 --source include/no_protocol.inc
115
116 create table test.sanity(
117 `SHOW_MODE` varchar(48) NOT NULL,
118 `SOURCE` varchar(64) NOT NULL,
119 `VARIABLE_NAME` varchar(64) NOT NULL);
120
121 select thread_id from performance_schema.threads
122 where processlist_id = connection_id()
123 into @my_tid;
124
125 select @@global.show_compatibility_56 into @show_compatibility_56_save;
126
127 set @my_user='root';
128 set @my_host='localhost';
129
130 # Debug
131 # select connection_id(), @my_tid, @my_user, @my_host;
132 # show plugins
133 --echo #
134 --echo # ================================================================================
135 --echo # SHOW_COMPATIBILITY_56 = ON
136 --echo # ================================================================================
137 set global show_compatibility_56 = on;
138
139 --echo #
140 --echo # STEP 1-1
141 insert into test.sanity
142 select "5.6", "I_S.GLOBAL_VARIABLES", variable_name
143 from information_schema.global_variables;
144
145 --echo #
146 --echo # STEP 1-2
147 insert into test.sanity
148 select "5.6", "I_S.SESSION_VARIABLES", variable_name
149 from information_schema.session_variables;
150
151 --echo #
152 --echo # STEP 1-3
153 insert into test.sanity
154 select "5.6", "P_S.GLOBAL_VARIABLES", variable_name
155 from performance_schema.global_variables;
156
157 --echo #
158 --echo # STEP 1-4
159 insert into test.sanity
160 select "5.6", "P_S.VARIABLES_BY_THREAD", variable_name
161 from performance_schema.variables_by_thread
162 where thread_id = @my_tid;
163
164 --echo #
165 --echo # STEP 1-5
166 insert into test.sanity
167 select "5.6", "P_S.SESSION_VARIABLES", variable_name
168 from performance_schema.session_variables;
169
170 --echo #
171 --echo # STEP 1-6
172 insert into test.sanity
173 select "5.6", "I_S.GLOBAL_STATUS", variable_name
174 from information_schema.global_status;
175
176 --echo #
177 --echo # STEP 1-7
178 insert into test.sanity
179 select "5.6", "I_S.SESSION_STATUS", variable_name
180 from information_schema.session_status;
181
182 --echo #
183 --echo # STEP 1-8
184 insert into test.sanity
185 select "5.6", "P_S.GLOBAL_STATUS", variable_name
186 from performance_schema.global_status;
187
188 --echo #
189 --echo # STEP 1-9
190 --echo # EMPTY, NO WARNINGS (not available in 5.6 mode)
191 select *
192 from performance_schema.status_by_thread;
193
194 --echo #
195 --echo # STEP 1-10
196 insert into test.sanity
197 select "5.6", "P_S.SESSION_STATUS", variable_name
198 from performance_schema.session_status;
199
200 --echo #
201 --echo # STEP 1-11
202 --echo # EMPTY, NO WARNINGS (not available in 5.6 mode)
203 select *
204 from performance_schema.status_by_account;
205
206 --echo #
207 --echo # STEP 1-12
208 --echo # EMPTY, NO WARNINGS (not available in 5.6 mode)
209 select *
210 from performance_schema.status_by_user;
211
212 --echo #
213 --echo # STEP 1-13
214 --echo # EMPTY, NO WARNINGS (not available in 5.6 mode)
215 select *
216 from performance_schema.status_by_host;
217
218 --echo #
219 --echo # ================================================================================
220 --echo # SHOW_COMPATIBILITY_56 = OFF
221 --echo # ================================================================================
222 set global show_compatibility_56 = off;
223
224 --echo #
225 --echo # STEP 2-1
226 --echo # FAILS WITH ERROR
227 --error ER_FEATURE_DISABLED_SEE_DOC
228 select *
229 from information_schema.global_variables;
230
231 --echo #
232 --echo # STEP 2-2
233 --echo # FAILS WITH ERROR
234 --error ER_FEATURE_DISABLED_SEE_DOC
235 select *
236 from information_schema.session_variables;
237
238 --echo #
239 --echo # STEP 2-3
240 insert into test.sanity
241 select "5.7", "P_S.GLOBAL_VARIABLES", variable_name
242 from performance_schema.global_variables;
243
244 --echo #
245 --echo # STEP 2-4
246 insert into test.sanity
247 select "5.7", "P_S.VARIABLES_BY_THREAD", variable_name
248 from performance_schema.variables_by_thread
249 where thread_id = @my_tid;
250
251 --echo #
252 --echo # STEP 2-5
253 insert into test.sanity
254 select "5.7", "P_S.SESSION_VARIABLES", variable_name
255 from performance_schema.session_variables;
256
257 --echo #
258 --echo # STEP 2-6
259 --echo # FAILS WITH ERROR
260 --error ER_FEATURE_DISABLED_SEE_DOC
261 select *
262 from information_schema.global_status;
263
264 --echo #
265 --echo # STEP 2-7
266 --echo # FAILS WITH ERROR
267 --error ER_FEATURE_DISABLED_SEE_DOC
268 select *
269 from information_schema.session_status;
270
271 --echo #
272 --echo # STEP 2-8
273 insert into test.sanity
274 select "5.7", "P_S.GLOBAL_STATUS", variable_name
275 from performance_schema.global_status;
276
277 --echo #
278 --echo # STEP 2-9
279 insert into test.sanity
280 select "5.7", "P_S.STATUS_BY_THREAD", variable_name
281 from performance_schema.status_by_thread
282 where thread_id = @my_tid;
283
284 --echo #
285 --echo # STEP 2-10
286 insert into test.sanity
287 select "5.7", "P_S.SESSION_STATUS", variable_name
288 from performance_schema.session_status;
289
290 --echo #
291 --echo # STEP 2-11
292 insert into test.sanity
293 select "5.7", "P_S.STATUS_BY_ACCOUNT", variable_name
294 from performance_schema.status_by_account
295 where `user` = @my_user and `host` = @my_host;
296
297 --echo #
298 --echo # STEP 2-12
299 insert into test.sanity
300 select "5.7", "P_S.STATUS_BY_USER", variable_name
301 from performance_schema.status_by_user
302 where `user` = @my_user;
303
304 --echo #
305 --echo # STEP 2-13
306 insert into test.sanity
307 select "5.7", "P_S.STATUS_BY_HOST", variable_name
308 from performance_schema.status_by_host
309 where `host` = @my_host;
310
311 --echo #
312 --echo # STEP 2-14
313 --echo # Known global variables in 5.6 that should not display in session queries.
314 --echo # These should be global-only system variables.
315 --disable_query_log
316 insert into test.sanity values
317 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "AUTO_GENERATE_CERTS"),
318 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "AUTOMATIC_SP_PRIVILEGES"),
319 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "AVOID_TEMPORAL_UPGRADE"),
320 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "BACK_LOG"),
321 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "BASEDIR"),
322 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "BIND_ADDRESS"),
323 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "BINLOGGING_IMPOSSIBLE_MODE"),
324 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "BINLOG_CACHE_SIZE"),
325 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "BINLOG_CHECKSUM"),
326 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "BINLOG_ERROR_ACTION"),
327 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "BINLOG_GROUP_COMMIT_SYNC_DELAY"),
328 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "BINLOG_GROUP_COMMIT_SYNC_NO_DELAY_COUNT"),
329 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "BINLOG_GTID_SIMPLE_RECOVERY"),
330 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "BINLOG_MAX_FLUSH_QUEUE_TIME"),
331 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "BINLOG_ORDER_COMMITS"),
332 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "BINLOG_STMT_CACHE_SIZE"),
333 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "CHARACTER_SETS_DIR"),
334 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "CHARACTER_SET_SYSTEM"),
335 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "CHECK_PROXY_USERS"),
336 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "CONCURRENT_INSERT"),
337 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "CONNECT_TIMEOUT"),
338 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "CORE_FILE"),
339 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "DATADIR"),
340 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "DATETIME_FORMAT"),
341 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "DATE_FORMAT"),
342 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "DEFAULT_AUTHENTICATION_PLUGIN"),
343 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "DEFAULT_PASSWORD_LIFETIME"),
344 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "DELAYED_INSERT_LIMIT"),
345 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "DELAYED_INSERT_TIMEOUT"),
346 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "DELAYED_QUEUE_SIZE"),
347 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "DELAY_KEY_WRITE"),
348 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "DISABLED_STORAGE_ENGINES"),
349 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "DISCONNECT_ON_EXPIRED_PASSWORD"),
350 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "ENFORCE_GTID_CONSISTENCY"),
351 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "EVENT_SCHEDULER"),
352 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "EXECUTED_GTIDS_COMPRESSION_PERIOD"),
353 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "EXPIRE_LOGS_DAYS"),
354 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "FLUSH"),
355 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "FLUSH_TIME"),
356 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "FT_BOOLEAN_SYNTAX"),
357 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "FT_MAX_WORD_LEN"),
358 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "FT_MIN_WORD_LEN"),
359 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "FT_QUERY_EXPANSION_LIMIT"),
360 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "FT_STOPWORD_FILE"),
361 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "GENERAL_LOG"),
362 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "GENERAL_LOG_FILE"),
363 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "GTID_EXECUTED_COMPRESSION_PERIOD"),
364 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "GTID_MODE"),
365 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "GTID_PURGED"),
366 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "HAVE_COMPRESS"),
367 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "HAVE_CRYPT"),
368 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "HAVE_DYNAMIC_LOADING"),
369 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "HAVE_GEOMETRY"),
370 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "HAVE_OPENSSL"),
371 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "HAVE_PROFILING"),
372 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "HAVE_QUERY_CACHE"),
373 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "HAVE_RTREE_KEYS"),
374 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "HAVE_SSL"),
375 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "HAVE_STATEMENT_TIMEOUT"),
376 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "HAVE_SYMLINK"),
377 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "HOSTNAME"),
378 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "HOST_CACHE_SIZE"),
379 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "IGNORE_BUILTIN_INNODB"),
380 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "IGNORE_DB_DIRS"),
381 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INIT_CONNECT"),
382 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INIT_FILE"),
383 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INIT_SLAVE"),
384 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_ADAPTIVE_FLUSHING"),
385 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_ADAPTIVE_FLUSHING_LWM"),
386 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_FLUSH_SYNC"),
387 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_ADAPTIVE_HASH_INDEX"),
388 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_ADAPTIVE_HASH_INDEX_PARTS"),
389 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_AUTOEXTEND_INCREMENT"),
390 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_AUTOINC_LOCK_MODE"),
391 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_BACKGROUND_DROP_LIST_EMPTY"),
392 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_BUFFER_POOL_CHUNK_SIZE"),
393 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_BUFFER_POOL_DUMP_AT_SHUTDOWN"),
394 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_BUFFER_POOL_DUMP_NOW"),
395 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_BUFFER_POOL_DUMP_PCT"),
396 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_BUFFER_POOL_EVICT"),
397 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_BUFFER_POOL_FILENAME"),
398 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_BUFFER_POOL_LOAD_ABORT"),
399 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_BUFFER_POOL_LOAD_AT_STARTUP"),
400 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_BUFFER_POOL_LOAD_NOW"),
401 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_BUFFER_POOL_SIZE"),
402 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_BUF_FLUSH_LIST_NOW"),
403 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_CHECKSUM_ALGORITHM"),
404 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_CMP_PER_INDEX_ENABLED"),
405 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_COMPRESS_DEBUG"),
406 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_COMPRESSION_FAILURE_THRESHOLD_PCT"),
407 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_COMPRESSION_LEVEL"),
408 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_COMPRESSION_PAD_PCT_MAX"),
409 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_DATA_FILE_PATH"),
410 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_DATA_HOME_DIR"),
411 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_DEFAULT_ROW_FORMAT"),
412 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_DISABLE_BACKGROUND_MERGE"),
413 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_DISABLE_SORT_FILE_CACHE"),
414 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_DOUBLEWRITE"),
415 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_FAST_SHUTDOWN"),
416 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_FILE_PER_TABLE"),
417 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_FILL_FACTOR"),
418 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_FIL_MAKE_PAGE_DIRTY_DEBUG"),
419 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_FLUSHING_AVG_LOOPS"),
420 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_FLUSH_LOG_AT_TIMEOUT"),
421 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_FLUSH_LOG_AT_TRX_COMMIT"),
422 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_FLUSH_METHOD"),
423 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_FLUSH_NEIGHBORS"),
424 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_FORCE_LOAD_CORRUPTED"),
425 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_FORCE_RECOVERY"),
426 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_FT_AUX_TABLE"),
427 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_FT_CACHE_SIZE"),
428 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_FT_ENABLE_DIAG_PRINT"),
429 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_FT_MAX_TOKEN_SIZE"),
430 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_FT_MIN_TOKEN_SIZE"),
431 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_FT_NUM_WORD_OPTIMIZE"),
432 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_FT_RESULT_CACHE_LIMIT"),
433 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_FT_SERVER_STOPWORD_TABLE"),
434 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_FT_SORT_PLL_DEGREE"),
435 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_FT_TOTAL_CACHE_SIZE"),
436 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_IO_CAPACITY"),
437 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_IO_CAPACITY_MAX"),
438 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_LARGE_PREFIX"),
439 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_LIMIT_OPTIMISTIC_INSERT_DEBUG"),
440 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_LOCKS_UNSAFE_FOR_BINLOG"),
441 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_LOG_BUFFER_SIZE"),
442 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_LOG_CHECKPOINT_NOW"),
443 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_LOG_FILE_SIZE"),
444 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_LOG_GROUP_HOME_DIR"),
445 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_LOG_WRITE_AHEAD_SIZE"),
446 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_LRU_SCAN_DEPTH"),
447 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_MAX_DIRTY_PAGES_PCT"),
448 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_MAX_DIRTY_PAGES_PCT_LWM"),
449 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_MAX_PURGE_LAG"),
450 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_MAX_PURGE_LAG_DELAY"),
451 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_MAX_UNDO_LOG_SIZE"),
452 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_MERGE_THRESHOLD_SET_ALL_DEBUG"),
453 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_MONITOR_DISABLE"),
454 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_MONITOR_ENABLE"),
455 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_MONITOR_RESET"),
456 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_MONITOR_RESET_ALL"),
457 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_NUMA_INTERLEAVE"),
458 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_OLD_BLOCKS_PCT"),
459 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_OLD_BLOCKS_TIME"),
460 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_ONLINE_ALTER_LOG_MAX_SIZE"),
461 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_OPEN_FILES"),
462 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_OPTIMIZE_FULLTEXT_ONLY"),
463 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_PAGE_SIZE"),
464 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_PRINT_ALL_DEADLOCKS"),
465 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_PURGE_BATCH_SIZE"),
466 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_PURGE_RSEG_TRUNCATE_FREQUENCY"),
467 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_PURGE_THREADS"),
468 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_RANDOM_READ_AHEAD"),
469 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_READ_AHEAD_THRESHOLD"),
470 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_READ_IO_THREADS"),
471 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_READ_ONLY"),
472 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_ROLLBACK_ON_TIMEOUT"),
473 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_ROLLBACK_SEGMENTS"),
474 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_SAVED_PAGE_NUMBER_DEBUG"),
475 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_SEMAPHORE_WAIT_TIMEOUT_DEBUG"),
476 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_SORT_BUFFER_SIZE"),
477 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_SPIN_WAIT_DELAY"),
478 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_STATS_AUTO_RECALC"),
479 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_STATS_METHOD"),
480 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_STATS_ON_METADATA"),
481 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_STATS_PERSISTENT"),
482 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_STATS_PERSISTENT_SAMPLE_PAGES"),
483 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_STATS_SAMPLE_PAGES"),
484 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_STATS_TRANSIENT_SAMPLE_PAGES"),
485 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_STATUS_OUTPUT"),
486 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_STATUS_OUTPUT_LOCKS"),
487 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_SYNC_ARRAY_SIZE"),
488 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_SYNC_SPIN_LOOPS"),
489 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_TEMP_DATA_FILE_PATH"),
490 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_TRX_PURGE_VIEW_UPDATE_ONLY_DEBUG"),
491 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_UNDO_DIRECTORY"),
492 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_UNDO_LOG_TRUNCATE"),
493 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_UNDO_TABLESPACES"),
494 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_USE_NATIVE_AIO"),
495 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INNODB_WRITE_IO_THREADS"),
496 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "INTERNAL_TMP_DISK_STORAGE_ENGINE"),
497 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "KEY_BUFFER_SIZE"),
498 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "KEY_CACHE_AGE_THRESHOLD"),
499 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "KEY_CACHE_BLOCK_SIZE"),
500 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "KEY_CACHE_DIVISION_LIMIT"),
501 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "LARGE_FILES_SUPPORT"),
502 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "LARGE_PAGES"),
503 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "LARGE_PAGE_SIZE"),
504 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "LC_MESSAGES_DIR"),
505 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "LICENSE"),
506 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "LOCAL_INFILE"),
507 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "LOCKED_IN_MEMORY"),
508 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "LOG_BIN"),
509 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "LOG_BIN_BASENAME"),
510 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "LOG_BIN_INDEX"),
511 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "LOG_BIN_TRUST_FUNCTION_CREATORS"),
512 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "LOG_BIN_USE_V1_ROW_EVENTS"),
513 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "LOG_BUILTIN_AS_IDENTIFIED_BY_PASSWORD"),
514 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "LOG_ERROR"),
515 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "LOG_ERROR_VERBOSITY"),
516 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "LOG_OUTPUT"),
517 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "LOG_QUERIES_NOT_USING_INDEXES"),
518 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "LOG_SLAVE_UPDATES"),
519 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "LOG_SLOW_ADMIN_STATEMENTS"),
520 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "LOG_SLOW_SLAVE_STATEMENTS"),
521 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "LOG_SYSLOG"),
522 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "LOG_SYSLOG_FACILITY"),
523 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "LOG_SYSLOG_INCLUDE_PID"),
524 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "LOG_SYSLOG_TAG"),
525 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "LOG_THROTTLE_QUERIES_NOT_USING_INDEXES"),
526 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "LOG_TIMESTAMPS"),
527 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "LOG_WARNINGS"),
528 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "LOWER_CASE_FILE_SYSTEM"),
529 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "LOWER_CASE_TABLE_NAMES"),
530 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "MASTER_INFO_REPOSITORY"),
531 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "MASTER_VERIFY_CHECKSUM"),
532 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "MAX_BINLOG_CACHE_SIZE"),
533 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "MAX_BINLOG_SIZE"),
534 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "MAX_BINLOG_STMT_CACHE_SIZE"),
535 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "MAX_BINLOG_TOTAL_SIZE"),
536 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "MAX_CONNECTIONS"),
537 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "MAX_CONNECT_ERRORS"),
538 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "MAX_DIGEST_LENGTH"),
539 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "MAX_PREPARED_STMT_COUNT"),
540 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "MAX_RELAY_LOG_SIZE"),
541 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "MAX_WRITE_LOCK_COUNT"),
542 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "METADATA_LOCKS_CACHE_SIZE"),
543 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "METADATA_LOCKS_HASH_INSTANCES"),
544 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "MYISAM_DATA_POINTER_SIZE"),
545 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "MYISAM_MAX_SORT_FILE_SIZE"),
546 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "MYISAM_MMAP_SIZE"),
547 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "MYISAM_RECOVER_OPTIONS"),
548 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "MYISAM_USE_MMAP"),
549 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "MYSQL_NATIVE_PASSWORD_PROXY_USERS"),
550 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "NAMED_PIPE"),
551 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "NAMED_PIPE_FULL_ACCESS_GROUP"),
552 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "NDBINFO_DATABASE"),
553 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "NDBINFO_OFFLINE"),
554 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "NDBINFO_TABLE_PREFIX"),
555 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "NDBINFO_VERSION"),
556 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "NGRAM_TOKEN_SIZE"),
557 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "OFFLINE_MODE"),
558 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "OLD"),
559 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "OPEN_FILES_LIMIT"),
560 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA"),
561 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_ACCOUNTS_SIZE"),
562 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_DIGESTS_SIZE"),
563 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_LONG_SIZE"),
564 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_SIZE"),
565 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_LONG_SIZE"),
566 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_SIZE"),
567 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_EVENTS_TRANSACTIONS_HISTORY_LONG_SIZE"),
568 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_EVENTS_TRANSACTIONS_HISTORY_SIZE"),
569 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE"),
570 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE"),
571 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_HOSTS_SIZE"),
572 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_MAX_COND_CLASSES"),
573 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_MAX_COND_INSTANCES"),
574 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_MAX_DIGEST_LENGTH"),
575 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_MAX_FILE_CLASSES"),
576 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_MAX_FILE_HANDLES"),
577 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES"),
578 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_MAX_INDEX_STAT"),
579 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_MAX_MEMORY_CLASSES"),
580 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_MAX_METADATA_LOCKS"),
581 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_MAX_MUTEX_CLASSES"),
582 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES"),
583 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_MAX_PREPARED_STATEMENTS_INSTANCES"),
584 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_MAX_PROGRAM_INSTANCES"),
585 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_MAX_RWLOCK_CLASSES"),
586 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES"),
587 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_MAX_SOCKET_CLASSES"),
588 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_MAX_SOCKET_INSTANCES"),
589 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_MAX_SQL_TEXT_LENGTH"),
590 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_MAX_STAGE_CLASSES"),
591 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_MAX_STATEMENT_CLASSES"),
592 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_MAX_STATEMENT_STACK"),
593 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_MAX_TABLE_HANDLES"),
594 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES"),
595 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_MAX_TABLE_LOCK_STAT"),
596 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_MAX_THREAD_CLASSES"),
597 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES"),
598 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_SESSION_CONNECT_ATTRS_SIZE"),
599 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_SETUP_ACTORS_SIZE"),
600 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_SETUP_OBJECTS_SIZE"),
601 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PERFORMANCE_SCHEMA_USERS_SIZE"),
602 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PID_FILE"),
603 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PLUGIN_DIR"),
604 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PORT"),
605 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "PROTOCOL_VERSION"),
606 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "QUERY_CACHE_LIMIT"),
607 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "QUERY_CACHE_MIN_RES_UNIT"),
608 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "QUERY_CACHE_SIZE"),
609 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "READ_ONLY"),
610 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "RELAY_LOG"),
611 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "RELAY_LOG_BASENAME"),
612 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "RELAY_LOG_INDEX"),
613 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "RELAY_LOG_INFO_FILE"),
614 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "RELAY_LOG_INFO_REPOSITORY"),
615 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "RELAY_LOG_PURGE"),
616 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "RELAY_LOG_RECOVERY"),
617 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "RELAY_LOG_SPACE_LIMIT"),
618 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "REPORT_HOST"),
619 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "REPORT_PASSWORD"),
620 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "REPORT_PORT"),
621 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "REPORT_USER"),
622 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "RPL_STOP_SLAVE_TIMEOUT"),
623 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SECURE_AUTH"),
624 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SECURE_FILE_PRIV"),
625 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SERVER_ID"),
626 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SERVER_ID_BITS"),
627 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SERVER_UUID"),
628 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SHA256_PASSWORD_AUTO_GENERATE_RSA_KEYS"),
629 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SHA256_PASSWORD_PRIVATE_KEY_PATH"),
630 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SHA256_PASSWORD_PUBLIC_KEY_PATH"),
631 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SHARED_MEMORY"),
632 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SHARED_MEMORY_BASE_NAME"),
633 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SHA256_PASSWORD_PROXY_USERS"),
634 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SHOW_COMPATIBILITY_56"),
635 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SIMPLIFIED_BINLOG_GTID_RECOVERY"),
636 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SKIP_EXTERNAL_LOCKING"),
637 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SKIP_NAME_RESOLVE"),
638 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SKIP_NETWORKING"),
639 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SKIP_SHOW_DATABASE"),
640 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SLAVE_ALLOW_BATCHING"),
641 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SLAVE_CHECKPOINT_GROUP"),
642 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SLAVE_CHECKPOINT_PERIOD"),
643 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SLAVE_COMPRESSED_PROTOCOL"),
644 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SLAVE_EXEC_MODE"),
645 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SLAVE_LOAD_TMPDIR"),
646 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SLAVE_MAX_ALLOWED_PACKET"),
647 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SLAVE_NET_TIMEOUT"),
648 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SLAVE_PARALLEL_TYPE"),
649 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SLAVE_PARALLEL_WORKERS"),
650 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SLAVE_PENDING_JOBS_SIZE_MAX"),
651 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SLAVE_PRESERVE_COMMIT_ORDER"),
652 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SLAVE_ROWS_SEARCH_ALGORITHMS"),
653 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SLAVE_SKIP_ERRORS"),
654 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SLAVE_SQL_VERIFY_CHECKSUM"),
655 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SLAVE_TRANSACTION_RETRIES"),
656 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SLAVE_TYPE_CONVERSIONS"),
657 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SLOW_LAUNCH_TIME"),
658 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SLOW_QUERY_LOG"),
659 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SLOW_QUERY_LOG_FILE"),
660 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SOCKET"),
661 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SQL_SLAVE_SKIP_COUNTER"),
662 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SSL_CA"),
663 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SSL_CAPATH"),
664 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SSL_CERT"),
665 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SSL_CIPHER"),
666 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SSL_CRL"),
667 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SSL_CRLPATH"),
668 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SSL_KEY"),
669 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SUPER_READ_ONLY"),
670 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "STORED_PROGRAM_CACHE"),
671 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SYNC_BINLOG"),
672 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SYNC_FRM"),
673 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SYNC_MASTER_INFO"),
674 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SYNC_RELAY_LOG"),
675 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SYNC_RELAY_LOG_INFO"),
676 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "SYSTEM_TIME_ZONE"),
677 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "TABLE_DEFINITION_CACHE"),
678 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "TABLE_OPEN_CACHE"),
679 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "TABLE_OPEN_CACHE_INSTANCES"),
680 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "THREAD_CACHE_SIZE"),
681 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "THREAD_HANDLING"),
682 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "THREAD_STACK"),
683 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "TIME_FORMAT"),
684 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "TMPDIR"),
685 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "VERSION"),
686 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "VERSION_COMMENT"),
687 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "VERSION_COMPILE_MACHINE"),
688 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "VERSION_COMPILE_OS"),
689 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_VARIABLES", "REQUIRE_SECURE_TRANSPORT")
690 ;
691 --enable_query_log
692
693 --echo #
694 --echo # STEP 2-15
695 --echo # Known global status in 5.6 that should not exist in session queries.
696 --echo # These should be global-only status variables.
697 --disable_query_log
698 insert into test.sanity values
699 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "ABORTED_CLIENTS"),
700 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "ABORTED_CONNECTS"),
701 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "BINLOG_CACHE_DISK_USE"),
702 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "BINLOG_CACHE_USE"),
703 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "BINLOG_STMT_CACHE_DISK_USE"),
704 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "BINLOG_STMT_CACHE_USE"),
705 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "CONNECTIONS"),
706 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "CONNECTION_ERRORS_ACCEPT"),
707 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "CONNECTION_ERRORS_INTERNAL"),
708 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "CONNECTION_ERRORS_MAX_CONNECTIONS"),
709 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "CONNECTION_ERRORS_PEER_ADDRESS"),
710 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "CONNECTION_ERRORS_SELECT"),
711 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "CONNECTION_ERRORS_TCPWRAP"),
712 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "CREATED_TMP_FILES"),
713 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "DELAYED_ERRORS"),
714 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "DELAYED_INSERT_THREADS"),
715 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "DELAYED_WRITES"),
716 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "FLUSH_COMMANDS"),
717 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_AHI_DROP_LOOKUPS"),
718 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_AVAILABLE_UNDO_LOGS"),
719 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_BUFFER_POOL_BYTES_DATA"),
720 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_BUFFER_POOL_BYTES_DIRTY"),
721 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_BUFFER_POOL_DUMP_STATUS"),
722 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_BUFFER_POOL_LOAD_STATUS"),
723 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_BUFFER_POOL_PAGES_DATA"),
724 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_BUFFER_POOL_PAGES_DIRTY"),
725 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_BUFFER_POOL_PAGES_FLUSHED"),
726 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_BUFFER_POOL_PAGES_FREE"),
727 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_BUFFER_POOL_PAGES_LATCHED"),
728 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_BUFFER_POOL_PAGES_MISC"),
729 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_BUFFER_POOL_PAGES_TOTAL"),
730 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_BUFFER_POOL_READS"),
731 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_BUFFER_POOL_READ_AHEAD"),
732 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_BUFFER_POOL_READ_AHEAD_EVICTED"),
733 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_BUFFER_POOL_READ_AHEAD_RND"),
734 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_BUFFER_POOL_READ_REQUESTS"),
735 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_BUFFER_POOL_RESIZE_STATUS"),
736 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_BUFFER_POOL_WAIT_FREE"),
737 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_BUFFER_POOL_WRITE_REQUESTS"),
738 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_DATA_FSYNCS"),
739 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_DATA_PENDING_FSYNCS"),
740 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_DATA_PENDING_READS"),
741 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_DATA_PENDING_WRITES"),
742 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_DATA_READ"),
743 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_DATA_READS"),
744 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_DATA_WRITES"),
745 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_DATA_WRITTEN"),
746 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_DBLWR_PAGES_WRITTEN"),
747 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_DBLWR_WRITES"),
748 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_HAVE_ATOMIC_BUILTINS"),
749 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_LOG_WAITS"),
750 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_LOG_WRITES"),
751 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_LOG_WRITE_REQUESTS"),
752 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_NUM_OPEN_FILES"),
753 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_OS_LOG_FSYNCS"),
754 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_OS_LOG_PENDING_FSYNCS"),
755 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_OS_LOG_PENDING_WRITES"),
756 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_OS_LOG_WRITTEN"),
757 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_PAGES_CREATED"),
758 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_PAGES_READ"),
759 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_PAGES_WRITTEN"),
760 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_PAGE_SIZE"),
761 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_PURGE_TRX_ID_AGE"),
762 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_PURGE_VIEW_TRX_ID_AGE"),
763 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_ROWS_DELETED"),
764 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_ROWS_INSERTED"),
765 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_ROWS_READ"),
766 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_ROWS_UPDATED"),
767 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_ROW_LOCK_CURRENT_WAITS"),
768 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_ROW_LOCK_TIME"),
769 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_ROW_LOCK_TIME_AVG"),
770 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_ROW_LOCK_TIME_MAX"),
771 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_ROW_LOCK_WAITS"),
772 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "INNODB_TRUNCATED_STATUS_WRITES"),
773 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "KEY_BLOCKS_NOT_FLUSHED"),
774 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "KEY_BLOCKS_UNUSED"),
775 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "KEY_BLOCKS_USED"),
776 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "KEY_READS"),
777 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "KEY_READ_REQUESTS"),
778 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "KEY_WRITES"),
779 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "KEY_WRITE_REQUESTS"),
780 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "LOCKED_CONNECTS"),
781 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "MAX_USED_CONNECTIONS"),
782 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "MAX_USED_CONNECTIONS_TIME"),
783 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "NOT_FLUSHED_DELAYED_ROWS"),
784 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "OPENED_FILES"),
785 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "OPEN_FILES"),
786 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "OPEN_STREAMS"),
787 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "OPEN_TABLE_DEFINITIONS"),
788 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "ONGOING_ANONYMOUS_GTID_VIOLATING_TRANSACTION_COUNT"),
789 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "ONGOING_ANONYMOUS_TRANSACTION_COUNT"),
790 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "ONGOING_AUTOMATIC_GTID_VIOLATING_TRANSACTION_COUNT"),
791 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PERFORMANCE_SCHEMA_ACCOUNTS_LOST"),
792 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PERFORMANCE_SCHEMA_COND_CLASSES_LOST"),
793 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PERFORMANCE_SCHEMA_COND_INSTANCES_LOST"),
794 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PERFORMANCE_SCHEMA_DIGEST_LOST"),
795 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PERFORMANCE_SCHEMA_FILE_CLASSES_LOST"),
796 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PERFORMANCE_SCHEMA_FILE_HANDLES_LOST"),
797 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PERFORMANCE_SCHEMA_FILE_INSTANCES_LOST"),
798 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PERFORMANCE_SCHEMA_INDEX_STAT_LOST"),
799 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PERFORMANCE_SCHEMA_HOSTS_LOST"),
800 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PERFORMANCE_SCHEMA_LOCKER_LOST"),
801 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PERFORMANCE_SCHEMA_MEMORY_CLASSES_LOST"),
802 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PERFORMANCE_SCHEMA_METADATA_LOCK_LOST"),
803 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PERFORMANCE_SCHEMA_MUTEX_CLASSES_LOST"),
804 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PERFORMANCE_SCHEMA_MUTEX_INSTANCES_LOST"),
805 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PERFORMANCE_SCHEMA_NESTED_STATEMENT_LOST"),
806 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PERFORMANCE_SCHEMA_PREPARED_STATEMENTS_LOST"),
807 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PERFORMANCE_SCHEMA_PROGRAM_LOST"),
808 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PERFORMANCE_SCHEMA_RWLOCK_CLASSES_LOST"),
809 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PERFORMANCE_SCHEMA_RWLOCK_INSTANCES_LOST"),
810 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PERFORMANCE_SCHEMA_SESSION_CONNECT_ATTRS_LOST"),
811 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PERFORMANCE_SCHEMA_SOCKET_CLASSES_LOST"),
812 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PERFORMANCE_SCHEMA_SOCKET_INSTANCES_LOST"),
813 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PERFORMANCE_SCHEMA_STAGE_CLASSES_LOST"),
814 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PERFORMANCE_SCHEMA_STATEMENT_CLASSES_LOST"),
815 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PERFORMANCE_SCHEMA_TABLE_HANDLES_LOST"),
816 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PERFORMANCE_SCHEMA_TABLE_INSTANCES_LOST"),
817 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PERFORMANCE_SCHEMA_TABLE_LOCK_STAT_LOST"),
818 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PERFORMANCE_SCHEMA_THREAD_CLASSES_LOST"),
819 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PERFORMANCE_SCHEMA_THREAD_INSTANCES_LOST"),
820 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PERFORMANCE_SCHEMA_USERS_LOST"),
821 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "PREPARED_STMT_COUNT"),
822 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "QCACHE_FREE_BLOCKS"),
823 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "QCACHE_FREE_MEMORY"),
824 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "QCACHE_HITS"),
825 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "QCACHE_INSERTS"),
826 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "QCACHE_LOWMEM_PRUNES"),
827 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "QCACHE_NOT_CACHED"),
828 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "QCACHE_QUERIES_IN_CACHE"),
829 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "QCACHE_TOTAL_BLOCKS"),
830 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "RSA_PUBLIC_KEY"),
831 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "SLAVE_OPEN_TEMP_TABLES"),
832 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "SLAVE_ROWS_LAST_SEARCH_ALGORITHM_USED"),
833 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "SSL_ACCEPTS"),
834 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "SSL_ACCEPT_RENEGOTIATES"),
835 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "SSL_CALLBACK_CACHE_HITS"),
836 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "SSL_CLIENT_CONNECTS"),
837 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "SSL_CONNECT_RENEGOTIATES"),
838 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "SSL_CTX_VERIFY_DEPTH"),
839 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "SSL_CTX_VERIFY_MODE"),
840 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "SSL_FINISHED_ACCEPTS"),
841 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "SSL_FINISHED_CONNECTS"),
842 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "SSL_SESSION_CACHE_HITS"),
843 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "SSL_SESSION_CACHE_MISSES"),
844 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "SSL_SESSION_CACHE_MODE"),
845 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "SSL_SESSION_CACHE_OVERFLOWS"),
846 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "SSL_SESSION_CACHE_SIZE"),
847 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "SSL_SESSION_CACHE_TIMEOUTS"),
848 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "SSL_USED_SESSION_CACHE_ENTRIES"),
849 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "TABLE_LOCKS_IMMEDIATE"),
850 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "TABLE_LOCKS_WAITED"),
851 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "TC_LOG_MAX_PAGES_USED"),
852 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "TC_LOG_PAGE_SIZE"),
853 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "TC_LOG_PAGE_WAITS"),
854 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "THREADS_CACHED"),
855 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "THREADS_CONNECTED"),
856 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "THREADS_CREATED"),
857 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "THREADS_RUNNING"),
858 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "UPTIME"),
859 ("JUNK: GLOBAL-ONLY", "I_S.SESSION_STATUS", "UPTIME_SINCE_FLUSH_STATUS")
860 ;
861 --enable_query_log
862
863 --echo #
864 --echo # STEP 2-15A
865 --echo # COM counters appear in I_S.SESSION_STATUS, but not in P_S.SESSION_STATUS
866 --disable_query_log
867 insert into test.sanity values
868 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_ADMIN_COMMANDS"),
869 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_ALTER_DB"),
870 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_ALTER_DB_UPGRADE"),
871 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_ALTER_EVENT"),
872 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_ALTER_FUNCTION"),
873 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_ALTER_INSTANCE"),
874 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_ALTER_PROCEDURE"),
875 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_ALTER_SERVER"),
876 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_ALTER_TABLE"),
877 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_ALTER_TABLESPACE"),
878 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_ALTER_USER"),
879 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_ANALYZE"),
880 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_ASSIGN_TO_KEYCACHE"),
881 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_BEGIN"),
882 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_BINLOG"),
883 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_CALL_PROCEDURE"),
884 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_CHANGE_DB"),
885 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_CHANGE_MASTER"),
886 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_CHANGE_REPL_FILTER"),
887 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_CHECK"),
888 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_CHECKSUM"),
889 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_COMMIT"),
890 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_CREATE_DB"),
891 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_CREATE_EVENT"),
892 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_CREATE_FUNCTION"),
893 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_CREATE_INDEX"),
894 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_CREATE_PROCEDURE"),
895 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_CREATE_SERVER"),
896 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_CREATE_TABLE"),
897 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_CREATE_TRIGGER"),
898 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_CREATE_UDF"),
899 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_CREATE_USER"),
900 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_CREATE_VIEW"),
901 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_DEALLOC_SQL"),
902 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_DELETE"),
903 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_DELETE_MULTI"),
904 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_DO"),
905 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_DROP_DB"),
906 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_DROP_EVENT"),
907 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_DROP_FUNCTION"),
908 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_DROP_INDEX"),
909 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_DROP_PROCEDURE"),
910 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_DROP_SERVER"),
911 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_DROP_TABLE"),
912 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_DROP_TRIGGER"),
913 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_DROP_USER"),
914 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_DROP_VIEW"),
915 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_EMPTY_QUERY"),
916 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_EXECUTE_SQL"),
917 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_EXPLAIN_OTHER"),
918 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_FLUSH"),
919 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_GET_DIAGNOSTICS"),
920 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_GROUP_REPLICATION_START"),
921 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_GROUP_REPLICATION_STOP"),
922 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_GRANT"),
923 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_HA_CLOSE"),
924 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_HA_OPEN"),
925 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_HA_READ"),
926 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_HELP"),
927 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_INSERT"),
928 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_INSERT_SELECT"),
929 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_INSTALL_PLUGIN"),
930 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_KILL"),
931 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_LOAD"),
932 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_LOCK_TABLES"),
933 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_OPTIMIZE"),
934 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_PRELOAD_KEYS"),
935 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_PREPARE_SQL"),
936 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_PURGE"),
937 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_PURGE_BEFORE_DATE"),
938 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_RELEASE_SAVEPOINT"),
939 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_RENAME_TABLE"),
940 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_RENAME_USER"),
941 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_REPAIR"),
942 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_REPLACE"),
943 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_REPLACE_SELECT"),
944 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_RESET"),
945 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_RESIGNAL"),
946 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_REVOKE"),
947 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_REVOKE_ALL"),
948 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_ROLLBACK"),
949 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_ROLLBACK_TO_SAVEPOINT"),
950 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SAVEPOINT"),
951 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SELECT"),
952 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SET_OPTION"),
953 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_BINLOGS"),
954 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_BINLOG_EVENTS"),
955 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_CHARSETS"),
956 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_COLLATIONS"),
957 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_CREATE_DB"),
958 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_CREATE_EVENT"),
959 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_CREATE_FUNC"),
960 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_CREATE_PROC"),
961 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_CREATE_TABLE"),
962 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_CREATE_TRIGGER"),
963 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_CREATE_USER"),
964 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_DATABASES"),
965 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_ENGINE_LOGS"),
966 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_ENGINE_MUTEX"),
967 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_ENGINE_STATUS"),
968 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_ERRORS"),
969 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_EVENTS"),
970 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_FIELDS"),
971 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_FUNCTION_CODE"),
972 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_FUNCTION_STATUS"),
973 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_GRANTS"),
974 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_KEYS"),
975 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_MASTER_STATUS"),
976 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_OPEN_TABLES"),
977 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_PLUGINS"),
978 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_PRIVILEGES"),
979 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_PROCEDURE_CODE"),
980 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_PROCEDURE_STATUS"),
981 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_PROCESSLIST"),
982 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_PROFILE"),
983 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_PROFILES"),
984 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_RELAYLOG_EVENTS"),
985 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_SLAVE_HOSTS"),
986 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_SLAVE_STATUS"),
987 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_SLAVE_STATUS_NONBLOCKING"),
988 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_STATUS"),
989 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_STORAGE_ENGINES"),
990 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_TABLES"),
991 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_TABLE_STATUS"),
992 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_TRIGGERS"),
993 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_VARIABLES"),
994 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SHOW_WARNINGS"),
995 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SIGNAL"),
996 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SLAVE_START"),
997 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_SLAVE_STOP"),
998 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_STMT_CLOSE"),
999 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_STMT_EXECUTE"),
1000 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_STMT_FETCH"),
1001 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_STMT_PREPARE"),
1002 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_STMT_RESET"),
1003 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_STMT_SEND_LONG_DATA"),
1004 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_TRUNCATE"),
1005 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_UNINSTALL_PLUGIN"),
1006 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_UNLOCK_TABLES"),
1007 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_UPDATE"),
1008 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_UPDATE_MULTI"),
1009 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_XA_COMMIT"),
1010 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_XA_END"),
1011 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_XA_PREPARE"),
1012 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_XA_RECOVER"),
1013 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_XA_ROLLBACK"),
1014 ("JUNK: COM COUNTER", "I_S.SESSION_STATUS", "COM_XA_START")
1015 ;
1016
1017 --enable_query_log
1018
1019 --echo #
1020 --echo # STEP 2-15B
1021 --echo # These slave status counters appear in I_S.SESSION_STATUS, but not in P_S.SESSION_STATUS
1022 insert into test.sanity values
1023 ("JUNK: SLAVE-ONLY", "I_S.SESSION_STATUS", "SLAVE_HEARTBEAT_PERIOD"),
1024 ("JUNK: SLAVE-ONLY", "I_S.SESSION_STATUS", "SLAVE_LAST_HEARTBEAT"),
1025 ("JUNK: SLAVE-ONLY", "I_S.SESSION_STATUS", "SLAVE_RECEIVED_HEARTBEATS"),
1026 ("JUNK: SLAVE-ONLY", "I_S.SESSION_STATUS", "SLAVE_RETRIED_TRANSACTIONS"),
1027 ("JUNK: SLAVE-ONLY", "I_S.SESSION_STATUS", "SLAVE_RUNNING")
1028 ;
1029
1030 --echo #
1031 --echo # STEP 2-16
1032 --echo # Known session-only status in 5.6 that should not exist in global queries.
1033 insert into test.sanity values
1034 ("JUNK: SESSION-ONLY", "I_S.GLOBAL_STATUS", "COMPRESSION"),
1035 ("JUNK: SESSION-ONLY", "I_S.GLOBAL_STATUS", "LAST_QUERY_COST"),
1036 ("JUNK: SESSION-ONLY", "I_S.GLOBAL_STATUS", "LAST_QUERY_PARTIAL_PLANS")
1037 ;
1038
1039 --echo #
1040 --echo # STEP 2-16A
1041 --echo # COM counters appear in I_S.GLOBAL_STATUS but not in P_S.GLOBAL_STATUS
1042 --disable_query_log
1043 insert into test.sanity values
1044 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_ADMIN_COMMANDS"),
1045 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_ALTER_DB"),
1046 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_ALTER_DB_UPGRADE"),
1047 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_ALTER_EVENT"),
1048 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_ALTER_FUNCTION"),
1049 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_ALTER_INSTANCE"),
1050 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_ALTER_PROCEDURE"),
1051 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_ALTER_SERVER"),
1052 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_ALTER_TABLE"),
1053 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_ALTER_TABLESPACE"),
1054 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_ALTER_USER"),
1055 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_ANALYZE"),
1056 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_ASSIGN_TO_KEYCACHE"),
1057 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_BEGIN"),
1058 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_BINLOG"),
1059 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_CALL_PROCEDURE"),
1060 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_CHANGE_DB"),
1061 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_CHANGE_MASTER"),
1062 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_CHANGE_REPL_FILTER"),
1063 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_CHECK"),
1064 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_CHECKSUM"),
1065 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_COMMIT"),
1066 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_CREATE_DB"),
1067 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_CREATE_EVENT"),
1068 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_CREATE_FUNCTION"),
1069 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_CREATE_INDEX"),
1070 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_CREATE_PROCEDURE"),
1071 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_CREATE_SERVER"),
1072 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_CREATE_TABLE"),
1073 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_CREATE_TRIGGER"),
1074 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_CREATE_UDF"),
1075 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_CREATE_USER"),
1076 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_CREATE_VIEW"),
1077 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_DEALLOC_SQL"),
1078 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_DELETE"),
1079 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_DELETE_MULTI"),
1080 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_DO"),
1081 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_DROP_DB"),
1082 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_DROP_EVENT"),
1083 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_DROP_FUNCTION"),
1084 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_DROP_INDEX"),
1085 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_DROP_PROCEDURE"),
1086 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_DROP_SERVER"),
1087 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_DROP_TABLE"),
1088 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_DROP_TRIGGER"),
1089 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_DROP_USER"),
1090 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_DROP_VIEW"),
1091 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_EMPTY_QUERY"),
1092 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_EXECUTE_SQL"),
1093 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_EXPLAIN_OTHER"),
1094 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_FLUSH"),
1095 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_GET_DIAGNOSTICS"),
1096 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_GRANT"),
1097 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_GROUP_REPLICATION_START"),
1098 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_GROUP_REPLICATION_STOP"),
1099 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_HA_CLOSE"),
1100 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_HA_OPEN"),
1101 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_HA_READ"),
1102 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_HELP"),
1103 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_INSERT"),
1104 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_INSERT_SELECT"),
1105 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_INSTALL_PLUGIN"),
1106 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_KILL"),
1107 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_LOAD"),
1108 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_LOCK_TABLES"),
1109 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_OPTIMIZE"),
1110 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_PRELOAD_KEYS"),
1111 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_PREPARE_SQL"),
1112 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_PURGE"),
1113 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_PURGE_BEFORE_DATE"),
1114 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_RELEASE_SAVEPOINT"),
1115 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_RENAME_TABLE"),
1116 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_RENAME_USER"),
1117 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_REPAIR"),
1118 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_REPLACE"),
1119 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_REPLACE_SELECT"),
1120 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_RESET"),
1121 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_RESIGNAL"),
1122 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_REVOKE"),
1123 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_REVOKE_ALL"),
1124 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_ROLLBACK"),
1125 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_ROLLBACK_TO_SAVEPOINT"),
1126 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SAVEPOINT"),
1127 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SELECT"),
1128 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SET_OPTION"),
1129 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_BINLOGS"),
1130 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_BINLOG_EVENTS"),
1131 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_CHARSETS"),
1132 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_COLLATIONS"),
1133 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_CREATE_DB"),
1134 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_CREATE_EVENT"),
1135 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_CREATE_FUNC"),
1136 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_CREATE_PROC"),
1137 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_CREATE_TABLE"),
1138 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_CREATE_TRIGGER"),
1139 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_CREATE_USER"),
1140 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_DATABASES"),
1141 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_ENGINE_LOGS"),
1142 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_ENGINE_MUTEX"),
1143 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_ENGINE_STATUS"),
1144 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_ERRORS"),
1145 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_EVENTS"),
1146 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_FIELDS"),
1147 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_FUNCTION_CODE"),
1148 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_FUNCTION_STATUS"),
1149 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_GRANTS"),
1150 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_KEYS"),
1151 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_MASTER_STATUS"),
1152 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_OPEN_TABLES"),
1153 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_PLUGINS"),
1154 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_PRIVILEGES"),
1155 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_PROCEDURE_CODE"),
1156 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_PROCEDURE_STATUS"),
1157 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_PROCESSLIST"),
1158 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_PROFILE"),
1159 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_PROFILES"),
1160 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_RELAYLOG_EVENTS"),
1161 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_SLAVE_HOSTS"),
1162 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_SLAVE_STATUS"),
1163 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_SLAVE_STATUS_NONBLOCKING"),
1164 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_STATUS"),
1165 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_STORAGE_ENGINES"),
1166 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_TABLES"),
1167 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_TABLE_STATUS"),
1168 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_TRIGGERS"),
1169 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_VARIABLES"),
1170 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SHOW_WARNINGS"),
1171 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SIGNAL"),
1172 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SLAVE_START"),
1173 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_SLAVE_STOP"),
1174 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_STMT_CLOSE"),
1175 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_STMT_EXECUTE"),
1176 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_STMT_FETCH"),
1177 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_STMT_PREPARE"),
1178 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_STMT_RESET"),
1179 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_STMT_SEND_LONG_DATA"),
1180 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_TRUNCATE"),
1181 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_UNINSTALL_PLUGIN"),
1182 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_UNLOCK_TABLES"),
1183 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_UPDATE"),
1184 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_UPDATE_MULTI"),
1185 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_XA_COMMIT"),
1186 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_XA_END"),
1187 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_XA_PREPARE"),
1188 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_XA_RECOVER"),
1189 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_XA_ROLLBACK"),
1190 ("JUNK: COM COUNTER", "I_S.GLOBAL_STATUS", "COM_XA_START")
1191 ;
1192
1193 --enable_query_log
1194
1195 --echo #
1196 --echo # STEP 2-16B
1197 --echo # These slave status counters appear in I_S.GLOBAL_STATUS, but not in P_S.GLOBAL_STATUS
1198 insert into test.sanity values
1199 ("JUNK: SLAVE-ONLY", "I_S.GLOBAL_STATUS", "SLAVE_HEARTBEAT_PERIOD"),
1200 ("JUNK: SLAVE-ONLY", "I_S.GLOBAL_STATUS", "SLAVE_LAST_HEARTBEAT"),
1201 ("JUNK: SLAVE-ONLY", "I_S.GLOBAL_STATUS", "SLAVE_RECEIVED_HEARTBEATS"),
1202 ("JUNK: SLAVE-ONLY", "I_S.GLOBAL_STATUS", "SLAVE_RETRIED_TRANSACTIONS"),
1203 ("JUNK: SLAVE-ONLY", "I_S.GLOBAL_STATUS", "SLAVE_RUNNING")
1204 ;
1205
1206 --echo #
1207 --echo # STEP 2-17
1208 --echo # Status variables that should not exist in queries that aggregate across threads.
1209 --echo # Criteria: Session-only OR non-aggregatable.
1210 insert into test.sanity values
1211 ("JUNK", "NO AGGREGATE", "COMPRESSION"),
1212 ("JUNK", "NO AGGREGATE", "LAST_QUERY_COST"),
1213 ("JUNK", "NO AGGREGATE", "LAST_QUERY_PARTIAL_PLANS"),
1214 ("JUNK", "NO AGGREGATE", "OPEN_TABLES"),
1215 ("JUNK", "NO AGGREGATE", "QUERIES"),
1216 ("JUNK", "NO AGGREGATE", "SLOW_LAUNCH_THREADS"),
1217 ("JUNK", "NO AGGREGATE", "SSL_CIPHER"),
1218 ("JUNK", "NO AGGREGATE", "SSL_CIPHER_LIST"),
1219 ("JUNK", "NO AGGREGATE", "SSL_DEFAULT_TIMEOUT"),
1220 ("JUNK", "NO AGGREGATE", "SSL_SERVER_NOT_AFTER"),
1221 ("JUNK", "NO AGGREGATE", "SSL_SERVER_NOT_BEFORE"),
1222 ("JUNK", "NO AGGREGATE", "SSL_SESSIONS_REUSED"),
1223 ("JUNK", "NO AGGREGATE", "SSL_VERIFY_DEPTH"),
1224 ("JUNK", "NO AGGREGATE", "SSL_VERIFY_MODE"),
1225 ("JUNK", "NO AGGREGATE", "SSL_VERSION")
1226 ;
1227
1228 #Debug
1229 #select * from test.sanity order by show_mode, source, variable_name;
1230
1231 --echo #
1232 --echo # ================================================================================
1233 --echo # TEST 1A
1234 --echo # Present in 5.6 P_S.GLOBAL_VARIABLES (1-3)
1235 --echo # Missing in 5.6 I_S.GLOBAL_VARIABLES (1-1)
1236 --echo # ================================================================================
1237 select * from test.sanity
1238 where show_mode = "5.6"
1239 and source = "P_S.GLOBAL_VARIABLES"
1240 and upper(variable_name) not in (
1241 select upper(variable_name) from test.sanity
1242 where show_mode = "5.6"
1243 and source = "I_S.GLOBAL_VARIABLES")
1244 order by show_mode, source, variable_name;
1245
1246 --echo #
1247 --echo # ================================================================================
1248 --echo # TEST 1B
1249 --echo # Present in 5.7 P_S.GLOBAL_VARIABLES (2-3)
1250 --echo # Missing in 5.6 I_S.GLOBAL_VARIABLES (1-1)
1251 --echo # ================================================================================
1252 select * from test.sanity
1253 where show_mode = "5.7"
1254 and source = "P_S.GLOBAL_VARIABLES"
1255 and upper(variable_name) not in (
1256 select upper(variable_name) from test.sanity
1257 where show_mode = "5.6"
1258 and source = "I_S.GLOBAL_VARIABLES")
1259 order by show_mode, source, variable_name;
1260
1261 --echo #
1262 --echo # ================================================================================
1263 --echo # TEST 2A
1264 --echo # Present in 5.6 I_S.GLOBAL_VARIABLES (1-1)
1265 --echo # Missing in 5.6 P_S.GLOBAL_VARIABLES (1-3)
1266 --echo # ================================================================================
1267 select * from test.sanity
1268 where show_mode = "5.6"
1269 and source = "I_S.GLOBAL_VARIABLES"
1270 and upper(variable_name) not in (
1271 select upper(variable_name) from test.sanity
1272 where show_mode = "5.6"
1273 and source = "P_S.GLOBAL_VARIABLES")
1274 order by show_mode, source, variable_name;
1275
1276 --echo #
1277 --echo # ================================================================================
1278 --echo # TEST 2B
1279 --echo # Present in 5.6 I_S.GLOBAL_VARIABLES (1-1)
1280 --echo # Missing in 5.7 P_S.GLOBAL_VARIABLES (2-3)
1281 --echo # ================================================================================
1282 select * from test.sanity
1283 where show_mode = "5.6"
1284 and source = "I_S.GLOBAL_VARIABLES"
1285 and upper(variable_name) not in (
1286 select upper(variable_name) from test.sanity
1287 where show_mode = "5.7"
1288 and source = "P_S.GLOBAL_VARIABLES")
1289 order by show_mode, source, variable_name;
1290
1291 --echo #
1292 --echo # ================================================================================
1293 --echo # TEST 3A
1294 --echo # Present in 5.6 P_S.SESSION_VARIABLES (1-5)
1295 --echo # Missing in 5.6 I_S.SESSION_VARIABLES (1-2)
1296 --echo # ================================================================================
1297 select * from test.sanity
1298 where show_mode = "5.6"
1299 and source = "P_S.SESSION_VARIABLES"
1300 and upper(variable_name) not in (
1301 select upper(variable_name) from test.sanity
1302 where show_mode = "5.6"
1303 and source = "I_S.SESSION_VARIABLES")
1304 order by show_mode, source, variable_name;
1305
1306 --echo #
1307 --echo # ================================================================================
1308 --echo # TEST 3B
1309 --echo # Present in 5.7 P_S.SESSION_VARIABLES (2-5)
1310 --echo # Missing in 5.6 I_S.SESSION_VARIABLES (1-2)
1311 --echo # ================================================================================
1312 select * from test.sanity
1313 where show_mode = "5.7"
1314 and source = "P_S.SESSION_VARIABLES"
1315 and upper(variable_name) not in (
1316 select upper(variable_name) from test.sanity
1317 where show_mode = "5.6"
1318 and source = "I_S.SESSION_VARIABLES")
1319 order by show_mode, source, variable_name;
1320
1321 --echo #
1322 --echo # ================================================================================
1323 --echo # TEST 4A
1324 --echo # Present in 5.6 I_S.SESSION_VARIABLES (1-2)
1325 --echo # Missing in 5.6 P_S.SESSION_VARIABLES (1-5)
1326 --echo # ================================================================================
1327 select * from test.sanity
1328 where show_mode = "5.6"
1329 and source = "I_S.SESSION_VARIABLES"
1330 and upper(variable_name) not in (
1331 select upper(variable_name) from test.sanity
1332 where show_mode = "5.6"
1333 and source = "P_S.SESSION_VARIABLES")
1334 order by show_mode, source, variable_name;
1335
1336 --echo #
1337 --echo # ================================================================================
1338 --echo # TEST 4B
1339 --echo # Present in 5.6 I_S.SESSION_VARIABLES (1-2)
1340 --echo # Missing in 5.7 P_S.SESSION_VARIABLES (2-5)
1341 --echo # ================================================================================
1342 select * from test.sanity
1343 where show_mode = "5.6"
1344 and source = "I_S.SESSION_VARIABLES"
1345 and upper(variable_name) not in (
1346 select upper(variable_name) from test.sanity
1347 where show_mode = "5.7"
1348 and source = "P_S.SESSION_VARIABLES")
1349 order by show_mode, source, variable_name;
1350
1351 --echo #
1352 --echo # ================================================================================
1353 --echo # TEST 5A
1354 --echo # Present in 5.6 P_S.VARIABLES_BY_THREAD (1-4)
1355 --echo # Missing in 5.6 I_S.SESSION_VARIABLES (1-2)
1356 --echo # ================================================================================
1357 select * from test.sanity
1358 where show_mode = "5.6"
1359 and source = "P_S.VARIABLES_BY_THREAD"
1360 and upper(variable_name) not in (
1361 select upper(variable_name) from test.sanity
1362 where show_mode = "5.6"
1363 and source = "I_S.SESSION_VARIABLES")
1364 order by show_mode, source, variable_name;
1365
1366 --echo #
1367 --echo # ================================================================================
1368 --echo # TEST 5B
1369 --echo # Present in 5.7 P_S.VARIABLES_BY_THREAD (2-4)
1370 --echo # Missing in 5.6 I_S.SESSION_VARIABLES (1-2)
1371 --echo # ================================================================================
1372 select * from test.sanity
1373 where show_mode = "5.7"
1374 and source = "P_S.VARIABLES_BY_THREAD"
1375 and upper(variable_name) not in (
1376 select upper(variable_name) from test.sanity
1377 where show_mode = "5.6"
1378 and source = "I_S.SESSION_VARIABLES")
1379 order by show_mode, source, variable_name;
1380
1381 --echo #
1382 --echo # ================================================================================
1383 --echo # TEST 5C
1384 --echo # Present in 5.6 I_S.SESSION_VARIABLES (1-2)
1385 --echo # Missing in 5.6 P_S.VARIABLES_BY_THREAD (1-4)
1386 --echo # EXPECT NOTHING BESIDE KNOWN GLOBAL VARIABLES (2-14)
1387 --echo # ================================================================================
1388 select * from test.sanity
1389 where show_mode = "5.6"
1390 and source = "I_S.SESSION_VARIABLES"
1391 and upper(variable_name) not in (
1392 select upper(variable_name) from test.sanity
1393 where show_mode = "5.6"
1394 and source = "P_S.VARIABLES_BY_THREAD")
1395 and upper(variable_name) not in (
1396 select upper(variable_name) from test.sanity
1397 where show_mode = "JUNK: GLOBAL-ONLY"
1398 and source = "I_S.SESSION_VARIABLES")
1399 order by show_mode, source, variable_name;
1400
1401 --echo #
1402 --echo # ================================================================================
1403 --echo # TEST 5D
1404 --echo # Present in 5.6 I_S.SESSION_VARIABLES (1-2)
1405 --echo # Missing in 5.7 P_S.VARIABLES_BY_THREAD (2-5)
1406 --echo # EXPECT NOTHING BESIDE KNOWN GLOBAL VARIABLES (2-14)
1407 --echo # ================================================================================
1408 select * from test.sanity
1409 where show_mode = "5.6"
1410 and source = "I_S.SESSION_VARIABLES"
1411 and upper(variable_name) not in (
1412 select upper(variable_name) from test.sanity
1413 where show_mode = "5.7"
1414 and source = "P_S.VARIABLES_BY_THREAD")
1415 and upper(variable_name) not in (
1416 select upper(variable_name) from test.sanity
1417 where show_mode = "JUNK: GLOBAL-ONLY"
1418 and source = "I_S.SESSION_VARIABLES")
1419 order by show_mode, source, variable_name;
1420
1421 --echo #
1422 --echo # ================================================================================
1423 --echo # TEST 5E
1424 --echo # KNOWN GLOBAL VARIABLES (2-14)
1425 --echo # Expect missing in 5.6 P_S.VARIABLES_BY_THREAD (1-4)
1426 --echo # ================================================================================
1427 select * from test.sanity
1428 where show_mode = "JUNK: GLOBAL-ONLY"
1429 and source = "I_S.SESSION_VARIABLES"
1430 and upper(variable_name) in (
1431 select upper(variable_name) from test.sanity
1432 where show_mode = "5.6"
1433 and source = "P_S.VARIABLES_BY_THREAD")
1434 order by show_mode, source, variable_name;
1435
1436 --echo #
1437 --echo # ================================================================================
1438 --echo # TEST 5F
1439 --echo # KNOWN GLOBAL VARIABLES (2-14)
1440 --echo # Expect missing in 5.7 P_S.VARIABLES_BY_THREAD (2-5)
1441 --echo # ================================================================================
1442 select * from test.sanity
1443 where show_mode = "JUNK: GLOBAL-ONLY"
1444 and source = "I_S.SESSION_VARIABLES"
1445 and upper(variable_name) in (
1446 select upper(variable_name) from test.sanity
1447 where show_mode = "5.7"
1448 and source = "P_S.VARIABLES_BY_THREAD")
1449 order by show_mode, source, variable_name;
1450
1451 --echo #
1452 --echo # ================================================================================
1453 --echo # TEST 6A
1454 --echo # Present in 5.7 P_S.GLOBAL_STATUS (2-8)
1455 --echo # Missing in 5.6 I_S.GLOBAL_STATUS (1-6)
1456 --echo # EXPECT NOTHING
1457 --echo # ================================================================================
1458 select * from test.sanity
1459 where show_mode = "5.7"
1460 and source = "P_S.GLOBAL_STATUS"
1461 and upper(variable_name) not in (
1462 select upper(variable_name) from test.sanity
1463 where show_mode = "5.6"
1464 and source = "I_S.GLOBAL_STATUS")
1465 order by show_mode, source, variable_name;
1466
1467 --echo #
1468 --echo # ================================================================================
1469 --echo # TEST 6B
1470 --echo # Present in 5.7 P_S.GLOBAL_STATUS (2-8)
1471 --echo # Missing in 5.6 P_S.GLOBAL_STATUS (1-8)
1472 --echo # EXPECT NOTHING
1473 --echo # ================================================================================
1474 select * from test.sanity
1475 where show_mode = "5.7"
1476 and source = "P_S.GLOBAL_STATUS"
1477 and upper(variable_name) not in (
1478 select upper(variable_name) from test.sanity
1479 where show_mode = "5.6"
1480 and source = "P_S.GLOBAL_STATUS")
1481 order by show_mode, source, variable_name;
1482
1483 --echo #
1484 --echo # ================================================================================
1485 --echo # TEST 6C
1486 --echo # Present in 5.6 P_S.GLOBAL_STATUS (1-8)
1487 --echo # Missing in 5.7 P_S.GLOBAL_STATUS (2-8)
1488 --echo # EXPECT NOTHING
1489 --echo # ================================================================================
1490 select * from test.sanity
1491 where show_mode = "5.6"
1492 and source = "P_S.GLOBAL_STATUS"
1493 and upper(variable_name) not in (
1494 select upper(variable_name) from test.sanity
1495 where show_mode = "5.7"
1496 and source = "P_S.GLOBAL_STATUS")
1497 order by show_mode, source, variable_name;
1498
1499 --echo #
1500 --echo # ================================================================================
1501 --echo # TEST 7
1502 --echo # Present in 5.6 I_S.GLOBAL_STATUS (1-6)
1503 --echo # Missing in 5.7 P_S.GLOBAL_STATUS (2-8)
1504 --echo # EXPECT NOTHING AFTER REMOVING KNOWN SESSION-ONLY, COM COUNTERS AND SLAVE-ONLY (2-16 & 2-16A & 2-16B)
1505 --echo # ================================================================================
1506 select * from test.sanity
1507 where show_mode = "5.6"
1508 and source = "I_S.GLOBAL_STATUS"
1509 and upper(variable_name) not in (
1510 select upper(variable_name) from test.sanity
1511 where (show_mode = "JUNK: SESSION-ONLY" or show_mode = "JUNK: COM COUNTER" or show_mode = "JUNK: SLAVE-ONLY")
1512 and source = "I_S.GLOBAL_STATUS")
1513 and upper(variable_name) not in (
1514 select upper(variable_name) from test.sanity
1515 where show_mode = "5.7"
1516 and source = "P_S.GLOBAL_STATUS")
1517 order by show_mode, source, variable_name;
1518
1519 --echo #
1520 --echo # ================================================================================
1521 --echo # TEST 8
1522 --echo # KNOWN SESSION-ONLY (2-16)
1523 --echo # KNOWN COM COUNTERS (2-16A)
1524 --echo # KNOWN SLAVE-ONLY (2-16B)
1525 --echo # Status variables that should NOT be present in 5.7 P_S.GLOBAL_STATUS (2-8)
1526 --echo # EXPECT NOTHING
1527 --echo # ================================================================================
1528 select * from test.sanity
1529 where show_mode = "5.7"
1530 and source = "P_S.GLOBAL_STATUS"
1531 and upper(variable_name) in (
1532 select upper(variable_name) from test.sanity
1533 where (show_mode = "JUNK: SESSION-ONLY" or show_mode = "JUNK: COM COUNTER" or show_mode = "JUNK: SLAVE-ONLY")
1534 and source = "I_S.GLOBAL_STATUS")
1535 order by show_mode, source, variable_name;
1536
1537 --echo #
1538 --echo # ================================================================================
1539 --echo # TEST 9A
1540 --echo # Present in 5.7 P_S.SESSION_STATUS (2-10)
1541 --echo # Missing in 5.6 I_S.SESSION_STATUS (1-7)
1542 --echo # EXPECT NOTHING
1543 --echo # ================================================================================
1544 select * from test.sanity
1545 where show_mode = "5.7"
1546 and source = "P_S.SESSION_STATUS"
1547 and upper(variable_name) not in (
1548 select upper(variable_name) from test.sanity
1549 where show_mode = "5.6"
1550 and source = "I_S.SESSION_STATUS")
1551 order by show_mode, source, variable_name;
1552
1553 --echo #
1554 --echo # ================================================================================
1555 --echo # TEST 9B
1556 --echo # Present in 5.7 P_S.SESSION_STATUS (2-10)
1557 --echo # Missing in 5.6 P_S.SESSION_STATUS (1-10)
1558 --echo # EXPECT NOTHING
1559 --echo # ================================================================================
1560 select * from test.sanity
1561 where show_mode = "5.7"
1562 and source = "P_S.SESSION_STATUS"
1563 and upper(variable_name) not in (
1564 select upper(variable_name) from test.sanity
1565 where show_mode = "5.6"
1566 and source = "P_S.SESSION_STATUS")
1567 order by show_mode, source, variable_name;
1568
1569 --echo #
1570 --echo # ================================================================================
1571 --echo # TEST 9C
1572 --echo # Present in 5.6 P_S.SESSION_STATUS (1-10)
1573 --echo # Missing in 5.7 P_S.SESSION_STATUS (2-10)
1574 --echo # EXPECT NOTHING
1575 --echo # ================================================================================
1576 select * from test.sanity
1577 where show_mode = "5.6"
1578 and source = "P_S.SESSION_STATUS"
1579 and upper(variable_name) not in (
1580 select upper(variable_name) from test.sanity
1581 where show_mode = "5.7"
1582 and source = "P_S.SESSION_STATUS")
1583 order by show_mode, source, variable_name;
1584
1585 --echo #
1586 --echo # ================================================================================
1587 --echo # TEST 10
1588 --echo # Present in 5.6 I_S.SESSION_STATUS (1-7)
1589 --echo # Missing in 5.7 P_S.SESSION_STATUS (2-10)
1590 --echo # EXPECT NOTHING AFTER REMOVING KNOWN COM COUNTERS AND SLAVE-ONLY (2-15A & 2-15B)
1591 --echo # ================================================================================
1592 select * from test.sanity
1593 where show_mode = "5.6"
1594 and source = "I_S.SESSION_STATUS"
1595 and upper(variable_name) not in (
1596 select upper(variable_name) from test.sanity
1597 where (show_mode = "JUNK: COM COUNTER" or show_mode = "JUNK: SLAVE-ONLY")
1598 and source = "I_S.SESSION_STATUS")
1599 and upper(variable_name) not in (
1600 select upper(variable_name) from test.sanity
1601 where show_mode = "5.7"
1602 and source = "P_S.SESSION_STATUS")
1603 order by show_mode, source, variable_name;
1604
1605 --echo #
1606 --echo # ================================================================================
1607 --echo # TEST 11
1608 --echo # KNOWN COM COUNTERS (2-15A)
1609 --echo # KNOWN SLAVE-ONLY (2-15B)
1610 --echo # Status variables that should NOT be present in 5.7 P_S.SESSION_STATUS (2-10)
1611 --echo # EXPECT NOTHING
1612 --echo # ================================================================================
1613 select * from test.sanity
1614 where show_mode = "5.7"
1615 and source = "P_S.SESSION_STATUS"
1616 and upper(variable_name) in (
1617 select upper(variable_name) from test.sanity
1618 where (show_mode = "JUNK: COM COUNTER" or show_mode = "JUNK: SLAVE-ONLY")
1619 and source = "I_S.SESSION_STATUS")
1620 order by show_mode, source, variable_name;
1621
1622 --echo #
1623 --echo # ================================================================================
1624 --echo # TEST 12
1625 --echo # Present in 5.7 P_S.SESSION_STATUS (2-10)
1626 --echo # Missing in 5.7 P_S.STATUS_BY_THREAD
1627 --echo # EXPECT NOTHING AFTER REMOVING KNOWN GLOBAL-ONLY (2-15)
1628 --echo # ================================================================================
1629 select * from test.sanity
1630 where show_mode = "5.7"
1631 and source = "P_S.SESSION_STATUS"
1632 and upper(variable_name) not in (
1633 select upper(variable_name) from test.sanity
1634 where show_mode = "5.7"
1635 and source = "P_S.STATUS_BY_THREAD")
1636 and upper(variable_name) not in (
1637 select upper(variable_name) from test.sanity
1638 where (show_mode = "JUNK: GLOBAL-ONLY")
1639 and source = "I_S.SESSION_STATUS")
1640 order by show_mode, source, variable_name;
1641
1642 --echo #
1643 --echo # ================================================================================
1644 --echo # TEST 13
1645 --echo # Present in 5.7 P_S.STATUS_BY_THREAD
1646 --echo # Missing in 5.7 P_S.SESSION_STATUS (2-10)
1647 --echo # EXPECT NOTHING
1648 --echo # ================================================================================
1649 select * from test.sanity
1650 where show_mode = "5.7"
1651 and source = "P_S.STATUS_BY_THREAD"
1652 and upper(variable_name) not in (
1653 select upper(variable_name) from test.sanity
1654 where show_mode = "5.7"
1655 and source = "P_S.SESSION_STATUS")
1656 order by show_mode, source, variable_name;
1657
1658 --echo #
1659 --echo # ================================================================================
1660 --echo # TEST 14
1661 --echo # Present in 5.7 P_S.SESSION_STATUS (2-10)
1662 --echo # Missing in 5.7 P_S.STATUS_BY_ACCOUNT
1663 --echo # EXPECT NOTHING AFTER REMOVING
1664 --echo # - KNOWN GLOBAL-ONLY (2-15)
1665 --echo # - STATUS VARS THAT CAN'T BE AGGREGATED (2-17)
1666 --echo # ================================================================================
1667 select * from test.sanity
1668 where show_mode = "5.7"
1669 and source = "P_S.SESSION_STATUS"
1670 and upper(variable_name) not in (
1671 select upper(variable_name) from test.sanity
1672 where show_mode = "JUNK"
1673 and source = "NO AGGREGATE")
1674 and upper(variable_name) not in (
1675 select upper(variable_name) from test.sanity
1676 where (show_mode = "JUNK: GLOBAL-ONLY")
1677 and source = "I_S.SESSION_STATUS")
1678 and upper(variable_name) not in (
1679 select upper(variable_name) from test.sanity
1680 where show_mode = "5.7"
1681 and source = "P_S.STATUS_BY_ACCOUNT")
1682 order by show_mode, source, variable_name;
1683
1684 --echo #
1685 --echo # ================================================================================
1686 --echo # TEST 15
1687 --echo # Present in 5.7 P_S.STATUS_BY_ACCOUNT
1688 --echo # Missing in 5.7 P_S.SESSION_STATUS (2-10)
1689 --echo # EXPECT NOTHING
1690 --echo # ================================================================================
1691 select * from test.sanity
1692 where show_mode = "5.7"
1693 and source = "P_S.STATUS_BY_ACCOUNT"
1694 and upper(variable_name) not in (
1695 select upper(variable_name) from test.sanity
1696 where show_mode = "5.7"
1697 and source = "P_S.SESSION_STATUS")
1698 order by show_mode, source, variable_name;
1699
1700 --echo #
1701 --echo # ================================================================================
1702 --echo # TEST 16
1703 --echo # KNOWN STATUS VARS THAT CAN'T BE AGGREGATED (2-17)
1704 --echo # Status variables that should NOT be present in 5.7 P_S.STATUS_BY_ACCOUNT
1705 --echo # ================================================================================
1706 select * from performance_schema.status_by_account
1707 where upper(variable_name) in (
1708 select upper(variable_name) from test.sanity
1709 where show_mode = "JUNK"
1710 and source = "NO AGGREGATE")
1711 order by variable_name;
1712
1713 --echo #
1714 --echo # ================================================================================
1715 --echo # TEST 17
1716 --echo # Present in 5.7 P_S.SESSION_STATUS (2-10)
1717 --echo # Missing in 5.7 P_S.STATUS_BY_USER
1718 --echo # EXPECT NOTHING AFTER REMOVING
1719 --echo # - KNOWN GLOBAL-ONLY (2-15)
1720 --echo # - STATUS VARS THAT CAN'T BE AGGREGATED (2-17)
1721 --echo # ================================================================================
1722 select * from test.sanity
1723 where show_mode = "5.7"
1724 and source = "P_S.SESSION_STATUS"
1725 and upper(variable_name) not in (
1726 select upper(variable_name) from test.sanity
1727 where show_mode = "JUNK"
1728 and source = "NO AGGREGATE")
1729 and upper(variable_name) not in (
1730 select upper(variable_name) from test.sanity
1731 where (show_mode = "JUNK: GLOBAL-ONLY")
1732 and source = "I_S.SESSION_STATUS")
1733 and upper(variable_name) not in (
1734 select upper(variable_name) from test.sanity
1735 where show_mode = "5.7"
1736 and source = "P_S.STATUS_BY_USER")
1737 order by show_mode, source, variable_name;
1738
1739 --echo #
1740 --echo # ================================================================================
1741 --echo # TEST 18
1742 --echo # Present in 5.7 P_S.STATUS_BY_USER
1743 --echo # Missing in 5.7 P_S.SESSION_STATUS (2-10)
1744 --echo # ================================================================================
1745 select * from test.sanity
1746 where show_mode = "5.7"
1747 and source = "P_S.STATUS_BY_USER"
1748 and upper(variable_name) not in (
1749 select upper(variable_name) from test.sanity
1750 where show_mode = "5.7"
1751 and source = "P_S.SESSION_STATUS")
1752 order by show_mode, source, variable_name;
1753
1754 --echo #
1755 --echo # ================================================================================
1756 --echo # TEST 19
1757 --echo # KNOWN STATUS VARS THAT CAN'T BE AGGREGATED (2-17)
1758 --echo # Status variables that should NOT be present in 5.7 P_S.STATUS_BY_USER
1759 --echo # ================================================================================
1760 select * from performance_schema.status_by_user
1761 where upper(variable_name) in (
1762 select upper(variable_name) from test.sanity
1763 where show_mode = "JUNK"
1764 and source = "NO AGGREGATE")
1765 order by variable_name;
1766
1767 --echo #
1768 --echo # ================================================================================
1769 --echo # TEST 20
1770 --echo # Present in 5.7 P_S.SESSION_STATUS (2-10)
1771 --echo # Missing in 5.7 P_S.STATUS_BY_HOST
1772 --echo # EXPECT NOTHING AFTER REMOVING
1773 --echo # - KNOWN GLOBAL-ONLY (2-15)
1774 --echo # - STATUS VARS THAT CAN'T BE AGGREGATED (2-17)
1775 --echo # ================================================================================
1776 select * from test.sanity
1777 where show_mode = "5.7"
1778 and source = "P_S.SESSION_STATUS"
1779 and upper(variable_name) not in (
1780 select upper(variable_name) from test.sanity
1781 where show_mode = "JUNK"
1782 and source = "NO AGGREGATE")
1783 and upper(variable_name) not in (
1784 select upper(variable_name) from test.sanity
1785 where (show_mode = "JUNK: GLOBAL-ONLY")
1786 and source = "I_S.SESSION_STATUS")
1787 and upper(variable_name) not in (
1788 select upper(variable_name) from test.sanity
1789 where show_mode = "5.7"
1790 and source = "P_S.STATUS_BY_HOST")
1791 order by show_mode, source, variable_name;
1792
1793 --echo #
1794 --echo # ================================================================================
1795 --echo # TEST 21
1796 --echo # Present in 5.7 P_S.STATUS_BY_HOST
1797 --echo # Missing in 5.7 P_S.SESSION_STATUS (2-10)
1798 --echo # ================================================================================
1799 select * from test.sanity
1800 where show_mode = "5.7"
1801 and source = "P_S.STATUS_BY_HOST"
1802 and upper(variable_name) not in (
1803 select upper(variable_name) from test.sanity
1804 where show_mode = "5.7"
1805 and source = "P_S.SESSION_STATUS")
1806 order by show_mode, source, variable_name;
1807
1808 --echo #
1809 --echo # ================================================================================
1810 --echo # TEST 22
1811 --echo # KNOWN STATUS VARS THAT CAN'T BE AGGREGATED (2-17)
1812 --echo # Status variables that should NOT be present in 5.7 P_S.STATUS_BY_HOST
1813 --echo # ================================================================================
1814 select * from performance_schema.status_by_host
1815 where upper(variable_name) in (
1816 select upper(variable_name) from test.sanity
1817 where show_mode = "JUNK"
1818 and source = "NO AGGREGATE")
1819 order by variable_name;
1820
1821 --echo #
1822 --echo # ================================================================================
1823 --echo # CLEAN UP
1824 --echo # ================================================================================
1825 set @@global.show_compatibility_56 = @show_compatibility_56_save;
1826 drop table test.sanity;
1827
1828