Debian Codegraph @

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

raw
1 set completion_type=CHAIN;
2 set global low_priority_updates=1;
3 install soname 'sql_errlog';
4 select * from information_schema.system_variables
5 where variable_name in (
6 'completion_type', #session!=global, origin=compile-time
7 'low_priority_updates', #global!=default, origin=sql
8 'column_compression_threshold', #origin=command-line
9 'plugin_maturity', #origin=config
10 'sql_error_log_rate', #plugin, origin=command-line
11 'sql_error_log_rotations' #plugin, origin=config
12 )
13 order by variable_name;
14 VARIABLE_NAME COLUMN_COMPRESSION_THRESHOLD
15 SESSION_VALUE 120
16 GLOBAL_VALUE 120
17 GLOBAL_VALUE_ORIGIN COMMAND-LINE
18 DEFAULT_VALUE 100
19 VARIABLE_SCOPE SESSION
20 VARIABLE_TYPE INT UNSIGNED
21 VARIABLE_COMMENT Minimum column data length eligible for compression
22 NUMERIC_MIN_VALUE 0
23 NUMERIC_MAX_VALUE 4294967295
24 NUMERIC_BLOCK_SIZE 1
25 ENUM_VALUE_LIST NULL
26 READ_ONLY NO
27 COMMAND_LINE_ARGUMENT REQUIRED
28 GLOBAL_VALUE_PATH NULL
29 VARIABLE_NAME COMPLETION_TYPE
30 SESSION_VALUE CHAIN
31 GLOBAL_VALUE NO_CHAIN
32 GLOBAL_VALUE_ORIGIN COMPILE-TIME
33 DEFAULT_VALUE NO_CHAIN
34 VARIABLE_SCOPE SESSION
35 VARIABLE_TYPE ENUM
36 VARIABLE_COMMENT The transaction completion type
37 NUMERIC_MIN_VALUE NULL
38 NUMERIC_MAX_VALUE NULL
39 NUMERIC_BLOCK_SIZE NULL
40 ENUM_VALUE_LIST NO_CHAIN,CHAIN,RELEASE
41 READ_ONLY NO
42 COMMAND_LINE_ARGUMENT REQUIRED
43 GLOBAL_VALUE_PATH NULL
44 VARIABLE_NAME LOW_PRIORITY_UPDATES
45 SESSION_VALUE OFF
46 GLOBAL_VALUE ON
47 GLOBAL_VALUE_ORIGIN SQL
48 DEFAULT_VALUE OFF
49 VARIABLE_SCOPE SESSION
50 VARIABLE_TYPE BOOLEAN
51 VARIABLE_COMMENT INSERTvar/UPDATE has lower priority than selects
52 NUMERIC_MIN_VALUE NULL
53 NUMERIC_MAX_VALUE NULL
54 NUMERIC_BLOCK_SIZE NULL
55 ENUM_VALUE_LIST OFF,ON
56 READ_ONLY NO
57 COMMAND_LINE_ARGUMENT OPTIONAL
58 GLOBAL_VALUE_PATH NULL
59 VARIABLE_NAME PLUGIN_MATURITY
60 SESSION_VALUE NULL
61 GLOBAL_VALUE alpha
62 GLOBAL_VALUE_ORIGIN CONFIG
63 DEFAULT_VALUE gamma
64 VARIABLE_SCOPE GLOBAL
65 VARIABLE_TYPE ENUM
66 VARIABLE_COMMENT The lowest desirable plugin maturity. Plugins less mature than that will not be installed or loaded
67 NUMERIC_MIN_VALUE NULL
68 NUMERIC_MAX_VALUE NULL
69 NUMERIC_BLOCK_SIZE NULL
70 ENUM_VALUE_LIST unknown,experimental,alpha,beta,gamma,stable
71 READ_ONLY YES
72 COMMAND_LINE_ARGUMENT REQUIRED
73 GLOBAL_VALUE_PATH var/my.cnf
74 VARIABLE_NAME SQL_ERROR_LOG_RATE
75 SESSION_VALUE NULL
76 GLOBAL_VALUE 100
77 GLOBAL_VALUE_ORIGIN COMMAND-LINE
78 DEFAULT_VALUE 1
79 VARIABLE_SCOPE GLOBAL
80 VARIABLE_TYPE INT UNSIGNED
81 VARIABLE_COMMENT Sampling rate. If set to 0(zero), the logging is disabled
82 NUMERIC_MIN_VALUE 0
83 NUMERIC_MAX_VALUE 1000000
84 NUMERIC_BLOCK_SIZE 1
85 ENUM_VALUE_LIST NULL
86 READ_ONLY NO
87 COMMAND_LINE_ARGUMENT REQUIRED
88 GLOBAL_VALUE_PATH NULL
89 VARIABLE_NAME SQL_ERROR_LOG_ROTATIONS
90 SESSION_VALUE NULL
91 GLOBAL_VALUE 5
92 GLOBAL_VALUE_ORIGIN CONFIG
93 DEFAULT_VALUE 9
94 VARIABLE_SCOPE GLOBAL
95 VARIABLE_TYPE INT UNSIGNED
96 VARIABLE_COMMENT Number of rotations before log is removed
97 NUMERIC_MIN_VALUE 1
98 NUMERIC_MAX_VALUE 999
99 NUMERIC_BLOCK_SIZE 1
100 ENUM_VALUE_LIST NULL
101 READ_ONLY YES
102 COMMAND_LINE_ARGUMENT REQUIRED
103 GLOBAL_VALUE_PATH var/my.cnf
104 create user foo@localhost;
105 connect foo,localhost,foo;
106 select global_value_path from information_schema.system_variables where variable_name='plugin_maturity';
107 global_value_path NULL
108 connection default;
109 select global_value_path from information_schema.system_variables where variable_name='plugin_maturity';
110 global_value_path var/my.cnf
111 disconnect foo;
112 drop user foo@localhost;
113 set global low_priority_updates=default;
114 uninstall soname 'sql_errlog';