Debian Codegraph @

mysql-test/suite/x/r/read_timeout.result

raw
1 Preamble
2 SET GLOBAL mysqlx_read_timeout = 5;
3 CREATE USER temp_user@localhost
4 IDENTIFIED WITH 'mysql_native_password' BY 'auth_string';
5 GRANT ALL ON *.* TO temp_user@localhost;
6 #
7 # Run the test without SSL
8 #
9 RUN SELECT CONNECTION_TYPE from performance_schema.threads where processlist_command='Query'
10 CONNECTION_TYPE
11 TCP/IP
12 0 rows affected
13 RUN SELECT USER()
14 USER()
15 temp_user@localhost
16 0 rows affected
17 RUN SHOW STATUS LIKE 'Mysqlx_ssl_active'
18 Variable_name Value
19 Mysqlx_ssl_active OFF
20 0 rows affected
21 Sending 4 bytes raw data...
22 Mysqlx.Notice.Frame {
23 type: 1
24 payload: "Mysqlx.Notice.Warning { level: ERROR\ncode: 1810\nmsg: \"IO Read error: read_timeout exceeded\"\n }"
25 }
26
27 Server disconnected
28 ok
29 #
30 # Run the test with SSL
31 #
32 RUN SELECT CONNECTION_TYPE from performance_schema.threads where processlist_command='Query'
33 CONNECTION_TYPE
34 SSL/TLS
35 0 rows affected
36 RUN SELECT USER()
37 USER()
38 temp_user@localhost
39 0 rows affected
40 RUN SHOW STATUS LIKE 'Mysqlx_ssl_active'
41 Variable_name Value
42 Mysqlx_ssl_active ON
43 0 rows affected
44 Sending 4 bytes raw data...
45 Mysqlx.Notice.Frame {
46 type: 1
47 payload: "Mysqlx.Notice.Warning { level: ERROR\ncode: 1810\nmsg: \"IO Read error: read_timeout exceeded\"\n }"
48 }
49
50 Server disconnected
51 ok
52 SET GLOBAL mysqlx_read_timeout = DEFAULT;
53 DROP USER temp_user@localhost;