Debian Codegraph @

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

raw
1 select VARIABLE_NAME, SESSION_VALUE, DEFAULT_VALUE, VARIABLE_SCOPE, VARIABLE_TYPE, VARIABLE_COMMENT, NUMERIC_MIN_VALUE, NUMERIC_MAX_VALUE, NUMERIC_BLOCK_SIZE, ENUM_VALUE_LIST, READ_ONLY, COMMAND_LINE_ARGUMENT from information_schema.system_variables
2 where variable_name like 'aria%'
3 order by variable_name;
4 VARIABLE_NAME ARIA_BLOCK_SIZE
5 SESSION_VALUE NULL
6 DEFAULT_VALUE 8192
7 VARIABLE_SCOPE GLOBAL
8 VARIABLE_TYPE BIGINT UNSIGNED
9 VARIABLE_COMMENT Block size to be used for Aria index pages
10 NUMERIC_MIN_VALUE 4096
11 NUMERIC_MAX_VALUE 32768
12 NUMERIC_BLOCK_SIZE 1024
13 ENUM_VALUE_LIST NULL
14 READ_ONLY YES
15 COMMAND_LINE_ARGUMENT REQUIRED
16 VARIABLE_NAME ARIA_CHECKPOINT_INTERVAL
17 SESSION_VALUE NULL
18 DEFAULT_VALUE 30
19 VARIABLE_SCOPE GLOBAL
20 VARIABLE_TYPE BIGINT UNSIGNED
21 VARIABLE_COMMENT Interval between tries to do an automatic checkpoints. In seconds; 0 means 'no automatic checkpoints' which makes sense only for testing
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 VARIABLE_NAME ARIA_CHECKPOINT_LOG_ACTIVITY
29 SESSION_VALUE NULL
30 DEFAULT_VALUE 1048576
31 VARIABLE_SCOPE GLOBAL
32 VARIABLE_TYPE BIGINT UNSIGNED
33 VARIABLE_COMMENT Number of bytes that the transaction log has to grow between checkpoints before a new checkpoint is written to the log
34 NUMERIC_MIN_VALUE 0
35 NUMERIC_MAX_VALUE 4294967295
36 NUMERIC_BLOCK_SIZE 1
37 ENUM_VALUE_LIST NULL
38 READ_ONLY NO
39 COMMAND_LINE_ARGUMENT REQUIRED
40 VARIABLE_NAME ARIA_ENCRYPT_TABLES
41 SESSION_VALUE NULL
42 DEFAULT_VALUE OFF
43 VARIABLE_SCOPE GLOBAL
44 VARIABLE_TYPE BOOLEAN
45 VARIABLE_COMMENT Encrypt tables (only for tables with ROW_FORMAT=PAGE (default) and not FIXED/DYNAMIC)
46 NUMERIC_MIN_VALUE NULL
47 NUMERIC_MAX_VALUE NULL
48 NUMERIC_BLOCK_SIZE NULL
49 ENUM_VALUE_LIST OFF,ON
50 READ_ONLY NO
51 COMMAND_LINE_ARGUMENT OPTIONAL
52 VARIABLE_NAME ARIA_FORCE_START_AFTER_RECOVERY_FAILURES
53 SESSION_VALUE NULL
54 DEFAULT_VALUE 0
55 VARIABLE_SCOPE GLOBAL
56 VARIABLE_TYPE BIGINT UNSIGNED
57 VARIABLE_COMMENT Number of consecutive log recovery failures after which logs will be automatically deleted to cure the problem; 0 (the default) disables the feature
58 NUMERIC_MIN_VALUE 0
59 NUMERIC_MAX_VALUE 255
60 NUMERIC_BLOCK_SIZE 1
61 ENUM_VALUE_LIST NULL
62 READ_ONLY YES
63 COMMAND_LINE_ARGUMENT REQUIRED
64 VARIABLE_NAME ARIA_GROUP_COMMIT
65 SESSION_VALUE NULL
66 DEFAULT_VALUE none
67 VARIABLE_SCOPE GLOBAL
68 VARIABLE_TYPE ENUM
69 VARIABLE_COMMENT Specifies Aria group commit mode. Possible values are "none" (no group commit), "hard" (with waiting to actual commit), "soft" (no wait for commit (DANGEROUS!!!))
70 NUMERIC_MIN_VALUE NULL
71 NUMERIC_MAX_VALUE NULL
72 NUMERIC_BLOCK_SIZE NULL
73 ENUM_VALUE_LIST none,hard,soft
74 READ_ONLY NO
75 COMMAND_LINE_ARGUMENT REQUIRED
76 VARIABLE_NAME ARIA_GROUP_COMMIT_INTERVAL
77 SESSION_VALUE NULL
78 DEFAULT_VALUE 0
79 VARIABLE_SCOPE GLOBAL
80 VARIABLE_TYPE BIGINT UNSIGNED
81 VARIABLE_COMMENT Interval between commits in microseconds (1/1000000 sec). 0 stands for no waiting for other threads to come and do a commit in "hard" mode and no sync()/commit at all in "soft" mode. Option has only an effect if aria_group_commit is used
82 NUMERIC_MIN_VALUE 0
83 NUMERIC_MAX_VALUE 4294967295
84 NUMERIC_BLOCK_SIZE 1
85 ENUM_VALUE_LIST NULL
86 READ_ONLY NO
87 COMMAND_LINE_ARGUMENT REQUIRED
88 VARIABLE_NAME ARIA_LOG_DIR_PATH
89 SESSION_VALUE NULL
90 DEFAULT_VALUE DATADIR
91 VARIABLE_SCOPE GLOBAL
92 VARIABLE_TYPE VARCHAR
93 VARIABLE_COMMENT Path to the directory where to store transactional log
94 NUMERIC_MIN_VALUE NULL
95 NUMERIC_MAX_VALUE NULL
96 NUMERIC_BLOCK_SIZE NULL
97 ENUM_VALUE_LIST NULL
98 READ_ONLY YES
99 COMMAND_LINE_ARGUMENT REQUIRED
100 VARIABLE_NAME ARIA_LOG_FILE_SIZE
101 SESSION_VALUE NULL
102 DEFAULT_VALUE 1073741824
103 VARIABLE_SCOPE GLOBAL
104 VARIABLE_TYPE BIGINT UNSIGNED
105 VARIABLE_COMMENT Limit for transaction log size
106 NUMERIC_MIN_VALUE 8388608
107 NUMERIC_MAX_VALUE 4294967295
108 NUMERIC_BLOCK_SIZE 8192
109 ENUM_VALUE_LIST NULL
110 READ_ONLY NO
111 COMMAND_LINE_ARGUMENT REQUIRED
112 VARIABLE_NAME ARIA_LOG_PURGE_TYPE
113 SESSION_VALUE NULL
114 DEFAULT_VALUE immediate
115 VARIABLE_SCOPE GLOBAL
116 VARIABLE_TYPE ENUM
117 VARIABLE_COMMENT Specifies how Aria transactional log will be purged
118 NUMERIC_MIN_VALUE NULL
119 NUMERIC_MAX_VALUE NULL
120 NUMERIC_BLOCK_SIZE NULL
121 ENUM_VALUE_LIST immediate,external,at_flush
122 READ_ONLY NO
123 COMMAND_LINE_ARGUMENT REQUIRED
124 VARIABLE_NAME ARIA_MAX_SORT_FILE_SIZE
125 SESSION_VALUE NULL
126 DEFAULT_VALUE 9223372036853727232
127 VARIABLE_SCOPE GLOBAL
128 VARIABLE_TYPE BIGINT UNSIGNED
129 VARIABLE_COMMENT Don't use the fast sort index method to created index if the temporary file would get bigger than this
130 NUMERIC_MIN_VALUE 0
131 NUMERIC_MAX_VALUE 9223372036854775807
132 NUMERIC_BLOCK_SIZE 1048576
133 ENUM_VALUE_LIST NULL
134 READ_ONLY NO
135 COMMAND_LINE_ARGUMENT REQUIRED
136 VARIABLE_NAME ARIA_PAGECACHE_AGE_THRESHOLD
137 SESSION_VALUE NULL
138 DEFAULT_VALUE 300
139 VARIABLE_SCOPE GLOBAL
140 VARIABLE_TYPE BIGINT UNSIGNED
141 VARIABLE_COMMENT This characterizes the number of hits a hot block has to be untouched until it is considered aged enough to be downgraded to a warm block. This specifies the percentage ratio of that number of hits to the total number of blocks in the page cache
142 NUMERIC_MIN_VALUE 100
143 NUMERIC_MAX_VALUE 18446744073709551615
144 NUMERIC_BLOCK_SIZE 100
145 ENUM_VALUE_LIST NULL
146 READ_ONLY NO
147 COMMAND_LINE_ARGUMENT REQUIRED
148 VARIABLE_NAME ARIA_PAGECACHE_BUFFER_SIZE
149 SESSION_VALUE NULL
150 DEFAULT_VALUE 134217728
151 VARIABLE_SCOPE GLOBAL
152 VARIABLE_TYPE BIGINT UNSIGNED
153 VARIABLE_COMMENT The size of the buffer used for index blocks for Aria tables. Increase this to get better index handling (for all reads and multiple writes) to as much as you can afford
154 NUMERIC_MIN_VALUE 131072
155 NUMERIC_MAX_VALUE 18446744073709551615
156 NUMERIC_BLOCK_SIZE 1
157 ENUM_VALUE_LIST NULL
158 READ_ONLY YES
159 COMMAND_LINE_ARGUMENT REQUIRED
160 VARIABLE_NAME ARIA_PAGECACHE_DIVISION_LIMIT
161 SESSION_VALUE NULL
162 DEFAULT_VALUE 100
163 VARIABLE_SCOPE GLOBAL
164 VARIABLE_TYPE BIGINT UNSIGNED
165 VARIABLE_COMMENT The minimum percentage of warm blocks in key cache
166 NUMERIC_MIN_VALUE 1
167 NUMERIC_MAX_VALUE 100
168 NUMERIC_BLOCK_SIZE 1
169 ENUM_VALUE_LIST NULL
170 READ_ONLY NO
171 COMMAND_LINE_ARGUMENT REQUIRED
172 VARIABLE_NAME ARIA_PAGECACHE_FILE_HASH_SIZE
173 SESSION_VALUE NULL
174 DEFAULT_VALUE 512
175 VARIABLE_SCOPE GLOBAL
176 VARIABLE_TYPE BIGINT UNSIGNED
177 VARIABLE_COMMENT Number of hash buckets for open and changed files. If you have a lot of Aria files open you should increase this for faster flush of changes. A good value is probably 1/10 of number of possible open Aria files
178 NUMERIC_MIN_VALUE 128
179 NUMERIC_MAX_VALUE 16384
180 NUMERIC_BLOCK_SIZE 1
181 ENUM_VALUE_LIST NULL
182 READ_ONLY YES
183 COMMAND_LINE_ARGUMENT REQUIRED
184 VARIABLE_NAME ARIA_PAGE_CHECKSUM
185 SESSION_VALUE NULL
186 DEFAULT_VALUE ON
187 VARIABLE_SCOPE GLOBAL
188 VARIABLE_TYPE BOOLEAN
189 VARIABLE_COMMENT Maintain page checksums (can be overridden per table with PAGE_CHECKSUM clause in CREATE TABLE)
190 NUMERIC_MIN_VALUE NULL
191 NUMERIC_MAX_VALUE NULL
192 NUMERIC_BLOCK_SIZE NULL
193 ENUM_VALUE_LIST OFF,ON
194 READ_ONLY NO
195 COMMAND_LINE_ARGUMENT REQUIRED
196 VARIABLE_NAME ARIA_RECOVER_OPTIONS
197 SESSION_VALUE NULL
198 DEFAULT_VALUE BACKUP,QUICK
199 VARIABLE_SCOPE GLOBAL
200 VARIABLE_TYPE SET
201 VARIABLE_COMMENT Specifies how corrupted tables should be automatically repaired
202 NUMERIC_MIN_VALUE NULL
203 NUMERIC_MAX_VALUE NULL
204 NUMERIC_BLOCK_SIZE NULL
205 ENUM_VALUE_LIST NORMAL,BACKUP,FORCE,QUICK,OFF
206 READ_ONLY NO
207 COMMAND_LINE_ARGUMENT OPTIONAL
208 VARIABLE_NAME ARIA_REPAIR_THREADS
209 SESSION_VALUE 1
210 DEFAULT_VALUE 1
211 VARIABLE_SCOPE SESSION
212 VARIABLE_TYPE BIGINT UNSIGNED
213 VARIABLE_COMMENT Number of threads to use when repairing Aria tables. The value of 1 disables parallel repair
214 NUMERIC_MIN_VALUE 1
215 NUMERIC_MAX_VALUE 128
216 NUMERIC_BLOCK_SIZE 1
217 ENUM_VALUE_LIST NULL
218 READ_ONLY NO
219 COMMAND_LINE_ARGUMENT REQUIRED
220 VARIABLE_NAME ARIA_SORT_BUFFER_SIZE
221 SESSION_VALUE 268434432
222 DEFAULT_VALUE 268434432
223 VARIABLE_SCOPE SESSION
224 VARIABLE_TYPE BIGINT UNSIGNED
225 VARIABLE_COMMENT The buffer that is allocated when sorting the index when doing a REPAIR or when creating indexes with CREATE INDEX or ALTER TABLE
226 NUMERIC_MIN_VALUE 16352
227 NUMERIC_MAX_VALUE 1152921504606846975
228 NUMERIC_BLOCK_SIZE 1
229 ENUM_VALUE_LIST NULL
230 READ_ONLY NO
231 COMMAND_LINE_ARGUMENT REQUIRED
232 VARIABLE_NAME ARIA_STATS_METHOD
233 SESSION_VALUE nulls_unequal
234 DEFAULT_VALUE nulls_unequal
235 VARIABLE_SCOPE SESSION
236 VARIABLE_TYPE ENUM
237 VARIABLE_COMMENT Specifies how Aria index statistics collection code should treat NULLs
238 NUMERIC_MIN_VALUE NULL
239 NUMERIC_MAX_VALUE NULL
240 NUMERIC_BLOCK_SIZE NULL
241 ENUM_VALUE_LIST nulls_unequal,nulls_equal,nulls_ignored
242 READ_ONLY NO
243 COMMAND_LINE_ARGUMENT REQUIRED
244 VARIABLE_NAME ARIA_SYNC_LOG_DIR
245 SESSION_VALUE NULL
246 DEFAULT_VALUE NEWFILE
247 VARIABLE_SCOPE GLOBAL
248 VARIABLE_TYPE ENUM
249 VARIABLE_COMMENT Controls syncing directory after log file growth and new file creation
250 NUMERIC_MIN_VALUE NULL
251 NUMERIC_MAX_VALUE NULL
252 NUMERIC_BLOCK_SIZE NULL
253 ENUM_VALUE_LIST NEVER,NEWFILE,ALWAYS
254 READ_ONLY NO
255 COMMAND_LINE_ARGUMENT REQUIRED
256 VARIABLE_NAME ARIA_USED_FOR_TEMP_TABLES
257 SESSION_VALUE NULL
258 DEFAULT_VALUE NULL
259 VARIABLE_SCOPE GLOBAL
260 VARIABLE_TYPE BOOLEAN
261 VARIABLE_COMMENT Whether temporary tables should be MyISAM or Aria
262 NUMERIC_MIN_VALUE NULL
263 NUMERIC_MAX_VALUE NULL
264 NUMERIC_BLOCK_SIZE NULL
265 ENUM_VALUE_LIST OFF,ON
266 READ_ONLY YES
267 COMMAND_LINE_ARGUMENT NULL