This page documents system variables related to the Aria storage engine. For options that are not system variables, see Aria Options.
See Server System Variables for a complete list of system variables and instructions on setting system variables.
Also see the Full list of MariaDB options, system and status variables.
aria_block_size
2048
or 4096
. --aria-block-size=#
numeric
8192
aria_checkpoint_interval
--aria-checkpoint-interval=#
numeric
30
0
to 4294967295
aria_checkpoint_log_activity
aria-checkpoint-log-activity=#
numeric
1048576
0
to 4294967295
aria_encrypt_tables
ROW_FORMAT
table option set to PAGE
. See Data at Rest Encryption and Enabling Encryption for User-created Tables. aria-encrypt-tables={0|1}
boolean
OFF
aria_force_start_after_recovery_failures
--aria-force-start-after-recovery-failures=#
numeric
0
aria_group_commit
--aria_group_commit="value"
maria_group_commit
string
none
- Group commit is disabled. hard
- Wait the number of microseconds specified by aria_group_commit_interval before actually doing the commit. If the interval is 0 then just check if any other threads have requested a commit during the time this commit was preparing (just before sync() file) and send their data to disk also before sync(). soft
- The service thread will wait the specified time and then sync() to the log. If the interval is 0 then it won't wait for any commits (this is dangerous and should generally not be used in production) none
aria_group_commit_interval
--aria_group_commit_interval=#
maria_group_commit_interval
0
(no waiting) 0-4294967295
aria_log_file_size
--aria-log-file-size=#
numeric
1073741824
aria_log_purge_type
at_flush
to keep a copy of the transaction logs (good as an extra backup). The logs will stay until the next FLUSH LOGS; --aria-log-purge-type=name
enumeration
immediate
immediate
, external
, at_flush
aria_max_sort_file_size
--aria-max-sort-file-size=#
numeric
9223372036853727232
0
to 9223372036854775807
aria_page_checksum
--aria-page-checksum=#
boolean
ON
aria_pagecache_age_threshold
--aria-pagecache-age-threshold=#
numeric
300
100
to 9999900
aria_pagecache_buffer_size
--aria-pagecache-buffer-size=#
numeric
134217720
(128MB) 131072
(128KB) upwards aria_pagecache_division_limit
--aria-pagecache-division-limit=#
numeric
100
1
to 100
aria_pagecache_file_hash_size
--aria-pagecache-file-hash-size=#
numeric
512
128
to 16384
aria_recover
aria_recover
has been renamed to aria_recover_options
in MariaDB 10.2.0. See aria_recover_options for the description. aria_recover_options
FORCE,BACKUP
. NORMAL
: Normal automatic repair, the default until MariaDB 10.2.3 OFF
: Autorecovery is disabled, the equivalent of not using the option QUICK
: Does not check rows in the table if there are no delete blocks. FORCE
: Runs the recovery even if it determines that more than one row from the data file will be lost. BACKUP
: Keeps a backup of the data files. --aria-recover-options[=#]
enumeration
BACKUP,QUICK
(>= MariaDB 10.2.4) NORMAL
(<= MariaDB 10.2.3) NORMAL
, BACKUP
, FORCE
, QUICK
, OFF
aria_repair_threads
--aria-repair-threads=#
numeric
1
aria_sort_buffer_size
--aria-sort-buffer-size=#
numeric
268434432
(from MariaDB 10.0.3), 134217728
(before MariaDB 10.0.3) aria_stats_method
nulls_equal
, all NULL index values are treated as a single group. This is usually fine, but if you have large numbers of NULLs the average group size is slanted higher, and the optimizer may miss using the index for ref accesses when it would be useful. If set to nulls_unequal
, the default, the opposite approach is taken, with each NULL forming its own group of one. Conversely, the average group size is slanted lower, and the optimizer may use the index for ref accesses when not suitable. Setting to nulls_ignored
ignores NULLs altogether from index group calculations. Statistics need to be recalculated after this method is changed. See also Index Statistics, myisam_stats_method and innodb_stats_method. --aria-stats-method=#
numeric
nulls_unequal
nulls_equal
, nulls_unequal
, nulls_ignored
aria_sync_log_dir
--aria-sync-log-dir=#
enumeration
NEWFILE
NEWFILE
, NEVER
, ALWAYS
aria_used_for_temp_tables
ON
, the default, the Aria storage engine is used. If set to OFF
, MariaDB reverts to using MyISAM for on-disk temporary tables. The MEMORY storage engine is used for temporary tables regardless of this variable's setting where appropriate. The default can be changed by not using the --with-aria-tmp-tables
option when building MariaDB. boolean
ON
deadlock_search_depth_long
--deadlock-search-depth-long=#
numeric
15
0
to 33
deadlock_search_depth_short
--deadlock-search-depth-short=#
numeric
4
0
to 32
deadlock_timeout_long
--deadlock-timeout-long=#
numeric
50000000
0
to 4294967295
deadlock_timeout_short
--deadlock-timeout-short=#
numeric
10000
0
to 4294967295
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/aria-system-variables/