A comprehensive list of system variables for configuring Aria, including buffer sizes, log settings, and recovery options.
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 instructions on setting system variables.
aria_block_sizeDescription: Block size to be used for Aria index pages. Changing this requires dumping, deleting old tables and deleting all log files, and then restoring your Aria tables. If key lookups take too long (and one has to search roughly 8192/2 by default to find each key), can be made smaller, e.g. 4096.
Command line: --aria-block-size=#
Scope: Global
Dynamic: No
Data Type: numeric
Default Value: 8192
Range:
= :
4096to32768in increments of1024
<= : 1024 to 32768
aria_checkpoint_intervalDescription: Interval in seconds between automatic checkpoints. 0 means 'no automatic checkpoints' which makes sense only for testing.
Command line: --aria-checkpoint-interval=#
Scope: Global
Dynamic: Yes
aria_checkpoint_log_activityDescription: Number of bytes that the transaction log has to grow between checkpoints before a new checkpoint is written to the log.
Command line: aria-checkpoint-log-activity=#
Scope: Global
Dynamic: Yes
aria_encrypt_tablesDescription: Enables automatic encryption of all user-created Aria tables that have the table option set to . See and .
Command line: aria-encrypt-tables={0|1}
Scope: Global
Dynamic: Yes
aria_force_start_after_recovery_failuresDescription: Number of consecutive log recovery failures after which logs are automatically deleted to cure the problem; 0 (the default) disables the feature.
Command line: --aria-force-start-after-recovery-failures=#
Scope: Global
Dynamic: No
aria_group_commitDescription: Specifies Aria .
Command line: --aria_group_commit="value"
Alias: maria_group_commit
Scope: Global
aria_group_commit_intervalDescription: Interval between in microseconds (1/1000000 second) for other threads to come and do a commit in "hard" mode and sync()/commit at all in "soft" mode. Option only has effect if is used.
Command line: --aria_group_commit_interval=#
Alias: maria_group_commit_interval
aria_log_dir_pathDescription: Path to the directory where transactional log should be stored
Command line: --aria-log-dir-path=value
Scope: Global
Dynamic: No
aria_log_file_sizeDescription: Limit for Aria transaction log size
Command line: --aria-log-file-size=#
Scope: Global
Dynamic: Yes
aria_log_purge_typeDescription: Specifies how the Aria transactional log are purged. Set to at_flush to keep a copy of the transaction logs (good as an extra backup). The logs will stay until the next ;
Command line: --aria-log-purge-type=name
Scope: Global
aria_max_sort_file_sizeDescription: Don't use the fast sort index method to created index if the temporary file would get bigger than this.
Command line: --aria-max-sort-file-size=#
Scope: Global
Dynamic: Yes
aria_page_checksumDescription: Determines whether index and data should use page checksums for extra safety. Can be overridden per table with PAGE_CHECKSUM clause in .
Command line: --aria-page-checksum=#
Scope: Global
Dynamic: Yes
aria_pagecache_age_thresholdDescription: 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.
Command line: --aria-pagecache-age-threshold=#
Scope: Global
Dynamic: Yes
aria_pagecache_buffer_sizeDescription: The size of the buffer used for index and data blocks for Aria tables. This can include explicit Aria tables, system tables, and temporary tables. Increase this to get better handling and measure by looking at (should be small) vs .
Command line: --aria-pagecache-buffer-size=#
Scope: Global
Dynamic: No
aria_pagecache_division_limitDescription: The minimum percentage of warm blocks in the key cache.
Command line: --aria-pagecache-division-limit=#
Scope: Global
Dynamic: Yes
aria_pagecache_file_hash_sizeDescription: Number of hash buckets for open and changed files. If you have many Aria files open you should increase this for faster flushing of changes. A good value is probably 1/10th of the number of possible open Aria files.
Command line: --aria-pagecache-file-hash-size=#
Scope: Global
Dynamic: No
aria_pagecache_segmentsDescription: The number of segments in the page_cache. Each file is put in their own segments of size pagecache_buffer_size / segments. Having many segments improves parallel performance.
Command line: --aria-pagecache-segments=#
Scope: Global
Dynamic: No
aria_recoverDescription: aria_recover has been renamed to aria_recover_options in . See for the description.
aria_recover_optionsDescription: Specifies how corrupted tables should be automatically repaired. More than one option can be specified, for example FORCE,BACKUP.
NORMAL: Normal automatic repair, the default until
OFF: Autorecovery is disabled, the equivalent of not using the option
aria_repair_threadsDescription: Number of threads to use when repairing Aria tables. The value of 1 disables parallel repair. Increasing from the default will usually result in faster repair, but will use more CPU and memory.
Command line: --aria-repair-threads=#
Scope: Global, Session
Dynamic: Yes
aria_sort_buffer_sizeDescription: The buffer that is allocated when sorting the index when doing a or when creating indexes with or .
Command line: --aria-sort-buffer-size=#
Scope: Global, Session
Dynamic: Yes
aria_stats_methodDescription: Determines how NULLs are treated for Aria index statistics purposes. If set to 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 , and .
Command line: --aria-stats-method=#
aria_sync_log_dirDescription: Controls syncing directory after log file growth and new file creation.
Command line: --aria-sync-log-dir=#
Scope: Global
Dynamic: Yes
aria_used_for_temp_tablesDescription: Readonly variable indicating whether the storage engine is used for temporary tables. If set to ON, the default, the Aria storage engine is used. If set to OFF, MariaDB reverts to using for on-disk temporary tables. The 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.
Command line: No
Scope: Global
deadlock_search_depth_longDescription: Long search depth for the . Only used by the storage engine.
Command line: --deadlock-search-depth-long=#
Scope: Global, Session
Dynamic: Yes
deadlock_search_depth_shortDescription: Short search depth for the . Only used by the storage engine.
Command line: --deadlock-search-depth-short=#
Scope: Global, Session
Dynamic: Yes
deadlock_timeout_longDescription: Long timeout in microseconds for the . Only used by the storage engine.
Command line: --deadlock-timeout-long=#
Scope: Global, Session
Dynamic: Yes
deadlock_timeout_shortDescription: Short timeout in microseconds for the . Only used by the storage engine.
Command line: --deadlock-timeout-short=#
Scope: Global, Session
Dynamic: Yes
This page is licensed: CC BY-SA / Gnu FDL
1024Data Type: numeric
Default Value: 30
Range: 0 to 4294967295
Data Type: numeric
Default Value: 1048576
Range 0 to 4294967295
Data Type: boolean
Default Value: OFF
Data Type: numeric
Default Value: 0
Dynamic: No
Data Type: string
Valid values:
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)
Default Value: none
Dynamic: No
Type: numeric
Valid Values:
Default Value: 0 (no waiting)
Range: 0-4294967295
Data Type: string
Default Value: Same as DATADIR
Introduced: , MariaDB 10.6.13, MariaDB 10.11.3 (as a system variable, existed as an option only before that)
Data Type: numeric
Default Value: 1073741824
Data Type: enumeration
Default Value: immediate
Valid Values: immediate, external, at_flush
Data Type: numeric
Default Value: 9223372036853727232
Range: 0 to 9223372036854775807
Data Type: boolean
Default Value: ON
Data Type: numeric
Default Value: 300
Range: 100 to 9999900
Data Type: numeric
Default Value: 134217728 (128MB)
Range: 131072 (128KB) upwards
Data Type: numeric
Default Value: 100
Range: 1 to 100
Data Type: numeric
Default Value: 512
Range: 128 to 16384
Data Type: numeric
Default Value: 1
Range: 1 to 128
Introduced: MariaDB Community Server 12.1, ,
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 are lost.
BACKUP: Keeps a backup of the data files.
Command line: --aria-recover-options[=#]
Scope: Global
Dynamic: Yes
Data Type: enumeration
Default Value:
BACKUP,QUICK (>= )
NORMAL (<= )
Valid Values: NORMAL, BACKUP, FORCE, QUICK, OFF
Introduced:
Data Type: numeric
Default Value: 1
Data Type: numeric
Default Value: 268434432
Scope: Global, Session
Dynamic: Yes
Data Type: numeric
Default Value: nulls_unequal
Valid Values: nulls_equal, nulls_unequal, nulls_ignored
Data Type: enumeration
Default Value: NEWFILE
Valid Values: NEWFILE, NEVER, ALWAYS
Dynamic: No
Data Type: boolean
Default Value: ON
Data Type: numeric
Default Value: 15
Range: 0 to 33
Data Type: numeric
Default Value: 4
Range: 0 to 32
Data Type: numeric
Default Value: 50000000
Range: 0 to 4294967295
Data Type: numeric
Default Value: 10000
Range: 0 to 4294967295