Debian Codegraph @

mysql-test/suite/federated/t/telemetry_traces_server.test

raw
1 ################################################################################
2 # Test case to test telemetry tracing service functionality using test component
3 # within the context of federated storage engine. We are validating that the requests
4 # being passed to remote server are being processed by telemetry callbacks.
5 #
6 # This test script:
7 # - Installs the query_attributes and test_server_telemetry components.
8 # - Executes different statements and verifies that correct tracing action happened
9 ################################################################################
10
11 --source include/have_server_telemetry_traces.inc
12 --source include/have_debug.inc
13 --source include/not_parallel.inc
14 --source include/no_ps_protocol.inc
15
16 source suite/federated/include/federated.inc;
17
18 # connect to remote.
19 connection slave;
20 --disable_warnings
21 DROP TABLE IF EXISTS federated.t1;
22 --enable_warnings
23
24 CREATE TABLE federated.t1 (
25 a int
26 );
27 INSERT INTO federated.t1 (a) VALUES (42);
28
29 # Install required components.
30 INSTALL COMPONENT 'file://component_query_attributes';
31 INSTALL COMPONENT 'file://component_test_server_telemetry_traces';
32
33 --echo # check initial telemetry session refcount (should be 1)
34 SELECT variable_value FROM performance_schema.global_status WHERE variable_name="test_server_telemetry_traces.live_sessions";
35
36 # connect to local.
37 connection master;
38
39 --echo # check telemetry session refcount on master server (variable should not exist)
40 SELECT variable_value FROM performance_schema.global_status WHERE variable_name="test_server_telemetry_traces.live_sessions";
41
42 --replace_result $SLAVE_MYPORT SLAVE_PORT
43 eval CREATE SERVER fedlink
44 FOREIGN DATA WRAPPER mysql
45 OPTIONS (
46 HOST '127.0.0.1',
47 PORT $SLAVE_MYPORT,
48 USER 'root',
49 PASSWORD '',
50 DATABASE 'federated');
51
52 --disable_warnings
53 DROP TABLE IF EXISTS federated.t1;
54 --enable_warnings
55
56 --replace_result $SLAVE_MYPORT SLAVE_PORT
57 eval CREATE TABLE federated.t1 (
58 a int
59 ) ENGINE="FEDERATED"
60 CONNECTION='fedlink/t1';
61
62 # test
63 SELECT * FROM federated.t1;
64
65 # cleanup remote
66 connection slave;
67
68 --echo # check telemetry session refcount before component uninstall (should be 2)
69 SELECT variable_value FROM performance_schema.global_status WHERE variable_name="test_server_telemetry_traces.live_sessions";
70
71 --send UNINSTALL COMPONENT 'file://component_test_server_telemetry_traces';
72 --sleep 0.1
73 connection master;
74 SELECT * FROM federated.t1;
75 connection slave;
76 --reap
77 UNINSTALL COMPONENT 'file://component_query_attributes';
78
79 let $MYSQLD_DATADIR= `select @@datadir`;
80 --echo Component logs:
81 cat_file $MYSQLD_DATADIR/test_server_telemetry_traces_component.log;
82 remove_file $MYSQLD_DATADIR/test_server_telemetry_traces_component.log;
83
84 # connect to local.
85 connection master;
86
87 # cleanup test
88 --disable_warnings
89 DROP TABLE IF EXISTS federated.t1;
90 --enable_warnings
91
92 # cleanup
93 DROP SERVER fedlink;
94 source suite/federated/include/federated_cleanup.inc;