Debian Codegraph @

mysql-test/suite/sys_vars/r/admin_port_basic.result

raw
1 select @@global.admin_port;
2 @@global.admin_port
3 ADMIN_PORT
4 select @@session.admin_port;
5 ERROR HY000: Variable 'admin_port' is a GLOBAL variable
6 show global variables like 'admin_port';
7 Variable_name Value
8 admin_port ADMIN_PORT
9 show session variables like 'admin_port';
10 Variable_name Value
11 admin_port ADMIN_PORT
12 select * from performance_schema.global_variables where variable_name='admin_port';
13 VARIABLE_NAME VARIABLE_VALUE
14 admin_port ADMIN_PORT
15 select * from performance_schema.session_variables where variable_name='admin_port';
16 VARIABLE_NAME VARIABLE_VALUE
17 admin_port ADMIN_PORT
18 select variable_name, min_value, max_value from performance_schema.variables_info where variable_name='admin_port';
19 variable_name min_value max_value
20 admin_port 0 65535
21 set global admin_port=1000;
22 ERROR HY000: Variable 'admin_port' is a read only variable
23 set session admin_port=1000;
24 ERROR HY000: Variable 'admin_port' is a read only variable
25 set persist admin_port=1000;
26 ERROR HY000: Variable 'admin_port' is a read only variable
27 # restart: --skip-name-resolve --admin-address=127.0.0.1 --admin_port=ADMIN_PORT
28 select * from performance_schema.global_variables where variable_name='admin_port';
29 VARIABLE_NAME VARIABLE_VALUE
30 admin_port ADMIN_PORT
31 select * from performance_schema.session_variables where variable_name='admin_port';
32 VARIABLE_NAME VARIABLE_VALUE
33 admin_port ADMIN_PORT
34 # restart: --skip-name-resolve --admin_port=66000
35 SELECT @@admin_port;
36 @@admin_port
37 65535
38 # restart: --skip-name-resolve --admin_port=-1
39 call mtr.add_suppression("Warning.* option 'admin_port': value -1 adjusted to 0");
40 SELECT @@admin_port;
41 @@admin_port
42 33062
43 #
44 # Starting mysqld in the regular mode...
45 #
46 # restart