| 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! |