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