summaryrefslogtreecommitdiff
path: root/mysql-test/suite/sys_vars/r/sysvars_aria.result
blob: 8cec099d28c394d24c12ce1d96ca97ef6bfaa10b (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
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
where variable_name like 'aria%'
  order by variable_name;
VARIABLE_NAME	ARIA_BLOCK_SIZE
SESSION_VALUE	NULL
DEFAULT_VALUE	8192
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	Block size to be used for Aria index pages.
NUMERIC_MIN_VALUE	4096
NUMERIC_MAX_VALUE	32768
NUMERIC_BLOCK_SIZE	1024
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	ARIA_CHECKPOINT_INTERVAL
SESSION_VALUE	NULL
DEFAULT_VALUE	30
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	Interval between tries to do an automatic checkpoints. In seconds; 0 means 'no automatic checkpoints' which makes sense only for testing.
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	4294967295
NUMERIC_BLOCK_SIZE	1
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	ARIA_CHECKPOINT_LOG_ACTIVITY
SESSION_VALUE	NULL
DEFAULT_VALUE	1048576
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	Number of bytes that the transaction log has to grow between checkpoints before a new checkpoint is written to the log.
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	4294967295
NUMERIC_BLOCK_SIZE	1
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	ARIA_ENCRYPT_TABLES
SESSION_VALUE	NULL
DEFAULT_VALUE	OFF
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Encrypt tables (only for tables with ROW_FORMAT=PAGE (default) and not FIXED/DYNAMIC)
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	OFF,ON
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
VARIABLE_NAME	ARIA_FORCE_START_AFTER_RECOVERY_FAILURES
SESSION_VALUE	NULL
DEFAULT_VALUE	0
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
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.
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	255
NUMERIC_BLOCK_SIZE	1
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	ARIA_GROUP_COMMIT
SESSION_VALUE	NULL
DEFAULT_VALUE	none
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	ENUM
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!!!))
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	none,hard,soft
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	ARIA_GROUP_COMMIT_INTERVAL
SESSION_VALUE	NULL
DEFAULT_VALUE	0
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
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
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	4294967295
NUMERIC_BLOCK_SIZE	1
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	ARIA_LOG_FILE_SIZE
SESSION_VALUE	NULL
DEFAULT_VALUE	1073741824
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	Limit for transaction log size
NUMERIC_MIN_VALUE	8388608
NUMERIC_MAX_VALUE	4294967295
NUMERIC_BLOCK_SIZE	8192
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	ARIA_LOG_PURGE_TYPE
SESSION_VALUE	NULL
DEFAULT_VALUE	immediate
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	ENUM
VARIABLE_COMMENT	Specifies how Aria transactional log will be purged
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	immediate,external,at_flush
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	ARIA_MAX_SORT_FILE_SIZE
SESSION_VALUE	NULL
DEFAULT_VALUE	9223372036853727232
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	Don't use the fast sort index method to created index if the temporary file would get bigger than this.
NUMERIC_MIN_VALUE	0
NUMERIC_MAX_VALUE	9223372036854775807
NUMERIC_BLOCK_SIZE	1048576
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	ARIA_PAGECACHE_AGE_THRESHOLD
SESSION_VALUE	NULL
DEFAULT_VALUE	300
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
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.
NUMERIC_MIN_VALUE	100
NUMERIC_MAX_VALUE	18446744073709551615
NUMERIC_BLOCK_SIZE	100
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	ARIA_PAGECACHE_BUFFER_SIZE
SESSION_VALUE	NULL
DEFAULT_VALUE	134217728
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
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.
NUMERIC_MIN_VALUE	131072
NUMERIC_MAX_VALUE	18446744073709551615
NUMERIC_BLOCK_SIZE	1
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	ARIA_PAGECACHE_DIVISION_LIMIT
SESSION_VALUE	NULL
DEFAULT_VALUE	100
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	The minimum percentage of warm blocks in key cache
NUMERIC_MIN_VALUE	1
NUMERIC_MAX_VALUE	100
NUMERIC_BLOCK_SIZE	1
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	ARIA_PAGECACHE_FILE_HASH_SIZE
SESSION_VALUE	NULL
DEFAULT_VALUE	512
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BIGINT UNSIGNED
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.
NUMERIC_MIN_VALUE	128
NUMERIC_MAX_VALUE	16384
NUMERIC_BLOCK_SIZE	1
ENUM_VALUE_LIST	NULL
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	ARIA_PAGE_CHECKSUM
SESSION_VALUE	NULL
DEFAULT_VALUE	ON
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Maintain page checksums (can be overridden per table with PAGE_CHECKSUM clause in CREATE TABLE)
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	OFF,ON
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	ARIA_RECOVER_OPTIONS
SESSION_VALUE	NULL
DEFAULT_VALUE	BACKUP,QUICK
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	SET
VARIABLE_COMMENT	Specifies how corrupted tables should be automatically repaired
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NORMAL,BACKUP,FORCE,QUICK,OFF
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	OPTIONAL
VARIABLE_NAME	ARIA_REPAIR_THREADS
SESSION_VALUE	1
DEFAULT_VALUE	1
VARIABLE_SCOPE	SESSION
VARIABLE_TYPE	BIGINT UNSIGNED
VARIABLE_COMMENT	Number of threads to use when repairing Aria tables. The value of 1 disables parallel repair.
NUMERIC_MIN_VALUE	1
NUMERIC_MAX_VALUE	128
NUMERIC_BLOCK_SIZE	1
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	ARIA_SORT_BUFFER_SIZE
SESSION_VALUE	268434432
DEFAULT_VALUE	268434432
VARIABLE_SCOPE	SESSION
VARIABLE_TYPE	BIGINT UNSIGNED
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.
NUMERIC_MIN_VALUE	4096
NUMERIC_MAX_VALUE	9223372036854775807
NUMERIC_BLOCK_SIZE	1
ENUM_VALUE_LIST	NULL
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	ARIA_STATS_METHOD
SESSION_VALUE	nulls_unequal
DEFAULT_VALUE	nulls_unequal
VARIABLE_SCOPE	SESSION
VARIABLE_TYPE	ENUM
VARIABLE_COMMENT	Specifies how Aria index statistics collection code should treat NULLs
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	nulls_unequal,nulls_equal,nulls_ignored
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	ARIA_SYNC_LOG_DIR
SESSION_VALUE	NULL
DEFAULT_VALUE	NEWFILE
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	ENUM
VARIABLE_COMMENT	Controls syncing directory after log file growth and new file creation
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	NEVER,NEWFILE,ALWAYS
READ_ONLY	NO
COMMAND_LINE_ARGUMENT	REQUIRED
VARIABLE_NAME	ARIA_USED_FOR_TEMP_TABLES
SESSION_VALUE	NULL
DEFAULT_VALUE	NULL
VARIABLE_SCOPE	GLOBAL
VARIABLE_TYPE	BOOLEAN
VARIABLE_COMMENT	Whether temporary tables should be MyISAM or Aria
NUMERIC_MIN_VALUE	NULL
NUMERIC_MAX_VALUE	NULL
NUMERIC_BLOCK_SIZE	NULL
ENUM_VALUE_LIST	OFF,ON
READ_ONLY	YES
COMMAND_LINE_ARGUMENT	NULL