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