| 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/%"; |