mirror of
https://github.com/MariaDB/server.git
synced 2025-09-27 11:29:12 +02:00
41510ac17c
Let the user specify innodb_adaptive_hash_index_cells directly, without invoking the inaccurate function ut_find_prime().
378 lines
12 KiB
Text
378 lines
12 KiB
Text
--- a/mysql-test/suite/sys_vars/r/sysvars_innodb.result
|
|
+++ b/mysql-test/suite/sys_vars/r/sysvars_innodb.result
|
|
@@ -51,7 +51,7 @@
|
|
VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT Number of adaptive hash table cells in each partition; 16381 at start defaults to being derived from innodb_buffer_pool_size
|
|
NUMERIC_MIN_VALUE 16381
|
|
-NUMERIC_MAX_VALUE 4294967295
|
|
+NUMERIC_MAX_VALUE 1073741823
|
|
NUMERIC_BLOCK_SIZE 0
|
|
ENUM_VALUE_LIST NULL
|
|
READ_ONLY NO
|
|
@@ -60,7 +60,7 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 8
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT Number of InnoDB Adaptive Hash Index Partitions (default 8)
|
|
NUMERIC_MIN_VALUE 1
|
|
NUMERIC_MAX_VALUE 512
|
|
@@ -96,7 +96,7 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 1
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT
|
|
+VARIABLE_TYPE INT
|
|
VARIABLE_COMMENT The AUTOINC lock modes supported by InnoDB: 0 => Old style AUTOINC locking (for backward compatibility); 1 => New style AUTOINC locking; 2 => No AUTOINC locking (unsafe for SBR)
|
|
NUMERIC_MIN_VALUE 0
|
|
NUMERIC_MAX_VALUE 2
|
|
@@ -108,10 +108,10 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 0
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT Deprecated parameter with no effect
|
|
NUMERIC_MIN_VALUE 0
|
|
-NUMERIC_MAX_VALUE 18446744073709551615
|
|
+NUMERIC_MAX_VALUE 4294967295
|
|
NUMERIC_BLOCK_SIZE 1048576
|
|
ENUM_VALUE_LIST NULL
|
|
READ_ONLY YES
|
|
@@ -144,7 +144,7 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 25
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT Dump only the hottest N% of each buffer pool, defaults to 25
|
|
NUMERIC_MIN_VALUE 1
|
|
NUMERIC_MAX_VALUE 100
|
|
@@ -216,10 +216,10 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 134217728
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT The size of the memory buffer InnoDB uses to cache data and indexes of its tables
|
|
NUMERIC_MIN_VALUE 2097152
|
|
-NUMERIC_MAX_VALUE 18446744073701163008
|
|
+NUMERIC_MAX_VALUE 4292870144
|
|
NUMERIC_BLOCK_SIZE 1048576
|
|
ENUM_VALUE_LIST NULL
|
|
READ_ONLY NO
|
|
@@ -228,11 +228,11 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 0
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT Minimum innodb_buffer_pool_size for dynamic shrinking on memory pressure
|
|
NUMERIC_MIN_VALUE 0
|
|
-NUMERIC_MAX_VALUE 18446744073701163008
|
|
-NUMERIC_BLOCK_SIZE 8388608
|
|
+NUMERIC_MAX_VALUE 4292870144
|
|
+NUMERIC_BLOCK_SIZE 2097152
|
|
ENUM_VALUE_LIST NULL
|
|
READ_ONLY NO
|
|
COMMAND_LINE_ARGUMENT REQUIRED
|
|
@@ -240,11 +240,11 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 0
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT Maximum innodb_buffer_pool_size
|
|
NUMERIC_MIN_VALUE 0
|
|
-NUMERIC_MAX_VALUE 18446744073701163008
|
|
-NUMERIC_BLOCK_SIZE 8388608
|
|
+NUMERIC_MAX_VALUE 4292870144
|
|
+NUMERIC_BLOCK_SIZE 2097152
|
|
ENUM_VALUE_LIST NULL
|
|
READ_ONLY YES
|
|
COMMAND_LINE_ARGUMENT REQUIRED
|
|
@@ -252,7 +252,7 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 0
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT A number that tells how often buffer pool dump status in percentages should be printed. E.g. 10 means that buffer pool dump status is printed when every 10% of number of buffer pool pages are dumped. Default is 0 (only start and end status is printed)
|
|
NUMERIC_MIN_VALUE 0
|
|
NUMERIC_MAX_VALUE 100
|
|
@@ -324,7 +324,7 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 5
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT If the compression failure rate of a table is greater than this number more padding is added to the pages to reduce the failures. A value of zero implies no padding
|
|
NUMERIC_MIN_VALUE 0
|
|
NUMERIC_MAX_VALUE 100
|
|
@@ -348,7 +348,7 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 50
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT Percentage of empty space on a data page that can be reserved to make the page compressible
|
|
NUMERIC_MIN_VALUE 0
|
|
NUMERIC_MAX_VALUE 75
|
|
@@ -588,7 +588,7 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 600
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT Maximum number of seconds that semaphore times out in InnoDB
|
|
NUMERIC_MIN_VALUE 1
|
|
NUMERIC_MAX_VALUE 4294967295
|
|
@@ -636,7 +636,7 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 30
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT Number of iterations over which the background flushing is averaged
|
|
NUMERIC_MIN_VALUE 1
|
|
NUMERIC_MAX_VALUE 1000
|
|
@@ -660,7 +660,7 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 1
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT Controls the durability/speed trade-off for commits. Set to 0 (write and flush redo log to disk only once per second), 1 (flush to disk at each commit), 2 (write to log at commit but flush to disk only once per second) or 3 (flush to disk at prepare and at commit, slower and usually redundant). 1 and 3 guarantees that after a crash, committed transactions will not be lost and will be consistent with the binlog and other transactional engines. 2 can get inconsistent and lose transactions if there is a power failure or kernel crash but not if mysqld crashes. 0 has no guarantees in case of crash. 0 and 2 can be faster than 1 or 3
|
|
NUMERIC_MIN_VALUE 0
|
|
NUMERIC_MAX_VALUE 3
|
|
@@ -684,7 +684,7 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 1
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT Set to 0 (don't flush neighbors from buffer pool), 1 (flush contiguous neighbors from buffer pool) or 2 (flush neighbors from buffer pool), when flushing a block
|
|
NUMERIC_MIN_VALUE 0
|
|
NUMERIC_MAX_VALUE 2
|
|
@@ -720,7 +720,7 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 0
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT Helps to save your data in case the disk image of the database becomes corrupt. Value 5 can return bogus data, and 6 can permanently corrupt data
|
|
NUMERIC_MIN_VALUE 0
|
|
NUMERIC_MAX_VALUE 6
|
|
@@ -744,10 +744,10 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 8000000
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT InnoDB Fulltext search cache size in bytes
|
|
NUMERIC_MIN_VALUE 1600000
|
|
-NUMERIC_MAX_VALUE 1099511627776
|
|
+NUMERIC_MAX_VALUE 536870912
|
|
NUMERIC_BLOCK_SIZE 0
|
|
ENUM_VALUE_LIST NULL
|
|
READ_ONLY NO
|
|
@@ -780,7 +780,7 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 84
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT InnoDB Fulltext search maximum token size in characters
|
|
NUMERIC_MIN_VALUE 10
|
|
NUMERIC_MAX_VALUE 84
|
|
@@ -792,7 +792,7 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 3
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT InnoDB Fulltext search minimum token size in characters
|
|
NUMERIC_MIN_VALUE 0
|
|
NUMERIC_MAX_VALUE 16
|
|
@@ -804,7 +804,7 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 2000
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT InnoDB Fulltext search number of words to optimize for each optimize table call
|
|
NUMERIC_MIN_VALUE 1000
|
|
NUMERIC_MAX_VALUE 10000
|
|
@@ -816,10 +816,10 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 2000000000
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT InnoDB Fulltext search query result cache limit in bytes
|
|
NUMERIC_MIN_VALUE 1000000
|
|
-NUMERIC_MAX_VALUE 18446744073709551615
|
|
+NUMERIC_MAX_VALUE 4294967295
|
|
NUMERIC_BLOCK_SIZE 0
|
|
ENUM_VALUE_LIST NULL
|
|
READ_ONLY NO
|
|
@@ -840,7 +840,7 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 2
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT InnoDB Fulltext search parallel sort degree, will round up to nearest power of 2 number
|
|
NUMERIC_MIN_VALUE 1
|
|
NUMERIC_MAX_VALUE 16
|
|
@@ -852,10 +852,10 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 640000000
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT Total memory allocated for InnoDB Fulltext Search cache
|
|
NUMERIC_MIN_VALUE 32000000
|
|
-NUMERIC_MAX_VALUE 1099511627776
|
|
+NUMERIC_MAX_VALUE 1600000000
|
|
NUMERIC_BLOCK_SIZE 0
|
|
ENUM_VALUE_LIST NULL
|
|
READ_ONLY NO
|
|
@@ -900,7 +900,7 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 200
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT Number of IOPs the server can do. Tunes the background IO rate
|
|
NUMERIC_MIN_VALUE 100
|
|
NUMERIC_MAX_VALUE 4294967295
|
|
@@ -912,7 +912,7 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 4294967295
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT Limit to which innodb_io_capacity can be inflated
|
|
NUMERIC_MIN_VALUE 100
|
|
NUMERIC_MAX_VALUE 4294967295
|
|
@@ -1044,10 +1044,10 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 32
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT Unused
|
|
NUMERIC_MIN_VALUE 1
|
|
-NUMERIC_MAX_VALUE 18446744073709551615
|
|
+NUMERIC_MAX_VALUE 4294967295
|
|
NUMERIC_BLOCK_SIZE 0
|
|
ENUM_VALUE_LIST NULL
|
|
READ_ONLY NO
|
|
@@ -1056,10 +1056,10 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 1536
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT How deep to scan LRU to keep it clean
|
|
NUMERIC_MIN_VALUE 100
|
|
-NUMERIC_MAX_VALUE 18446744073709551615
|
|
+NUMERIC_MAX_VALUE 4294967295
|
|
NUMERIC_BLOCK_SIZE 0
|
|
ENUM_VALUE_LIST NULL
|
|
READ_ONLY NO
|
|
@@ -1092,10 +1092,10 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 0
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT Desired maximum length of the purge queue (0 = no limit)
|
|
NUMERIC_MIN_VALUE 0
|
|
-NUMERIC_MAX_VALUE 18446744073709551615
|
|
+NUMERIC_MAX_VALUE 4294967295
|
|
NUMERIC_BLOCK_SIZE 0
|
|
ENUM_VALUE_LIST NULL
|
|
READ_ONLY NO
|
|
@@ -1104,7 +1104,7 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 0
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT Maximum delay of user threads in micro-seconds
|
|
NUMERIC_MIN_VALUE 0
|
|
NUMERIC_MAX_VALUE 10000000
|
|
@@ -1236,10 +1236,10 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 0
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT How many files at the maximum InnoDB keeps open at the same time
|
|
NUMERIC_MIN_VALUE 0
|
|
-NUMERIC_MAX_VALUE 9223372036854775807
|
|
+NUMERIC_MAX_VALUE 2147483647
|
|
NUMERIC_BLOCK_SIZE 0
|
|
ENUM_VALUE_LIST NULL
|
|
READ_ONLY YES
|
|
@@ -1260,7 +1260,7 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 16384
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT Page size to use for all InnoDB tablespaces
|
|
NUMERIC_MIN_VALUE 4096
|
|
NUMERIC_MAX_VALUE 65536
|
|
@@ -1296,7 +1296,7 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 127
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT Number of UNDO log pages to purge in one batch from the history list
|
|
NUMERIC_MIN_VALUE 1
|
|
NUMERIC_MAX_VALUE 5000
|
|
@@ -1308,7 +1308,7 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 128
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT Unused
|
|
NUMERIC_MIN_VALUE 1
|
|
NUMERIC_MAX_VALUE 128
|
|
@@ -1344,7 +1344,7 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 56
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT Number of pages that must be accessed sequentially for InnoDB to trigger a readahead
|
|
NUMERIC_MIN_VALUE 0
|
|
NUMERIC_MAX_VALUE 64
|
|
@@ -1428,7 +1428,7 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 1048576
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT Memory buffer size for index creation
|
|
NUMERIC_MIN_VALUE 65536
|
|
NUMERIC_MAX_VALUE 67108864
|
|
@@ -1596,10 +1596,10 @@
|
|
SESSION_VALUE NULL
|
|
DEFAULT_VALUE 30
|
|
VARIABLE_SCOPE GLOBAL
|
|
-VARIABLE_TYPE BIGINT UNSIGNED
|
|
+VARIABLE_TYPE INT UNSIGNED
|
|
VARIABLE_COMMENT Count of spin-loop rounds in InnoDB mutexes (30 by default)
|
|
NUMERIC_MIN_VALUE 0
|
|
-NUMERIC_MAX_VALUE 18446744073709551615
|
|
+NUMERIC_MAX_VALUE 4294967295
|
|
NUMERIC_BLOCK_SIZE 0
|
|
ENUM_VALUE_LIST NULL
|
|
READ_ONLY NO
|