Debian Codegraph @

mysql-test/suite/x/t/performance_schema_unixsockets.test

raw
1 ## Tests detecting presence of xplugin objects in PERFORMANCE_SCHEMA.
2
3 ## Preamble
4 --source include/not_windows.inc
5 --source ../include/have_performance_schema_threads.inc
6
7 --source include/xplugin_preamble.inc
8 --source include/xplugin_create_user.inc
9
10 # Tests
11 --write_file $MYSQL_TMP_DIR/performance_schema_socket_num.xpl
12 -->quiet
13 -->macro check_xconnection_count %EXPECTED_NUM_OF_CONNECTIONS%
14 -->echo Verify [Checking if X Plugin reports %EXPECTED_NUM_OF_CONNECTIONS% connections]
15 -->wait_for %EXPECTED_NUM_OF_CONNECTIONS% SELECT count(*) as Num FROM performance_schema.socket_instances WHERE EVENT_NAME LIKE 'wait/io/socket/mysqlx/client_connection'
16 -->echo success
17 -->endmacro
18
19
20 -->varlet %CON_COUNTER% 1
21 -->callmacro check_xconnection_count %CON_COUNTER%
22
23 -->repeat 10
24 -->varinc %CON_COUNTER% 1
25 -->newsession NAME_%CON_COUNTER% x_root
26 -->callmacro check_xconnection_count %CON_COUNTER%
27 -->endrepeat
28
29 -->echo Verify [Peer addresses of all UNIX sockets should be set to '']
30 -->stmtsql SELECT count(*) as Num FROM performance_schema.socket_instances WHERE EVENT_NAME LIKE 'wait/io/socket/mysqlx/client_connection' AND LENGTH(IP)=0
31 -->recvtovar %NUM%
32 -->assert_eq %CON_COUNTER% %NUM%
33
34 -->echo Verify [Peer ports should be unique]
35 -->stmtsql SELECT count(*) as Num FROM performance_schema.socket_instances WHERE EVENT_NAME LIKE 'wait/io/socket/mysqlx/client_connection' AND PORT=0
36 -->recvtovar %NUM%
37 -->assert_eq %CON_COUNTER% %NUM%
38
39 # Synchronize with X Plugin
40 -->wait_for 1 SELECT 1 FROM performance_schema.socket_instances WHERE EVENT_NAME LIKE 'wait/io/socket/mysqlx/client_connection' AND `STATE` = 'IDLE'
41
42 -->echo Check if we have connection ACTIVE and IDLE state
43 -->stmtsql SELECT `STATE` FROM performance_schema.socket_instances WHERE EVENT_NAME LIKE 'wait/io/socket/mysqlx/client_connection' GROUP BY `STATE` ORDER BY `STATE`
44 -->recvresult
45
46 -->repeat 10
47 -->echo switched to session NAME_%CON_COUNTER%
48 -->setsession NAME_%CON_COUNTER%
49 -->closesession
50 -->varinc %CON_COUNTER% -1
51 -->endrepeat
52
53 -->echo switched to session default
54 -->setsession
55 -->callmacro check_xconnection_count %CON_COUNTER%
56 -->noquiet
57 EOF
58
59 --write_file $MYSQL_TMP_DIR/performance_schema_socket_io_stats.xpl
60
61 -->macro This_socket_oi_begin
62 -->quiet
63 -->noquery_result
64 SELECT THREAD_ID into @my_tid FROM `performance_schema`.`threads` WHERE PROCESSLIST_ID = connection_id();
65 SELECT OBJECT_INSTANCE_BEGIN into @my_oib FROM `performance_schema`.`socket_instances` WHERE THREAD_ID=@my_tid;
66 -->noquiet
67 -->query_result
68 -->endmacro
69
70 -->macro By_name_oi_begin %EVENT_NAME%
71 -->noquery_result
72 -->quiet
73 SELECT MAX(OBJECT_INSTANCE_BEGIN) into @my_oib FROM `performance_schema`.`socket_summary_by_instance` WHERE `EVENT_NAME` LIKE %EVENT_NAME%;
74 -->noquiet
75 -->query_result
76 -->endmacro
77
78
79 -->macro Verify_socket_increase %VARI% %COLUMN%
80 -->quiet
81 # ENSURE THAT SOCKET STATS WERE INCREMENTED
82 # BY SENDING DATA TO THE SOCKET
83 -->stmtsql SELECT 1
84 -->recvresult be-quiet
85 #MAKE THE CHECK
86 # Get %COLUMN% counter at latest created connection (`OBJECT_INSTANCE_BEGIN`)
87 -->stmtsql SELECT %COLUMN% FROM `performance_schema`.`socket_summary_by_instance` WHERE OBJECT_INSTANCE_BEGIN=@my_oib
88 -->recvtovar %TMP%
89 -->echo Verify [Checking if data in column %COLUMN% had increased]
90 -->assert_gt %TMP% %VARI%
91 -->varlet %VARI% %TMP%
92 -->noquiet
93 -->endmacro
94
95 # This function doesn't get latest entry !
96 -->macro Verify_socket_greater_or_equal %VARI% %COLUMN% %TABLE%
97 -->quiet
98 # ENSURE THAT SOCKET STATS WERE INCREMENTED
99 # BY SENDING DATA TO THE SOCKET
100 -->stmtsql SELECT 1
101 -->recvresult be-quiet
102 #MAKE THE CHECK
103 -->stmtsql SELECT %COLUMN% FROM `performance_schema`.%TABLE% WHERE OBJECT_INSTANCE_BEGIN=@my_oib
104 -->recvtovar %TMP%
105 -->echo Verify [Checking if data in column %COLUMN% had increased]
106 -->assert_ge %TMP% %VARI%
107 -->varlet %VARI% %TMP%
108 -->noquiet
109 -->endmacro
110
111 -->macro Verify_object_greater_or_equal %VARI% %COLUMN% %TABLE% %EVENT_NAME%
112 -->quiet
113 # ENSURE THAT SOCKET STATS WERE INCREMENTED
114 # BY SENDING DATA TO THE SOCKET
115 -->stmtsql SELECT 1
116 -->recvresult be-quiet
117 #MAKE THE CHECK
118 -->stmtsql SELECT %COLUMN% FROM `performance_schema`.%TABLE% WHERE `EVENT_NAME` LIKE %EVENT_NAME%;
119 -->recvtovar %TMP%
120 -->echo Verify [Checking if data in column %COLUMN% had increased]
121 -->assert_ge %TMP% %VARI%
122 -->varlet %VARI% %TMP%
123 -->noquiet
124 -->endmacro
125
126 -->callmacro This_socket_oi_begin
127
128 -->varlet %READ_CNT% 0
129 -->callmacro Verify_socket_increase %READ_CNT% `COUNT_READ`
130 -->callmacro Verify_socket_increase %READ_CNT% `COUNT_READ`
131 -->callmacro Verify_socket_increase %READ_CNT% `COUNT_READ`
132 -->callmacro Verify_socket_increase %READ_CNT% `COUNT_READ`
133
134 -->varlet %WRITE_CNT% 0
135 -->callmacro Verify_socket_increase %WRITE_CNT% `COUNT_WRITE`
136 -->callmacro Verify_socket_increase %WRITE_CNT% `COUNT_WRITE`
137 -->callmacro Verify_socket_increase %WRITE_CNT% `COUNT_WRITE`
138 -->callmacro Verify_socket_increase %WRITE_CNT% `COUNT_WRITE`
139
140 -->varlet %READ_BYTES1% 0
141 -->callmacro Verify_socket_increase %READ_BYTES1% `SUM_NUMBER_OF_BYTES_READ`
142 -->callmacro Verify_socket_increase %READ_BYTES1% `SUM_NUMBER_OF_BYTES_READ`
143 -->callmacro Verify_socket_increase %READ_BYTES1% `SUM_NUMBER_OF_BYTES_READ`
144 -->callmacro Verify_socket_increase %READ_BYTES1% `SUM_NUMBER_OF_BYTES_READ`
145
146 -->varlet %WRITE_BYTES% 0
147 -->callmacro Verify_socket_increase %WRITE_BYTES% `SUM_NUMBER_OF_BYTES_WRITE`
148 -->callmacro Verify_socket_increase %WRITE_BYTES% `SUM_NUMBER_OF_BYTES_WRITE`
149 -->callmacro Verify_socket_increase %WRITE_BYTES% `SUM_NUMBER_OF_BYTES_WRITE`
150 -->callmacro Verify_socket_increase %WRITE_BYTES% `SUM_NUMBER_OF_BYTES_WRITE`
151
152 -->varlet %READ_TIME% 0
153 -->callmacro Verify_socket_greater_or_equal %READ_TIME% `SUM_TIMER_READ` `socket_summary_by_instance`
154 -->callmacro Verify_socket_greater_or_equal %READ_TIME% `SUM_TIMER_READ` `socket_summary_by_instance`
155 -->callmacro Verify_socket_greater_or_equal %READ_TIME% `SUM_TIMER_READ` `socket_summary_by_instance`
156 -->callmacro Verify_socket_greater_or_equal %READ_TIME% `SUM_TIMER_READ` `socket_summary_by_instance`
157
158 -->varlet %WRITE_TIME% 0
159 -->callmacro Verify_socket_greater_or_equal %WRITE_TIME% `SUM_TIMER_WRITE` `socket_summary_by_instance`
160 -->callmacro Verify_socket_greater_or_equal %WRITE_TIME% `SUM_TIMER_WRITE` `socket_summary_by_instance`
161 -->callmacro Verify_socket_greater_or_equal %WRITE_TIME% `SUM_TIMER_WRITE` `socket_summary_by_instance`
162 -->callmacro Verify_socket_greater_or_equal %WRITE_TIME% `SUM_TIMER_WRITE` `socket_summary_by_instance`
163
164 # Verify `SUM_NUMBER_OF_BYTES_READ` counter on new connection
165 -->newsession second_session x_root
166 -->callmacro This_socket_oi_begin
167 -->varlet %READ_BYTES2% 0
168 -->repeat 40
169 -->callmacro Verify_socket_increase %READ_BYTES2% `SUM_NUMBER_OF_BYTES_READ`
170 -->endrepeat
171
172 # Make connection and verify that accept counter was incremented
173 -->varlet %ACCETP_COUNT% 0
174 -->repeat 40
175 -->newsession temporary_connection x_root
176 -->callmacro By_name_oi_begin 'wait/io/socket/mysqlx/unix_socket'
177 -->callmacro Verify_socket_increase %ACCETP_COUNT% `COUNT_MISC`
178 -->closesession
179 -->endrepeat
180
181
182 -->varlet %READ_BYTES% 0
183 -->varinc %READ_BYTES% %READ_BYTES1%
184 -->varinc %READ_BYTES% %READ_BYTES2%
185
186 -->echo Verify summary table
187 -->callmacro Verify_object_greater_or_equal %READ_BYTES% `SUM_NUMBER_OF_BYTES_READ` `socket_summary_by_event_name` 'wait/io/socket/mysqlx/client_connection'
188 EOF
189
190 --echo No socket from X Plugin should be reported
191 --let $XPlugin_socket_count_when_no_Xconnection= query_get_value(SELECT count(*) as Num FROM performance_schema.socket_instances WHERE EVENT_NAME LIKE 'wait/io/socket/mysqlx/client_connection', Num, 1)
192
193 if ( $XPlugin_socket_count_when_no_Xconnection != 0) {
194 --echo got $XPlugin_socket_count_when_no_Xconnection active connections
195 --die Reported size should be zero
196 }
197
198
199 --echo Check the IP and PORT of UNIX socket
200 --let $XPlugin_ip= query_get_value(SELECT * FROM performance_schema.socket_instances WHERE EVENT_NAME LIKE 'wait/io/socket/mysqlx/unix_socket' and STATE='ACTIVE', IP, 1)
201 --let $XPlugin_port= query_get_value(SELECT * FROM performance_schema.socket_instances WHERE EVENT_NAME LIKE 'wait/io/socket/mysqlx/unix_socket', PORT, 1)
202
203 if ($XPlugin_ip != "") {
204 --echo X Plugin UNIX socket is set to $XPlugin_ip
205 --die X Plugins UNIX socket should be set to ''
206 }
207
208 --let $XPlugin_port_expected= 0
209
210 if ( $XPlugin_port != $XPlugin_port_expected) {
211 --echo X Plugin UNIX socket port filed is set to $XPlugin_port, was expecting $XPlugin_port_expected
212 --die X Plugin UNIX sockets port has a wrong value
213 }
214
215 --echo Check if clinet_socket are reported in proper way in PFS
216 --exec $MYSQLXTEST -ux_root --password='' --socket=$MASTER_X_MYSOCK --file=$MYSQL_TMP_DIR/performance_schema_socket_num.xpl 2>&1
217
218 --echo No socket should be reported by X Plugin
219 let $wait_condition=
220 SELECT count(*)= 0 as Num FROM performance_schema.socket_instances WHERE EVENT_NAME LIKE 'wait/io/socket/mysqlx/client_connection';
221 --source include/wait_condition_or_abort.inc
222
223 --exec $MYSQLXTEST -ux_root --password='' --socket=$MASTER_X_MYSOCK --file=$MYSQL_TMP_DIR/performance_schema_socket_io_stats.xpl 2>&1
224
225 ## Cleanup
226 --source ../include/xplugin_cleanup.inc