Debian Codegraph @

mysql-test/suite/perfschema/r/ssl.result

raw
1 update performance_schema.threads
2 set INSTRUMENTED = "NO" where THREAD_ID = PS_CURRENT_THREAD_ID();
3 update performance_schema.setup_instruments
4 set enabled = "NO" where NAME like "wait/%";
5 update performance_schema.setup_instruments
6 set enabled = "YES" where NAME LIKE "wait/io/socket/%";
7 truncate performance_schema.events_waits_history_long;
8 "========== SSL CONNECTED =========="
9 select sleep(1);
10 sleep(1)
11 0
12 select sleep(1);
13 sleep(1)
14 0
15 "========== SSL STATEMENT =========="
16 select "SSL statement";
17 SSL statement
18 SSL statement
19 "========== CLEAR CONNECTED =========="
20 select sleep(1);
21 sleep(1)
22 0
23 select sleep(1);
24 sleep(1)
25 0
26 "========== CLEAR STATEMENT =========="
27 select "CLEAR statement";
28 CLEAR statement
29 CLEAR statement
30 "========== CLEAR =========="
31 select THREAD_ID, NAME, CONNECTION_TYPE
32 from performance_schema.threads
33 where THREAD_ID = @clear_con_tid;
34 THREAD_ID NAME CONNECTION_TYPE
35 # thread/sql/one_connection Socket
36 select EVENT_NAME,
37 left(SOURCE, locate(":", SOURCE)) as PRINT_SOURCE,
38 OBJECT_NAME, OPERATION,
39 (NUMBER_OF_BYTES >= 1) as PRINT_NUMBER_OF_BYTES
40 from performance_schema.events_waits_history_long
41 where (THREAD_ID = @clear_con_tid)
42 group by EVENT_NAME, PRINT_SOURCE, OBJECT_NAME, OPERATION, PRINT_NUMBER_OF_BYTES
43 order by EVENT_NAME, PRINT_SOURCE, OBJECT_NAME, OPERATION, PRINT_NUMBER_OF_BYTES;
44 EVENT_NAME PRINT_SOURCE OBJECT_NAME OPERATION PRINT_NUMBER_OF_BYTES
45 idle init_net_server_extension.cc: NULL idle NULL
46 wait/io/socket/sql/client_connection viosocket.cc: :0 opt NULL
47 wait/io/socket/sql/client_connection viosocket.cc: :0 recv 0
48 wait/io/socket/sql/client_connection viosocket.cc: :0 recv 1
49 wait/io/socket/sql/client_connection viosocket.cc: :0 select NULL
50 wait/io/socket/sql/client_connection viosocket.cc: :0 send 1
51 "========== SSL =========="
52 select THREAD_ID, NAME, CONNECTION_TYPE
53 from performance_schema.threads
54 where THREAD_ID = @ssl_con_tid;
55 THREAD_ID NAME CONNECTION_TYPE
56 # thread/sql/one_connection SSL/TLS
57 select EVENT_NAME,
58 left(SOURCE, locate(":", SOURCE)) as PRINT_SOURCE,
59 OBJECT_NAME, OPERATION,
60 (NUMBER_OF_BYTES >= 1) as PRINT_NUMBER_OF_BYTES
61 from performance_schema.events_waits_history_long
62 where (THREAD_ID = @ssl_con_tid)
63 group by EVENT_NAME, PRINT_SOURCE, OBJECT_NAME, OPERATION, PRINT_NUMBER_OF_BYTES
64 order by EVENT_NAME, PRINT_SOURCE, OBJECT_NAME, OPERATION, PRINT_NUMBER_OF_BYTES;
65 EVENT_NAME PRINT_SOURCE OBJECT_NAME OPERATION PRINT_NUMBER_OF_BYTES
66 idle init_net_server_extension.cc: NULL idle NULL
67 wait/io/socket/sql/client_connection open_ssl: :0 recv 0
68 wait/io/socket/sql/client_connection open_ssl: :0 recv 1
69 wait/io/socket/sql/client_connection open_ssl: :0 send 1
70 wait/io/socket/sql/client_connection viosocket.cc: :0 opt NULL
71 wait/io/socket/sql/client_connection viosocket.cc: :0 recv 0
72 wait/io/socket/sql/client_connection viosocket.cc: :0 recv 1
73 wait/io/socket/sql/client_connection viosocket.cc: :0 select NULL
74 wait/io/socket/sql/client_connection viosocket.cc: :0 send 1
75 update performance_schema.setup_instruments
76 set ENABLED = "yes" where NAME like "wait/%";