Debian Codegraph @

mysql-test/suite/service_status_var_registration/t/status_var_service_3_comp.test

raw
1 # Test for registration of status variables by 3 components.
2 # Vars are named with "<component name>.<var name>".
3 # One var is without <component name>: Working.
4
5 --source ../include/have_component_test_status_var_service.inc
6
7 INSTALL COMPONENT "file://component_test_status_var_service_int";
8 SHOW STATUS WHERE VARIABLE_NAME LIKE 'int_var%';
9 SHOW STATUS WHERE VARIABLE_NAME LIKE 'test_int_component.int_variable';
10 SHOW STATUS WHERE VARIABLE_NAME LIKE 'test_int_component.int_variable_value';
11
12 INSTALL COMPONENT "file://component_test_status_var_service_str";
13 SHOW SESSION STATUS WHERE VARIABLE_NAME LIKE 'test_component.int_variable_value';
14 SHOW STATUS WHERE VARIABLE_NAME LIKE 'test_str_component.str_variable';
15
16 INSTALL COMPONENT "file://component_test_status_var_service";
17 SHOW STATUS WHERE VARIABLE_NAME LIKE 'test_component.int_variable';
18
19 SELECT * FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE '%component%';
20
21 UNINSTALL COMPONENT "file://component_test_status_var_service";
22 SELECT * FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE '%component%';
23 UNINSTALL COMPONENT "file://component_test_status_var_service_int";
24 SELECT * FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE '%component%';
25 UNINSTALL COMPONENT "file://component_test_status_var_service_str";
26 SELECT * FROM performance_schema.global_status WHERE VARIABLE_NAME LIKE '%component%';
27
28 # Write the test results in "test_component_status_var_service.log" into the
29 # result file of this test
30 --echo ########## test_component_status_var_service.log:
31 let $MYSQLD_DATADIR= `select @@datadir`;
32 cat_file $MYSQLD_DATADIR/test_component_status_var_service.log;
33 remove_file $MYSQLD_DATADIR/test_component_status_var_service.log;
34 --echo ########## test_component_status_var_service_int.log:
35 let $MYSQLD_DATADIR= `select @@datadir`;
36 cat_file $MYSQLD_DATADIR/test_component_status_var_service_int.log;
37 remove_file $MYSQLD_DATADIR/test_component_status_var_service_int.log;
38 --echo ########## test_component_status_var_service_str.log:
39 let $MYSQLD_DATADIR= `select @@datadir`;
40 cat_file $MYSQLD_DATADIR/test_component_status_var_service_str.log;
41 remove_file $MYSQLD_DATADIR/test_component_status_var_service_str.log;