ARIA_BLOCK_SIZE |
NULL | 8192 |
COMPILE-TIME |
8192 |
GLOBAL |
BIGINT UNSIGNED |
Block size to be used for Aria index pages. |
1024 |
32768 |
1024 |
NULL | YES |
REQUIRED |
ARIA_CHECKPOINT_INTERVAL |
NULL | 30 |
COMPILE-TIME |
30 |
GLOBAL |
BIGINT UNSIGNED |
Interval between tries to do an automatic checkpoi... |
0 |
4294967295 |
1 |
NULL | NO |
REQUIRED |
ARIA_CHECKPOINT_LOG_ACTIVITY |
NULL | 1048576 |
COMPILE-TIME |
1048576 |
GLOBAL |
BIGINT UNSIGNED |
Number of bytes that the transaction log has to gr... |
0 |
4294967295 |
1 |
NULL | NO |
REQUIRED |
ARIA_ENCRYPT_TABLES |
NULL | OFF |
COMPILE-TIME |
OFF |
GLOBAL |
BOOLEAN |
Encrypt tables (only for tables with ROW_FORMAT=PA... |
NULL | NULL | NULL | OFF,ON |
NO |
OPTIONAL |
ARIA_FORCE_START_AFTER_RECOVERY_FAILURES |
NULL | 0 |
COMPILE-TIME |
0 |
GLOBAL |
BIGINT UNSIGNED |
Number of consecutive log recovery failures after ... |
0 |
255 |
1 |
NULL | YES |
REQUIRED |
ARIA_GROUP_COMMIT |
NULL | none |
COMPILE-TIME |
none |
GLOBAL |
ENUM |
Specifies Aria group commit mode. Possible values ... |
NULL | NULL | NULL | none,hard,soft |
NO |
REQUIRED |
ARIA_GROUP_COMMIT_INTERVAL |
NULL | 0 |
COMPILE-TIME |
0 |
GLOBAL |
BIGINT UNSIGNED |
Interval between commite in microseconds (1/100000... |
0 |
4294967295 |
1 |
NULL | NO |
REQUIRED |
ARIA_LOG_FILE_SIZE |
NULL | 1073741824 |
COMPILE-TIME |
1073741824 |
GLOBAL |
BIGINT UNSIGNED |
Limit for transaction log size |
8388608 |
4294967295 |
8192 |
NULL | NO |
REQUIRED |
ARIA_LOG_PURGE_TYPE |
NULL | immediate |
COMPILE-TIME |
immediate |
GLOBAL |
ENUM |
Specifies how Aria transactional log will be purge... |
NULL | NULL | NULL | immediate,external,at_flush |
NO |
REQUIRED |
ARIA_MAX_SORT_FILE_SIZE |
NULL | 9223372036853727232 |
COMPILE-TIME |
9223372036853727232 |
GLOBAL |
BIGINT UNSIGNED |
Don't use the fast sort index method to created in... |
0 |
9223372036854775807 |
1048576 |
NULL | NO |
REQUIRED |
ARIA_PAGECACHE_AGE_THRESHOLD |
NULL | 300 |
COMPILE-TIME |
300 |
GLOBAL |
BIGINT UNSIGNED |
This characterizes the number of hits a hot block ... |
100 |
18446744073709551615 |
100 |
NULL | NO |
REQUIRED |
ARIA_PAGECACHE_BUFFER_SIZE |
NULL | 134217728 |
COMPILE-TIME |
134217728 |
GLOBAL |
BIGINT UNSIGNED |
The size of the buffer used for index blocks for A... |
131072 |
18446744073709551615 |
1 |
NULL | YES |
REQUIRED |
ARIA_PAGECACHE_DIVISION_LIMIT |
NULL | 100 |
COMPILE-TIME |
100 |
GLOBAL |
BIGINT UNSIGNED |
The minimum percentage of warm blocks in key cache |
1 |
100 |
1 |
NULL | NO |
REQUIRED |
ARIA_PAGECACHE_FILE_HASH_SIZE |
NULL | 512 |
COMPILE-TIME |
512 |
GLOBAL |
BIGINT UNSIGNED |
Number of hash buckets for open and changed files.... |
128 |
16384 |
1 |
NULL | YES |
REQUIRED |
ARIA_PAGE_CHECKSUM |
NULL | ON |
COMPILE-TIME |
ON |
GLOBAL |
BOOLEAN |
Maintain page checksums (can be overridden per tab... |
NULL | NULL | NULL | OFF,ON |
NO |
REQUIRED |
ARIA_RECOVER |
NULL | NORMAL |
COMPILE-TIME |
NORMAL |
GLOBAL |
SET |
Specifies how corrupted tables should be automatic... |
NULL | NULL | NULL | NORMAL,BACKUP,FORCE,QUICK,OFF |
NO |
OPTIONAL |
ARIA_REPAIR_THREADS |
1 |
1 |
COMPILE-TIME |
1 |
SESSION |
BIGINT UNSIGNED |
Number of threads to use when repairing Aria table... |
1 |
128 |
1 |
NULL | NO |
REQUIRED |
ARIA_SORT_BUFFER_SIZE |
268434432 |
268434432 |
COMPILE-TIME |
268434432 |
SESSION |
BIGINT UNSIGNED |
The buffer that is allocated when sorting the inde... |
4096 |
18446744073709551615 |
1 |
NULL | NO |
REQUIRED |
ARIA_STATS_METHOD |
nulls_unequal |
nulls_unequal |
COMPILE-TIME |
nulls_unequal |
SESSION |
ENUM |
Specifies how Aria index statistics collection cod... |
NULL | NULL | NULL | nulls_unequal,nulls_equal,nulls_ignored |
NO |
REQUIRED |
ARIA_SYNC_LOG_DIR |
NULL | NEWFILE |
COMPILE-TIME |
NEWFILE |
GLOBAL |
ENUM |
Controls syncing directory after log file growth a... |
NULL | NULL | NULL | NEVER,NEWFILE,ALWAYS |
NO |
REQUIRED |
ARIA_USED_FOR_TEMP_TABLES |
NULL | ON |
COMPILE-TIME |
NULL | GLOBAL |
BOOLEAN |
Whether temporary tables should be MyISAM or Aria |
NULL | NULL | NULL | OFF,ON |
YES |
NULL |
AUTOCOMMIT |
ON |
ON |
COMPILE-TIME |
ON |
SESSION |
BOOLEAN |
If set to 1, the default, all queries are committe... |
NULL | NULL | NULL | OFF,ON |
NO |
NULL |
AUTOMATIC_SP_PRIVILEGES |
NULL | ON |
COMPILE-TIME |
ON |
GLOBAL |
BOOLEAN |
Creating and dropping stored procedures alters ACL... |
NULL | NULL | NULL | OFF,ON |
NO |
OPTIONAL |
AUTO_INCREMENT_INCREMENT |
1 |
1 |
COMPILE-TIME |
1 |
SESSION |
BIGINT UNSIGNED |
Auto-increment columns are incremented by this |
1 |
65535 |
1 |
NULL | NO |
OPTIONAL |
AUTO_INCREMENT_OFFSET |
1 |
1 |
COMPILE-TIME |
1 |
SESSION |
BIGINT UNSIGNED |
Offset added to Auto-increment columns. Used when ... |
1 |
65535 |
1 |
NULL | NO |
OPTIONAL |