Debian Codegraph @

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

raw
1 # On windows, the socket instrumentation calls are different
2 --source include/not_windows.inc
3
4 # Save the initial number of concurrent sessions
5 --source include/count_sessions.inc
6
7 connect (mon_con,localhost,root,,,,,SSL);
8
9 update performance_schema.threads
10 set INSTRUMENTED = "NO" where THREAD_ID = PS_CURRENT_THREAD_ID();
11
12 update performance_schema.setup_instruments
13 set enabled = "NO" where NAME like "wait/%";
14
15 update performance_schema.setup_instruments
16 set enabled = "YES" where NAME LIKE "wait/io/socket/%";
17
18 truncate performance_schema.events_waits_history_long;
19
20 connect (ssl_con,localhost,root,,,,,SSL);
21
22 --echo "========== SSL CONNECTED =========="
23
24 connection mon_con;
25 # Wait a bit to make sure the SSL session is blocked before statement 1
26 select sleep(1);
27 connection ssl_con;
28
29 let ssl_con_tid= `SELECT PS_CURRENT_THREAD_ID()`;
30
31 connection mon_con;
32 # Wait a bit to make sure the SSL session is blocked before statement 2
33 select sleep(1);
34 connection ssl_con;
35
36 --echo "========== SSL STATEMENT =========="
37
38 select "SSL statement";
39
40 connect (clear_con,localhost,root,,,,,);
41
42 --echo "========== CLEAR CONNECTED =========="
43
44 connection mon_con;
45 # Wait a bit to make sure the CLEAR session is blocked before statement 1
46 select sleep(1);
47 connection clear_con;
48
49 let clear_con_tid= `SELECT PS_CURRENT_THREAD_ID()`;
50
51 connection mon_con;
52 # Wait a bit to make sure the CLEAR session is blocked before statement 2
53 select sleep(1);
54 connection clear_con;
55
56 --echo "========== CLEAR STATEMENT =========="
57
58 select "CLEAR statement";
59
60 connection mon_con;
61
62 # Move script level variables ($) to server user variables (@),
63 # so that queries printed in the result log have a stable output.
64
65 --disable_query_log
66 eval set @clear_con_tid = $clear_con_tid;
67 eval set @ssl_con_tid = $ssl_con_tid;
68 --enable_query_log
69
70 --echo "========== CLEAR =========="
71
72 --replace_column 1 #
73 select THREAD_ID, NAME, CONNECTION_TYPE
74 from performance_schema.threads
75 where THREAD_ID = @clear_con_tid;
76
77 # This will print traffic from viosocket.cc only.
78
79 select EVENT_NAME,
80 left(SOURCE, locate(":", SOURCE)) as PRINT_SOURCE,
81 OBJECT_NAME, OPERATION,
82 (NUMBER_OF_BYTES >= 1) as PRINT_NUMBER_OF_BYTES
83 from performance_schema.events_waits_history_long
84 where (THREAD_ID = @clear_con_tid)
85 group by EVENT_NAME, PRINT_SOURCE, OBJECT_NAME, OPERATION, PRINT_NUMBER_OF_BYTES
86 order by EVENT_NAME, PRINT_SOURCE, OBJECT_NAME, OPERATION, PRINT_NUMBER_OF_BYTES;
87
88 --echo "========== SSL =========="
89
90 --replace_column 1 #
91 select THREAD_ID, NAME, CONNECTION_TYPE
92 from performance_schema.threads
93 where THREAD_ID = @ssl_con_tid;
94
95 # This will print traffic from viosocket.cc (connection handshake)
96 # and open_ssl (SSL).
97
98 select EVENT_NAME,
99 left(SOURCE, locate(":", SOURCE)) as PRINT_SOURCE,
100 OBJECT_NAME, OPERATION,
101 (NUMBER_OF_BYTES >= 1) as PRINT_NUMBER_OF_BYTES
102 from performance_schema.events_waits_history_long
103 where (THREAD_ID = @ssl_con_tid)
104 group by EVENT_NAME, PRINT_SOURCE, OBJECT_NAME, OPERATION, PRINT_NUMBER_OF_BYTES
105 order by EVENT_NAME, PRINT_SOURCE, OBJECT_NAME, OPERATION, PRINT_NUMBER_OF_BYTES;
106
107 connection default;
108 disconnect ssl_con;
109 disconnect clear_con;
110 disconnect mon_con;
111
112 update performance_schema.setup_instruments
113 set ENABLED = "yes" where NAME like "wait/%";
114
115 # Wait till all disconnects are completed
116 --source include/wait_until_count_sessions.inc
117
118 ## This test file is for testing encrypted communication only, not other
119 ## encryption routines that the SSL library happens to provide!