Aria System Variables
You are viewing an old version of this article. View
the current version here.
Contents
- aria_block_size
- aria_checkpoint_interval
- aria_checkpoint_log_activity
- aria_force_start_after_recovery_failures
- aria_group_commit
- aria_group_commit_interval
- aria_log_dir_path
- aria_log_file_size
- aria_log_purge_type
- aria_max_sort_file_size
- aria_page_checksum
- aria_pagecache_age_threshold
- aria_pagecache_buffer_size
- aria_pagecache_division_limit
- aria_pagecache_file_hash_size
- aria_recover
- aria_repair_threads
- aria_sort_buffer_size
- aria_stats_method
- aria_sync_log_dir
- aria_used_for_temp_tables
- deadlock_search_depth_long
- deadlock_search_depth_short
- deadlock_timeout_long
- deadlock_timeout_short
This page documents system variables related to the Aria storage engine. See Server System Variables for a complete list of system variables and instructions on setting them.
See also the Full list of MariaDB options, system and status variables.
aria_block_size
- Description: 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.
2048
or4096
. - Commandline:
--aria-block-size=#
- Scope: Global
- Dynamic: No
- Data Type:
numeric
- Default Value:
8192
aria_checkpoint_interval
- Description: Interval in seconds between automatic checkpoints. 0 means 'no automatic checkpoints' which makes sense only for testing.
- Commandline:
--aria-checkpoint-interval=#
- Scope: Global
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
30
- Range - 32-bit:
0
to4294967295
aria_checkpoint_log_activity
- Description:
- Commandline:
aria-checkpoint-log-activity=#
- Scope: Global
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
1048576
- Range - 32-bit:
0
to4294967295
- Introduced:
MariaDB 5.2.9
aria_force_start_after_recovery_failures
- Description: Number of consecutive log recovery failures after which logs will be automatically deleted to cure the problem; 0 (the default) disables the feature.
- Commandline:
--aria-force-start-after-recovery-failures=#
- Scope: Global
- Dynamic: No
- Data Type:
numeric
- Default Value:
0
aria_group_commit
- Description: Specifies Aria group commit mode.
- Commandline:
--aria_group_commit="value"
- Alias:
maria_group_commit
- Scope: Global
- 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
- Introduced: MariaDB 5.2
aria_group_commit_interval
- Description: Interval between Aria group commits 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 aria_group_commit is used.
- Commandline:
--aria_group_commit_interval=#
- Alias:
maria_group_commit_interval
- Scope: Global
- Dynamic: No
- Type: numeric
- Valid Values:
- Default Value:
0
(no waiting) - Range - 32-bit:
0-4294967295
- Range - 64-bit:
0-18446744073709547520
- Default Value:
- Introduced: MariaDB 5.2
aria_log_dir_path
- Description: Path to the directory where to store transactional log
- Commandline:
--aria-log-dir-path=#
- Scope: Global
- Dynamic: Yes
- Data Type:
directory
- Default Value:
SAME AS DATADIR
aria_log_file_size
- Description: Limit for Aria transaction log size
- Commandline:
--aria-log-file-size=#
- Scope: Global
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
1073741824
aria_log_purge_type
- Description: Specifies how the Aria transactional log will be 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 FLUSH LOGS; - Commandline:
--aria-log-purge-type=name
- Scope: Global
- Dynamic: Yes
- Data Type:
enumeration
- Default Value:
immediate
- Valid Values:
immediate
,external
,at_flush
aria_max_sort_file_size
- Description: Don't use the fast sort index method to created index if the temporary file would get bigger than this.
- Commandline:
--aria-max-sort-file-size=#
- Scope: Global
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
9223372036853727232
- Range - 32 bit:
0
to99999999999344640
aria_page_checksum
- Description: Determines whether index and data should use page checksums for extra safety. Can be overridden per table with PAGE_CHECKSUM clause in CREATE TABLE.
- Commandline:
--aria-page-checksum=#
- Scope: Global
- Dynamic: Yes
- Data Type:
boolean
- Default Value:
ON
aria_pagecache_age_threshold
- Description: 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.
- Commandline:
--aria-pagecache-age-threshold=#
- Scope: Global
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
300
- Range:
100
to9999900
aria_pagecache_buffer_size
- Description: 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.
- Commandline:
--aria-pagecache-buffer-size=#
- Scope: Global
- Dynamic: No
- Data Type:
numeric
- Default Value:
134217720
(128MB) - Range:
131072
(128KB) upwards
aria_pagecache_division_limit
- Description: The minimum percentage of warm blocks in the key cache.
- Commandline:
--aria-pagecache-division-limit=#
- Scope: Global
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
100
- Range:
1
to100
aria_pagecache_file_hash_size
- Description: 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.
- Commandline:
--aria-pagecache-file-hash-size=#
- Scope: Global
- Dynamic: No
- Data Type:
numeric
- Default Value:
512
- Range:
128
to16384
- Introduced:
MariaDB 10.0.13
aria_recover
- Description: Specifies how corrupted tables should be automatically repaired. "BACKUP", "FORCE", "QUICK", or "OFF" which is like not using the option.
- Commandline:
--aria-recover[=#]
- Scope: Global
- Dynamic: Yes
- Data Type:
enumeration
- Default Value:
NORMAL
- Valid Values:
NORMAL
,BACKUP
,FORCE
,QUICK
,OFF
aria_repair_threads
- Description: 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.
- Commandline:
--aria-repair-threads=#
- Scope: Global, Session
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
1
aria_sort_buffer_size
- Description: The buffer that is allocated when sorting the index when doing a REPAIR or when creating indexes with CREATE INDEX or ALTER TABLE.
- Commandline:
--aria-sort-buffer-size=#
- Scope: Global, Session
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
268434432
(from MariaDB 10.0.3),134217728
(before MariaDB 10.0.3)
aria_stats_method
- Description: 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 tonulls_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 tonulls_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. - Commandline:
--aria-stats-method=#
- Scope: Global, Session
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
nulls_unequal
- Valid Values:
nulls_equal
,nulls_unequal
,nulls_ignored
aria_sync_log_dir
- Description: Controls syncing directory after log file growth and new file creation.
- Commandline:
--aria-sync-log-dir=#
- Scope: Global
- Dynamic: Yes
- Data Type:
enumeration
- Default Value:
NEWFILE
- Valid Values:
NEWFILE
,NEVER
,ALWAYS
aria_used_for_temp_tables
- Description: Readonly variable indicating whether the Aria storage engine is used for temporary tables. If set to
ON
, the default, the Aria storage engine is used. If set toOFF
, 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. - Commandline: No
- Scope: Global
- Dynamic: No
- Data Type:
boolean
- Default Value:
ON
deadlock_search_depth_long
- Description: Long search depth for the two-step deadlock detection. Only used by the Aria storage engine.
- Commandline:
--deadlock-search-depth-long=#
- Scope: Global, Session
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
15
- Range:
0
to33
deadlock_search_depth_short
- Description: Short search depth for the two-step deadlock detection. Only used by the Aria storage engine.
- Commandline:
--deadlock-search-depth-short=#
- Scope: Global, Session
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
4
- Range:
0
to32
deadlock_timeout_long
- Description: Long timeout in microseconds for the two-step deadlock detection. Only used by the Aria storage engine.
- Commandline:
--deadlock-timeout-long=#
- Scope: Global, Session
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
50000000
- Range - 32 bit:
0
to4294967295
deadlock_timeout_short
- Description: Short timeout in microseconds for the two-step deadlock detection. Only used by the Aria storage engine.
- Commandline:
--deadlock-timeout-short=#
- Scope: Global, Session
- Dynamic: Yes
- Data Type:
numeric
- Default Value:
10000
- Range - 32 bit:
0
to4294967295
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.