1--- sysvars_aria.result 2015-01-09 11:49:32.000000000 +0100 2+++ sysvars_aria,32bit.result 2015-01-09 17:30:11.000000000 +0100 3@@ -7,7 +7,7 @@ 4 GLOBAL_VALUE_ORIGIN COMPILE-TIME 5 DEFAULT_VALUE 8192 6 VARIABLE_SCOPE GLOBAL 7-VARIABLE_TYPE BIGINT UNSIGNED 8+VARIABLE_TYPE INT UNSIGNED 9 VARIABLE_COMMENT Block size to be used for Aria index pages. 10 NUMERIC_MIN_VALUE 1024 11 NUMERIC_MAX_VALUE 32768 12@@ -21,7 +21,7 @@ 13 GLOBAL_VALUE_ORIGIN COMPILE-TIME 14 DEFAULT_VALUE 30 15 VARIABLE_SCOPE GLOBAL 16-VARIABLE_TYPE BIGINT UNSIGNED 17+VARIABLE_TYPE INT UNSIGNED 18 VARIABLE_COMMENT Interval between tries to do an automatic checkpoints. In seconds; 0 means 'no automatic checkpoints' which makes sense only for testing. 19 NUMERIC_MIN_VALUE 0 20 NUMERIC_MAX_VALUE 4294967295 21@@ -35,7 +35,7 @@ 22 GLOBAL_VALUE_ORIGIN COMPILE-TIME 23 DEFAULT_VALUE 1048576 24 VARIABLE_SCOPE GLOBAL 25-VARIABLE_TYPE BIGINT UNSIGNED 26+VARIABLE_TYPE INT UNSIGNED 27 VARIABLE_COMMENT Number of bytes that the transaction log has to grow between checkpoints before a new checkpoint is written to the log. 28 NUMERIC_MIN_VALUE 0 29 NUMERIC_MAX_VALUE 4294967295 30@@ -63,7 +63,7 @@ 31 GLOBAL_VALUE_ORIGIN COMPILE-TIME 32 DEFAULT_VALUE 0 33 VARIABLE_SCOPE GLOBAL 34-VARIABLE_TYPE BIGINT UNSIGNED 35+VARIABLE_TYPE INT UNSIGNED 36 VARIABLE_COMMENT Number of consecutive log recovery failures after which logs will be automatically deleted to cure the problem; 0 (the default) disables the feature. 37 NUMERIC_MIN_VALUE 0 38 NUMERIC_MAX_VALUE 255 39@@ -91,7 +91,7 @@ 40 GLOBAL_VALUE_ORIGIN COMPILE-TIME 41 DEFAULT_VALUE 0 42 VARIABLE_SCOPE GLOBAL 43-VARIABLE_TYPE BIGINT UNSIGNED 44+VARIABLE_TYPE INT UNSIGNED 45 VARIABLE_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 46 NUMERIC_MIN_VALUE 0 47 NUMERIC_MAX_VALUE 4294967295 48@@ -105,7 +105,7 @@ 49 GLOBAL_VALUE_ORIGIN CONFIG 50 DEFAULT_VALUE 1073741824 51 VARIABLE_SCOPE GLOBAL 52-VARIABLE_TYPE BIGINT UNSIGNED 53+VARIABLE_TYPE INT UNSIGNED 54 VARIABLE_COMMENT Limit for transaction log size 55 NUMERIC_MIN_VALUE 8388608 56 NUMERIC_MAX_VALUE 4294967295 57@@ -147,10 +147,10 @@ 58 GLOBAL_VALUE_ORIGIN COMPILE-TIME 59 DEFAULT_VALUE 300 60 VARIABLE_SCOPE GLOBAL 61-VARIABLE_TYPE BIGINT UNSIGNED 62+VARIABLE_TYPE INT UNSIGNED 63 VARIABLE_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. 64 NUMERIC_MIN_VALUE 100 65-NUMERIC_MAX_VALUE 18446744073709551615 66+NUMERIC_MAX_VALUE 4294967295 67 NUMERIC_BLOCK_SIZE 100 68 ENUM_VALUE_LIST NULL 69 READ_ONLY NO 70@@ -175,7 +175,7 @@ 71 GLOBAL_VALUE_ORIGIN COMPILE-TIME 72 DEFAULT_VALUE 100 73 VARIABLE_SCOPE GLOBAL 74-VARIABLE_TYPE BIGINT UNSIGNED 75+VARIABLE_TYPE INT UNSIGNED 76 VARIABLE_COMMENT The minimum percentage of warm blocks in key cache 77 NUMERIC_MIN_VALUE 1 78 NUMERIC_MAX_VALUE 100 79@@ -189,7 +189,7 @@ 80 GLOBAL_VALUE_ORIGIN COMPILE-TIME 81 DEFAULT_VALUE 512 82 VARIABLE_SCOPE GLOBAL 83-VARIABLE_TYPE BIGINT UNSIGNED 84+VARIABLE_TYPE INT UNSIGNED 85 VARIABLE_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. 86 NUMERIC_MIN_VALUE 128 87 NUMERIC_MAX_VALUE 16384 88@@ -231,7 +231,7 @@ 89 GLOBAL_VALUE_ORIGIN COMPILE-TIME 90 DEFAULT_VALUE 1 91 VARIABLE_SCOPE SESSION 92-VARIABLE_TYPE BIGINT UNSIGNED 93+VARIABLE_TYPE INT UNSIGNED 94 VARIABLE_COMMENT Number of threads to use when repairing Aria tables. The value of 1 disables parallel repair. 95 NUMERIC_MIN_VALUE 1 96 NUMERIC_MAX_VALUE 128 97@@ -248,7 +248,7 @@ 98 VARIABLE_TYPE BIGINT UNSIGNED 99 VARIABLE_COMMENT The buffer that is allocated when sorting the index when doing a REPAIR or when creating indexes with CREATE INDEX or ALTER TABLE. 100 NUMERIC_MIN_VALUE 4096 101-NUMERIC_MAX_VALUE 18446744073709551615 102+NUMERIC_MAX_VALUE 4294967295 103 NUMERIC_BLOCK_SIZE 1 104 ENUM_VALUE_LIST NULL 105 READ_ONLY NO 106