summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorOleksandr Byelkin <sanja@mariadb.com>2017-05-10 09:06:03 +0200
committerOleksandr Byelkin <sanja@mariadb.com>2017-05-10 09:06:03 +0200
commit058555e95a24bd1a269ec074b9e8b249edfed2f3 (patch)
tree8fa9c885a601ad17a1f9e8e1aeb863a2d624dac0
parent069d0472b3f5ee07a5f4646fad647a9454c21152 (diff)
downloadmariadb-git-bb-10.2-MDEV-12472.tar.gz
Fix of emulated variables comments to reflect reality.bb-10.2-MDEV-12472
-rw-r--r--mysql-test/suite/sys_vars/r/sysvars_innodb.result504
-rw-r--r--storage/innobase/handler/ha_xtradb.h156
2 files changed, 581 insertions, 79 deletions
diff --git a/mysql-test/suite/sys_vars/r/sysvars_innodb.result b/mysql-test/suite/sys_vars/r/sysvars_innodb.result
index 4822f43fbb2..042f35f04a8 100644
--- a/mysql-test/suite/sys_vars/r/sysvars_innodb.result
+++ b/mysql-test/suite/sys_vars/r/sysvars_innodb.result
@@ -48,6 +48,20 @@ NUMERIC_BLOCK_SIZE NULL
ENUM_VALUE_LIST OFF,ON
READ_ONLY NO
COMMAND_LINE_ARGUMENT OPTIONAL
+VARIABLE_NAME INNODB_ADAPTIVE_HASH_INDEX_PARTITIONS
+SESSION_VALUE NULL
+GLOBAL_VALUE 8
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE 8
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE BIGINT UNSIGNED
+VARIABLE_COMMENT It is an alias for innodb_adaptive_hash_index_parts; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE 1
+NUMERIC_MAX_VALUE 512
+NUMERIC_BLOCK_SIZE 0
+ENUM_VALUE_LIST NULL
+READ_ONLY YES
+COMMAND_LINE_ARGUMENT OPTIONAL
VARIABLE_NAME INNODB_ADAPTIVE_HASH_INDEX_PARTS
SESSION_VALUE NULL
GLOBAL_VALUE 8
@@ -314,6 +328,20 @@ NUMERIC_BLOCK_SIZE NULL
ENUM_VALUE_LIST OFF,ON
READ_ONLY NO
COMMAND_LINE_ARGUMENT REQUIRED
+VARIABLE_NAME INNODB_BUFFER_POOL_POPULATE
+SESSION_VALUE NULL
+GLOBAL_VALUE OFF
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE OFF
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE BOOLEAN
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE NULL
+NUMERIC_MAX_VALUE NULL
+NUMERIC_BLOCK_SIZE NULL
+ENUM_VALUE_LIST OFF,ON
+READ_ONLY YES
+COMMAND_LINE_ARGUMENT NONE
VARIABLE_NAME INNODB_BUFFER_POOL_SIZE
SESSION_VALUE NULL
GLOBAL_VALUE 8388608
@@ -426,6 +454,104 @@ NUMERIC_BLOCK_SIZE NULL
ENUM_VALUE_LIST crc32,strict_crc32,innodb,strict_innodb,none,strict_none
READ_ONLY NO
COMMAND_LINE_ARGUMENT REQUIRED
+VARIABLE_NAME INNODB_CLEANER_EVICTION_FACTOR
+SESSION_VALUE NULL
+GLOBAL_VALUE OFF
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE OFF
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE BOOLEAN
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE NULL
+NUMERIC_MAX_VALUE NULL
+NUMERIC_BLOCK_SIZE NULL
+ENUM_VALUE_LIST OFF,ON
+READ_ONLY NO
+COMMAND_LINE_ARGUMENT OPTIONAL
+VARIABLE_NAME INNODB_CLEANER_FLUSH_CHUNK_SIZE
+SESSION_VALUE NULL
+GLOBAL_VALUE 0
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE 0
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE BIGINT UNSIGNED
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE 0
+NUMERIC_MAX_VALUE 18446744073709551615
+NUMERIC_BLOCK_SIZE 0
+ENUM_VALUE_LIST NULL
+READ_ONLY NO
+COMMAND_LINE_ARGUMENT REQUIRED
+VARIABLE_NAME INNODB_CLEANER_FREE_LIST_LWM
+SESSION_VALUE NULL
+GLOBAL_VALUE 0
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE 0
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE BIGINT UNSIGNED
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE 0
+NUMERIC_MAX_VALUE 100
+NUMERIC_BLOCK_SIZE 0
+ENUM_VALUE_LIST NULL
+READ_ONLY NO
+COMMAND_LINE_ARGUMENT REQUIRED
+VARIABLE_NAME INNODB_CLEANER_LRU_CHUNK_SIZE
+SESSION_VALUE NULL
+GLOBAL_VALUE 0
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE 0
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE BIGINT UNSIGNED
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE 0
+NUMERIC_MAX_VALUE 18446744073709551615
+NUMERIC_BLOCK_SIZE 0
+ENUM_VALUE_LIST NULL
+READ_ONLY NO
+COMMAND_LINE_ARGUMENT REQUIRED
+VARIABLE_NAME INNODB_CLEANER_LSN_AGE_FACTOR
+SESSION_VALUE NULL
+GLOBAL_VALUE DEPRECATED
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE DEPRECATED
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE ENUM
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE NULL
+NUMERIC_MAX_VALUE NULL
+NUMERIC_BLOCK_SIZE NULL
+ENUM_VALUE_LIST LEGACY,HIGH_CHECKPOINT,DEPRECATED
+READ_ONLY NO
+COMMAND_LINE_ARGUMENT OPTIONAL
+VARIABLE_NAME INNODB_CLEANER_MAX_FLUSH_TIME
+SESSION_VALUE NULL
+GLOBAL_VALUE 0
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE 0
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE BIGINT UNSIGNED
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE 0
+NUMERIC_MAX_VALUE 18446744073709551615
+NUMERIC_BLOCK_SIZE 0
+ENUM_VALUE_LIST NULL
+READ_ONLY NO
+COMMAND_LINE_ARGUMENT REQUIRED
+VARIABLE_NAME INNODB_CLEANER_MAX_LRU_TIME
+SESSION_VALUE NULL
+GLOBAL_VALUE 0
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE 0
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE BIGINT UNSIGNED
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE 0
+NUMERIC_MAX_VALUE 18446744073709551615
+NUMERIC_BLOCK_SIZE 0
+ENUM_VALUE_LIST NULL
+READ_ONLY NO
+COMMAND_LINE_ARGUMENT REQUIRED
VARIABLE_NAME INNODB_CMP_PER_INDEX_ENABLED
SESSION_VALUE NULL
GLOBAL_VALUE OFF
@@ -538,6 +664,20 @@ NUMERIC_BLOCK_SIZE 0
ENUM_VALUE_LIST NULL
READ_ONLY NO
COMMAND_LINE_ARGUMENT REQUIRED
+VARIABLE_NAME INNODB_CORRUPT_TABLE_ACTION
+SESSION_VALUE NULL
+GLOBAL_VALUE deprecated
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE deprecated
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE ENUM
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE NULL
+NUMERIC_MAX_VALUE NULL
+NUMERIC_BLOCK_SIZE NULL
+ENUM_VALUE_LIST assert,warn,salvage,deprecated
+READ_ONLY NO
+COMMAND_LINE_ARGUMENT REQUIRED
VARIABLE_NAME INNODB_DATA_FILE_PATH
SESSION_VALUE NULL
GLOBAL_VALUE ibdata1:12M:autoextend
@@ -804,6 +944,20 @@ NUMERIC_BLOCK_SIZE 0
ENUM_VALUE_LIST NULL
READ_ONLY YES
COMMAND_LINE_ARGUMENT OPTIONAL
+VARIABLE_NAME INNODB_EMPTY_FREE_LIST_ALGORITHM
+SESSION_VALUE NULL
+GLOBAL_VALUE DEPRECATED
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE DEPRECATED
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE ENUM
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE NULL
+NUMERIC_MAX_VALUE NULL
+NUMERIC_BLOCK_SIZE NULL
+ENUM_VALUE_LIST LEGACY,BACKOFF,DEPRECATED
+READ_ONLY NO
+COMMAND_LINE_ARGUMENT OPTIONAL
VARIABLE_NAME INNODB_ENCRYPTION_ROTATE_KEY_AGE
SESSION_VALUE NULL
GLOBAL_VALUE 1
@@ -874,6 +1028,20 @@ NUMERIC_BLOCK_SIZE NULL
ENUM_VALUE_LIST OFF,ON,FORCE
READ_ONLY NO
COMMAND_LINE_ARGUMENT OPTIONAL
+VARIABLE_NAME INNODB_FAKE_CHANGES
+SESSION_VALUE OFF
+GLOBAL_VALUE OFF
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE OFF
+VARIABLE_SCOPE SESSION
+VARIABLE_TYPE BOOLEAN
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE NULL
+NUMERIC_MAX_VALUE NULL
+NUMERIC_BLOCK_SIZE NULL
+ENUM_VALUE_LIST OFF,ON
+READ_ONLY NO
+COMMAND_LINE_ARGUMENT OPTIONAL
VARIABLE_NAME INNODB_FAST_SHUTDOWN
SESSION_VALUE NULL
GLOBAL_VALUE 1
@@ -1112,6 +1280,20 @@ NUMERIC_BLOCK_SIZE 0
ENUM_VALUE_LIST NULL
READ_ONLY YES
COMMAND_LINE_ARGUMENT REQUIRED
+VARIABLE_NAME INNODB_FOREGROUND_PREFLUSH
+SESSION_VALUE NULL
+GLOBAL_VALUE DEPRECATED
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE DEPRECATED
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE ENUM
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE NULL
+NUMERIC_MAX_VALUE NULL
+NUMERIC_BLOCK_SIZE NULL
+ENUM_VALUE_LIST SYNC_PREFLUSH,EXPONENTIAL_BACKOFF,DEPRECATED
+READ_ONLY NO
+COMMAND_LINE_ARGUMENT OPTIONAL
VARIABLE_NAME INNODB_FT_AUX_TABLE
SESSION_VALUE NULL
GLOBAL_VALUE
@@ -1350,6 +1532,20 @@ NUMERIC_BLOCK_SIZE 0
ENUM_VALUE_LIST NULL
READ_ONLY NO
COMMAND_LINE_ARGUMENT REQUIRED
+VARIABLE_NAME INNODB_KILL_IDLE_TRANSACTION
+SESSION_VALUE NULL
+GLOBAL_VALUE 0
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE 0
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE BIGINT
+VARIABLE_COMMENT No effect for this build.
+NUMERIC_MIN_VALUE 0
+NUMERIC_MAX_VALUE 9223372036854775807
+NUMERIC_BLOCK_SIZE 0
+ENUM_VALUE_LIST NULL
+READ_ONLY NO
+COMMAND_LINE_ARGUMENT REQUIRED
VARIABLE_NAME INNODB_LARGE_PREFIX
SESSION_VALUE NULL
GLOBAL_VALUE ON
@@ -1378,6 +1574,20 @@ NUMERIC_BLOCK_SIZE 0
ENUM_VALUE_LIST NULL
READ_ONLY NO
COMMAND_LINE_ARGUMENT REQUIRED
+VARIABLE_NAME INNODB_LOCKING_FAKE_CHANGES
+SESSION_VALUE NULL
+GLOBAL_VALUE OFF
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE OFF
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE BOOLEAN
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE NULL
+NUMERIC_MAX_VALUE NULL
+NUMERIC_BLOCK_SIZE NULL
+ENUM_VALUE_LIST OFF,ON
+READ_ONLY NO
+COMMAND_LINE_ARGUMENT NONE
VARIABLE_NAME INNODB_LOCKS_UNSAFE_FOR_BINLOG
SESSION_VALUE NULL
GLOBAL_VALUE OFF
@@ -1420,6 +1630,62 @@ NUMERIC_BLOCK_SIZE 0
ENUM_VALUE_LIST NULL
READ_ONLY NO
COMMAND_LINE_ARGUMENT REQUIRED
+VARIABLE_NAME INNODB_LOG_ARCHIVE
+SESSION_VALUE NULL
+GLOBAL_VALUE OFF
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE OFF
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE BOOLEAN
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE NULL
+NUMERIC_MAX_VALUE NULL
+NUMERIC_BLOCK_SIZE NULL
+ENUM_VALUE_LIST OFF,ON
+READ_ONLY NO
+COMMAND_LINE_ARGUMENT OPTIONAL
+VARIABLE_NAME INNODB_LOG_ARCH_DIR
+SESSION_VALUE NULL
+GLOBAL_VALUE
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE VARCHAR
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE NULL
+NUMERIC_MAX_VALUE NULL
+NUMERIC_BLOCK_SIZE NULL
+ENUM_VALUE_LIST NULL
+READ_ONLY YES
+COMMAND_LINE_ARGUMENT REQUIRED
+VARIABLE_NAME INNODB_LOG_ARCH_EXPIRE_SEC
+SESSION_VALUE NULL
+GLOBAL_VALUE 0
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE 0
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE BIGINT UNSIGNED
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE 0
+NUMERIC_MAX_VALUE 18446744073709551615
+NUMERIC_BLOCK_SIZE 0
+ENUM_VALUE_LIST NULL
+READ_ONLY NO
+COMMAND_LINE_ARGUMENT OPTIONAL
+VARIABLE_NAME INNODB_LOG_BLOCK_SIZE
+SESSION_VALUE NULL
+GLOBAL_VALUE 0
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE 0
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE BIGINT UNSIGNED
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE 0
+NUMERIC_MAX_VALUE 65536
+NUMERIC_BLOCK_SIZE 0
+ENUM_VALUE_LIST NULL
+READ_ONLY YES
+COMMAND_LINE_ARGUMENT REQUIRED
VARIABLE_NAME INNODB_LOG_BUFFER_SIZE
SESSION_VALUE NULL
GLOBAL_VALUE 1048576
@@ -1462,6 +1728,20 @@ NUMERIC_BLOCK_SIZE NULL
ENUM_VALUE_LIST OFF,ON
READ_ONLY NO
COMMAND_LINE_ARGUMENT REQUIRED
+VARIABLE_NAME INNODB_LOG_CHECKSUM_ALGORITHM
+SESSION_VALUE NULL
+GLOBAL_VALUE DEPRECATED
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE DEPRECATED
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE ENUM
+VARIABLE_COMMENT Deprecated and translated to innodb_log_checksums (NONE to OFF, everything else to ON); only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE NULL
+NUMERIC_MAX_VALUE NULL
+NUMERIC_BLOCK_SIZE NULL
+ENUM_VALUE_LIST CRC32,STRICT_CRC32,INNODB,STRICT_INNODB,NONE,STRICT_NONE,DEPRECATED
+READ_ONLY NO
+COMMAND_LINE_ARGUMENT REQUIRED
VARIABLE_NAME INNODB_LOG_COMPRESSED_PAGES
SESSION_VALUE NULL
GLOBAL_VALUE ON
@@ -1560,6 +1840,34 @@ NUMERIC_BLOCK_SIZE NULL
ENUM_VALUE_LIST OFF,ON
READ_ONLY NO
COMMAND_LINE_ARGUMENT OPTIONAL
+VARIABLE_NAME INNODB_MAX_BITMAP_FILE_SIZE
+SESSION_VALUE NULL
+GLOBAL_VALUE 0
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE 0
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE BIGINT UNSIGNED
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE 0
+NUMERIC_MAX_VALUE 18446744073709551615
+NUMERIC_BLOCK_SIZE 0
+ENUM_VALUE_LIST NULL
+READ_ONLY NO
+COMMAND_LINE_ARGUMENT REQUIRED
+VARIABLE_NAME INNODB_MAX_CHANGED_PAGES
+SESSION_VALUE NULL
+GLOBAL_VALUE 0
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE 0
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE BIGINT UNSIGNED
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE 0
+NUMERIC_MAX_VALUE 18446744073709551615
+NUMERIC_BLOCK_SIZE 0
+ENUM_VALUE_LIST NULL
+READ_ONLY NO
+COMMAND_LINE_ARGUMENT REQUIRED
VARIABLE_NAME INNODB_MAX_DIRTY_PAGES_PCT
SESSION_VALUE NULL
GLOBAL_VALUE 75.000000
@@ -1644,6 +1952,20 @@ NUMERIC_BLOCK_SIZE 0
ENUM_VALUE_LIST NULL
READ_ONLY NO
COMMAND_LINE_ARGUMENT REQUIRED
+VARIABLE_NAME INNODB_MIRRORED_LOG_GROUPS
+SESSION_VALUE NULL
+GLOBAL_VALUE 0
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE 0
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE BIGINT UNSIGNED
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE 0
+NUMERIC_MAX_VALUE 10
+NUMERIC_BLOCK_SIZE 0
+ENUM_VALUE_LIST NULL
+READ_ONLY YES
+COMMAND_LINE_ARGUMENT REQUIRED
VARIABLE_NAME INNODB_MONITOR_DISABLE
SESSION_VALUE NULL
GLOBAL_VALUE
@@ -1868,6 +2190,62 @@ NUMERIC_BLOCK_SIZE NULL
ENUM_VALUE_LIST OFF,ON
READ_ONLY NO
COMMAND_LINE_ARGUMENT OPTIONAL
+VARIABLE_NAME INNODB_PRIORITY_CLEANER
+SESSION_VALUE NULL
+GLOBAL_VALUE OFF
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE OFF
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE BOOLEAN
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE NULL
+NUMERIC_MAX_VALUE NULL
+NUMERIC_BLOCK_SIZE NULL
+ENUM_VALUE_LIST OFF,ON
+READ_ONLY NO
+COMMAND_LINE_ARGUMENT OPTIONAL
+VARIABLE_NAME INNODB_PRIORITY_IO
+SESSION_VALUE NULL
+GLOBAL_VALUE OFF
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE OFF
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE BOOLEAN
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE NULL
+NUMERIC_MAX_VALUE NULL
+NUMERIC_BLOCK_SIZE NULL
+ENUM_VALUE_LIST OFF,ON
+READ_ONLY NO
+COMMAND_LINE_ARGUMENT OPTIONAL
+VARIABLE_NAME INNODB_PRIORITY_MASTER
+SESSION_VALUE NULL
+GLOBAL_VALUE OFF
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE OFF
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE BOOLEAN
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE NULL
+NUMERIC_MAX_VALUE NULL
+NUMERIC_BLOCK_SIZE NULL
+ENUM_VALUE_LIST OFF,ON
+READ_ONLY NO
+COMMAND_LINE_ARGUMENT OPTIONAL
+VARIABLE_NAME INNODB_PRIORITY_PURGE
+SESSION_VALUE NULL
+GLOBAL_VALUE OFF
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE OFF
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE BOOLEAN
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE NULL
+NUMERIC_MAX_VALUE NULL
+NUMERIC_BLOCK_SIZE NULL
+ENUM_VALUE_LIST OFF,ON
+READ_ONLY NO
+COMMAND_LINE_ARGUMENT OPTIONAL
VARIABLE_NAME INNODB_PURGE_BATCH_SIZE
SESSION_VALUE NULL
GLOBAL_VALUE 300
@@ -2050,6 +2428,48 @@ NUMERIC_BLOCK_SIZE 0
ENUM_VALUE_LIST NULL
READ_ONLY NO
COMMAND_LINE_ARGUMENT OPTIONAL
+VARIABLE_NAME INNODB_SCHED_PRIORITY_IO
+SESSION_VALUE NULL
+GLOBAL_VALUE 0
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE 0
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE BIGINT UNSIGNED
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE 0
+NUMERIC_MAX_VALUE 39
+NUMERIC_BLOCK_SIZE 0
+ENUM_VALUE_LIST NULL
+READ_ONLY NO
+COMMAND_LINE_ARGUMENT REQUIRED
+VARIABLE_NAME INNODB_SCHED_PRIORITY_MASTER
+SESSION_VALUE NULL
+GLOBAL_VALUE 0
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE 0
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE BIGINT UNSIGNED
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE 0
+NUMERIC_MAX_VALUE 39
+NUMERIC_BLOCK_SIZE 0
+ENUM_VALUE_LIST NULL
+READ_ONLY NO
+COMMAND_LINE_ARGUMENT REQUIRED
+VARIABLE_NAME INNODB_SCHED_PRIORITY_PURGE
+SESSION_VALUE NULL
+GLOBAL_VALUE 0
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE 0
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE BIGINT UNSIGNED
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE 0
+NUMERIC_MAX_VALUE 39
+NUMERIC_BLOCK_SIZE 0
+ENUM_VALUE_LIST NULL
+READ_ONLY NO
+COMMAND_LINE_ARGUMENT REQUIRED
VARIABLE_NAME INNODB_SCRUB_LOG
SESSION_VALUE NULL
GLOBAL_VALUE OFF
@@ -2078,6 +2498,34 @@ NUMERIC_BLOCK_SIZE 0
ENUM_VALUE_LIST NULL
READ_ONLY NO
COMMAND_LINE_ARGUMENT OPTIONAL
+VARIABLE_NAME INNODB_SHOW_LOCKS_HELD
+SESSION_VALUE NULL
+GLOBAL_VALUE 0
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE 0
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE BIGINT UNSIGNED
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE 0
+NUMERIC_MAX_VALUE 1000
+NUMERIC_BLOCK_SIZE 0
+ENUM_VALUE_LIST NULL
+READ_ONLY NO
+COMMAND_LINE_ARGUMENT REQUIRED
+VARIABLE_NAME INNODB_SHOW_VERBOSE_LOCKS
+SESSION_VALUE NULL
+GLOBAL_VALUE 0
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE 0
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE BIGINT UNSIGNED
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE 0
+NUMERIC_MAX_VALUE 1
+NUMERIC_BLOCK_SIZE 0
+ENUM_VALUE_LIST NULL
+READ_ONLY NO
+COMMAND_LINE_ARGUMENT REQUIRED
VARIABLE_NAME INNODB_SIMULATE_COMP_FAILURES
SESSION_VALUE NULL
GLOBAL_VALUE 0
@@ -2428,6 +2876,34 @@ NUMERIC_BLOCK_SIZE NULL
ENUM_VALUE_LIST NULL
READ_ONLY NO
COMMAND_LINE_ARGUMENT OPTIONAL
+VARIABLE_NAME INNODB_TRACK_CHANGED_PAGES
+SESSION_VALUE NULL
+GLOBAL_VALUE OFF
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE OFF
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE BOOLEAN
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE NULL
+NUMERIC_MAX_VALUE NULL
+NUMERIC_BLOCK_SIZE NULL
+ENUM_VALUE_LIST OFF,ON
+READ_ONLY YES
+COMMAND_LINE_ARGUMENT NONE
+VARIABLE_NAME INNODB_TRACK_REDO_LOG_NOW
+SESSION_VALUE NULL
+GLOBAL_VALUE OFF
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE OFF
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE BOOLEAN
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE NULL
+NUMERIC_MAX_VALUE NULL
+NUMERIC_BLOCK_SIZE NULL
+ENUM_VALUE_LIST OFF,ON
+READ_ONLY NO
+COMMAND_LINE_ARGUMENT OPTIONAL
VARIABLE_NAME INNODB_TRX_PURGE_VIEW_UPDATE_ONLY_DEBUG
SESSION_VALUE NULL
GLOBAL_VALUE OFF
@@ -2540,6 +3016,20 @@ NUMERIC_BLOCK_SIZE NULL
ENUM_VALUE_LIST OFF,ON
READ_ONLY YES
COMMAND_LINE_ARGUMENT NONE
+VARIABLE_NAME INNODB_USE_GLOBAL_FLUSH_LOG_AT_TRX_COMMIT
+SESSION_VALUE NULL
+GLOBAL_VALUE OFF
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE OFF
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE BOOLEAN
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE NULL
+NUMERIC_MAX_VALUE NULL
+NUMERIC_BLOCK_SIZE NULL
+ENUM_VALUE_LIST OFF,ON
+READ_ONLY NO
+COMMAND_LINE_ARGUMENT NONE
VARIABLE_NAME INNODB_USE_MTFLUSH
SESSION_VALUE NULL
GLOBAL_VALUE OFF
@@ -2554,6 +3044,20 @@ NUMERIC_BLOCK_SIZE NULL
ENUM_VALUE_LIST OFF,ON
READ_ONLY YES
COMMAND_LINE_ARGUMENT NONE
+VARIABLE_NAME INNODB_USE_STACKTRACE
+SESSION_VALUE NULL
+GLOBAL_VALUE OFF
+GLOBAL_VALUE_ORIGIN COMPILE-TIME
+DEFAULT_VALUE OFF
+VARIABLE_SCOPE GLOBAL
+VARIABLE_TYPE BOOLEAN
+VARIABLE_COMMENT Deprecated and ignored; only exists to allow easier upgrade from earlier XtraDB versions.
+NUMERIC_MIN_VALUE NULL
+NUMERIC_MAX_VALUE NULL
+NUMERIC_BLOCK_SIZE NULL
+ENUM_VALUE_LIST OFF,ON
+READ_ONLY YES
+COMMAND_LINE_ARGUMENT NONE
VARIABLE_NAME INNODB_USE_TRIM
SESSION_VALUE NULL
GLOBAL_VALUE ON
diff --git a/storage/innobase/handler/ha_xtradb.h b/storage/innobase/handler/ha_xtradb.h
index 13d077ad41b..09628b7ec48 100644
--- a/storage/innobase/handler/ha_xtradb.h
+++ b/storage/innobase/handler/ha_xtradb.h
@@ -94,14 +94,15 @@ Each partition is protected by its own latch and so we have parts number
of latches protecting complete search system. */
static MYSQL_SYSVAR_ULONG(adaptive_hash_index_partitions, btr_ahi_parts,
PLUGIN_VAR_OPCMDARG | PLUGIN_VAR_READONLY,
- "Number of InnoDB Adaptive Hash Index Partitions (default 8)",
+ "It is an alias for innodb_adaptive_hash_index_parts; "
+ "only exists to allow easier upgrade from earlier XtraDB versions.",
NULL, NULL, 8, 1, 512, 0);
#endif /* BTR_CUR_HASH_ADAPT */
static MYSQL_SYSVAR_BOOL(buffer_pool_populate, innodb_buffer_pool_populate,
PLUGIN_VAR_NOCMDARG | PLUGIN_VAR_READONLY,
- "Deprecated. This option has no effect and "
- "will be removed in MariaDB 10.3.",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, NULL, FALSE);
#if defined UNIV_DEBUG || defined UNIV_PERF_DEBUG
@@ -117,8 +118,8 @@ set_cleaner_max_lru_time(THD*thd, st_mysql_sys_var*, void*, const void*)
/* Original default 1000 */
static MYSQL_SYSVAR_ULONG(cleaner_max_lru_time, srv_cleaner_max_lru_time,
PLUGIN_VAR_RQCMDARG,
- "Deprecated. The maximum time limit for a single LRU tail flush iteration by the page "
- "cleaner thread in miliseconds",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, set_cleaner_max_lru_time, 0, 0, ~0UL, 0);
static
@@ -133,8 +134,8 @@ set_cleaner_max_flush_time(THD*thd, st_mysql_sys_var*, void*, const void*)
/* Original default 1000 */
static MYSQL_SYSVAR_ULONG(cleaner_max_flush_time, srv_cleaner_max_flush_time,
PLUGIN_VAR_RQCMDARG,
- "The maximum time limit for a single flush list flush iteration by the page "
- "cleaner thread in miliseconds",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, &set_cleaner_max_flush_time, 0, 0, ~0UL, 0);
static
@@ -150,7 +151,8 @@ set_cleaner_flush_chunk_size(THD*thd, st_mysql_sys_var*, void*, const void*)
static MYSQL_SYSVAR_ULONG(cleaner_flush_chunk_size,
srv_cleaner_flush_chunk_size,
PLUGIN_VAR_RQCMDARG,
- "Divide page cleaner flush list flush batches into chunks of this size",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, &set_cleaner_flush_chunk_size, 0, 0, ~0UL, 0);
static
@@ -166,7 +168,8 @@ set_cleaner_lru_chunk_size(THD*thd, st_mysql_sys_var*, void*, const void*)
static MYSQL_SYSVAR_ULONG(cleaner_lru_chunk_size,
srv_cleaner_lru_chunk_size,
PLUGIN_VAR_RQCMDARG,
- "Divide page cleaner LRU list flush batches into chunks of this size",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, &set_cleaner_lru_chunk_size, 0, 0, ~0UL, 0);
static
@@ -181,8 +184,8 @@ set_cleaner_free_list_lwm(THD* thd, st_mysql_sys_var*, void*, const void*)
/* Original default 10 */
static MYSQL_SYSVAR_ULONG(cleaner_free_list_lwm, srv_cleaner_free_list_lwm,
PLUGIN_VAR_RQCMDARG,
- "Page cleaner will keep on flushing the same buffer pool instance if its "
- "free list length is below this percentage of innodb_lru_scan_depth",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, &set_cleaner_free_list_lwm, 0, 0, 100, 0);
static
@@ -196,8 +199,8 @@ set_cleaner_eviction_factor(THD* thd, st_mysql_sys_var*, void*, const void*)
}
static MYSQL_SYSVAR_BOOL(cleaner_eviction_factor, srv_cleaner_eviction_factor,
PLUGIN_VAR_OPCMDARG,
- "Make page cleaner LRU flushes use evicted instead of flushed page counts "
- "for its heuristics",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, &set_cleaner_eviction_factor, FALSE);
#endif /* defined UNIV_DEBUG || defined UNIV_PERF_DEBUG */
@@ -273,9 +276,8 @@ set_cleaner_lsn_age_factor(THD* thd, st_mysql_sys_var*, void*, const void*)
static MYSQL_SYSVAR_ENUM(cleaner_lsn_age_factor,
srv_cleaner_lsn_age_factor,
PLUGIN_VAR_OPCMDARG,
- "Deprecated. The formula for LSN age factor for page cleaner adaptive flushing. "
- "LEGACY: Original Oracle MySQL 5.6 formula. "
- "HIGH_CHECKPOINT: (the default) Percona Server 5.6 formula.",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, &set_cleaner_lsn_age_factor, SRV_CLEANER_LSN_AGE_FACTOR_DEPRECATED,
&innodb_cleaner_lsn_age_factor_typelib);
@@ -306,10 +308,8 @@ set_corrupt_table_action(THD* thd, st_mysql_sys_var*, void*, const void*)
}
static MYSQL_SYSVAR_ENUM(corrupt_table_action, srv_pass_corrupt_table,
PLUGIN_VAR_RQCMDARG,
- "Deprecated. Warn corruptions of user tables as 'corrupt table' instead of not crashing itself, "
- "when used with file_per_table. "
- "All file io for the datafile after detected as corrupt are disabled, "
- "except for the deletion.",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, &set_corrupt_table_action, 3, &corrupt_table_action_typelib);
/* Added new default DEPRECATED */
@@ -341,9 +341,8 @@ set_empty_free_list_algorithm(THD* thd, st_mysql_sys_var*, void*, const void*)
static MYSQL_SYSVAR_ENUM(empty_free_list_algorithm,
srv_empty_free_list_algorithm,
PLUGIN_VAR_OPCMDARG,
- "Deprecated. The algorithm to use for empty free list handling. Allowed values: "
- "LEGACY: Original Oracle MySQL 5.6 handling with single page flushes; "
- "BACKOFF: (default) Wait until cleaner produces a free page.",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, &set_empty_free_list_algorithm, SRV_EMPTY_FREE_LIST_DEPRECATED,
&innodb_empty_free_list_algorithm_typelib);
@@ -357,15 +356,15 @@ set_fake_changes(THD* thd, st_mysql_sys_var*, void*, const void*)
"innodb_fake_changes");
}
static MYSQL_THDVAR_BOOL(fake_changes, PLUGIN_VAR_OPCMDARG,
- "Deprecated. In the transaction after enabled, UPDATE, INSERT and DELETE only move the cursor to the records "
- "and do nothing other operations (no changes, no ibuf, no undo, no transaction log) in the transaction. "
- "This is to cause replication prefetch IO. ATTENTION: the transaction started after enabled is affected.",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, &set_fake_changes, FALSE);
/* Original default, min 4. */
static MYSQL_SYSVAR_ULONG(file_io_threads, innobase_file_io_threads,
PLUGIN_VAR_RQCMDARG | PLUGIN_VAR_READONLY | PLUGIN_VAR_NOSYSVAR,
- "Deprecated. Number of file I/O threads in InnoDB.",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, NULL, 0, 0, 64, 0);
/** Possible values for system variable "innodb_foreground_preflush". */
@@ -395,10 +394,8 @@ set_foreground_preflush(THD* thd, st_mysql_sys_var*, void*, const void*)
}
static MYSQL_SYSVAR_ENUM(foreground_preflush, srv_foreground_preflush,
PLUGIN_VAR_OPCMDARG,
- "Deprecated: The algorithm InnoDB uses for the query threads at sync preflush. "
- "Possible values are "
- "SYNC_PREFLUSH: perform a sync preflush as Oracle MySQL; "
- "EXPONENTIAL_BACKOFF: (default) wait for the page cleaner flush.",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, &set_foreground_preflush, SRV_FOREGROUND_PREFLUSH_DEPRECATED,
&innodb_foreground_preflush_typelib);
@@ -432,14 +429,15 @@ set_locking_fake_changes(THD* thd, st_mysql_sys_var*, void*, const void*)
/* Original default: TRUE */
static MYSQL_SYSVAR_BOOL(locking_fake_changes, srv_fake_changes_locks,
PLUGIN_VAR_NOCMDARG,
- "Deprecated. ###EXPERIMENTAL### if enabled, transactions will get S row locks instead "
- "of X locks for fake changes. If disabled, fake change transactions will "
- "not take any locks at all.",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, &set_locking_fake_changes, FALSE);
static MYSQL_SYSVAR_STR(log_arch_dir, innobase_log_arch_dir,
PLUGIN_VAR_RQCMDARG | PLUGIN_VAR_READONLY,
- "Deprecated. Where full logs should be archived.", NULL, NULL, NULL);
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
+ NULL, NULL, NULL);
static
void
@@ -452,7 +450,8 @@ set_log_archive(THD* thd, st_mysql_sys_var*, void*, const void*)
}
static MYSQL_SYSVAR_BOOL(log_archive, innobase_log_archive,
PLUGIN_VAR_OPCMDARG,
- "Deprecated. Set to 1 if you want to have logs archived.",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, &set_log_archive, FALSE);
static
@@ -466,13 +465,15 @@ set_log_arch_expire_sec(THD* thd, st_mysql_sys_var*, void*, const void*)
}
static MYSQL_SYSVAR_ULONG(log_arch_expire_sec,
srv_log_arch_expire_sec, PLUGIN_VAR_OPCMDARG,
- "Deprecated. Expiration time for archived innodb transaction logs.",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, &set_log_arch_expire_sec, 0, 0, ~0UL, 0);
/* Original default, min 512 */
static MYSQL_SYSVAR_ULONG(log_block_size, innobase_log_block_size,
PLUGIN_VAR_RQCMDARG | PLUGIN_VAR_READONLY,
- "Deprecated. ###EXPERIMENTAL###: The log block size of the transaction log file. Changing for created log file is not supported. Use on your own risk!",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, NULL, 0, 0,
(1 << UNIV_PAGE_SIZE_SHIFT_MAX), 0);
@@ -521,26 +522,9 @@ set_log_checksum_algorithm(THD* thd, st_mysql_sys_var*, void*, const void* save)
}
static MYSQL_SYSVAR_ENUM(log_checksum_algorithm, srv_log_checksum_algorithm,
PLUGIN_VAR_RQCMDARG,
- "Deprecated. The algorithm InnoDB uses for log block checksums. Possible values are "
- "CRC32 (hardware accelerated if the CPU supports it) "
- "write crc32, allow any of the other checksums to match when reading; "
- "STRICT_CRC32 "
- "write crc32, do not allow other algorithms to match when reading; "
- "INNODB "
- "write a software calculated checksum, allow any other checksums "
- "to match when reading; "
- "STRICT_INNODB "
- "write a software calculated checksum, do not allow other algorithms "
- "to match when reading; "
- "NONE "
- "write a constant magic number, do not do any checksum verification "
- "when reading (same as innodb_checksums=OFF); "
- "STRICT_NONE "
- "write a constant magic number, do not allow values other than that "
- "magic number when reading; "
- "Logs created when this option is set to crc32/strict_crc32/none/strict_none "
- "will not be readable by any MySQL version or Percona Server versions that do"
- "not support this feature",
+ "Deprecated and translated to innodb_log_checksums (NONE to OFF, "
+ "everything else to ON); only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, &set_log_checksum_algorithm, SRV_CHECKSUM_ALGORITHM_DEPRECATED,
&innodb_checksum_algorithm_typelib2);
@@ -556,7 +540,8 @@ set_max_bitmap_file_size(THD* thd, st_mysql_sys_var*, void*, const void*)
/* Original default 100M, min 4K */
static MYSQL_SYSVAR_ULONGLONG(max_bitmap_file_size, srv_max_bitmap_file_size,
PLUGIN_VAR_RQCMDARG,
- "Deprecated. The maximum size of changed page bitmap files",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, &set_max_bitmap_file_size, 0, 0, ULONGLONG_MAX, 0);
static
@@ -571,16 +556,16 @@ set_max_changed_pages(THD* thd, st_mysql_sys_var*, void*, const void*)
/* Original default 1000000 */
static MYSQL_SYSVAR_ULONGLONG(max_changed_pages, srv_max_changed_pages,
PLUGIN_VAR_RQCMDARG,
- "Deprecated. The maximum number of rows for "
- "INFORMATION_SCHEMA.INNODB_CHANGED_PAGES table, "
- "0 - unlimited",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, &set_max_changed_pages, 0, 0, ~0ULL, 0);
/* Note that the default and minimum values are set to 0 to
detect if the option is passed and print deprecation message */
static MYSQL_SYSVAR_ULONG(mirrored_log_groups, innobase_mirrored_log_groups,
PLUGIN_VAR_RQCMDARG | PLUGIN_VAR_READONLY,
- "Number of identical copies of log groups we keep for the database. Currently this should be set to 1.",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, NULL, 0, 0, 10, 0);
#ifdef UNIV_LINUX
@@ -597,7 +582,8 @@ set_sched_priority_cleaner(THD* thd, st_mysql_sys_var*, void*, const void*)
/* Original default 19 */
static MYSQL_SYSVAR_ULONG(sched_priority_cleaner, srv_sched_priority_cleaner,
PLUGIN_VAR_RQCMDARG,
- "Deprecated. Nice value for the cleaner and LRU manager thread scheduling",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, &set_sched_priority_cleaner, 0, 0, 39, 0);
#if defined UNIV_DEBUG || defined UNIV_PERF_DEBUG
@@ -612,8 +598,8 @@ set_priority_cleaner(THD* thd, st_mysql_sys_var*, void*, const void*)
}
static MYSQL_SYSVAR_BOOL(priority_cleaner, srv_cleaner_thread_priority,
PLUGIN_VAR_OPCMDARG,
- "Deprecated. Make buffer pool cleaner and LRU manager threads acquire shared resources "
- "with priority",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, &set_priority_cleaner, FALSE);
static
@@ -627,7 +613,8 @@ set_priority_io(THD* thd, st_mysql_sys_var*, void*, const void*)
}
static MYSQL_SYSVAR_BOOL(priority_io, srv_io_thread_priority,
PLUGIN_VAR_OPCMDARG,
- "Deprecated. Make I/O threads acquire shared resources with priority",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, &set_priority_io, FALSE);
static
@@ -641,7 +628,8 @@ set_priority_master(THD* thd, st_mysql_sys_var*, void*, const void*)
}
static MYSQL_SYSVAR_BOOL(priority_master, srv_master_thread_priority,
PLUGIN_VAR_OPCMDARG,
- "Make buffer pool cleaner thread acquire shared resources with priority",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, &set_priority_master, FALSE);
static
@@ -655,8 +643,9 @@ set_priority_purge(THD* thd, st_mysql_sys_var*, void*, const void*)
}
static MYSQL_SYSVAR_BOOL(priority_purge, srv_purge_thread_priority,
PLUGIN_VAR_OPCMDARG,
- "Deprecated. Make purge coordinator and worker threads acquire shared resources with "
- "priority", NULL, &set_priority_purge, FALSE);
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
+ NULL, &set_priority_purge, FALSE);
static
void
@@ -670,7 +659,8 @@ set_sched_priority_io(THD* thd, st_mysql_sys_var*, void*, const void*)
/* Original default 19 */
static MYSQL_SYSVAR_ULONG(sched_priority_io, srv_sched_priority_io,
PLUGIN_VAR_RQCMDARG,
- "Deprecated. Nice value for the I/O handler thread scheduling",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, &set_sched_priority_io, 0, 0, 39, 0);
static
@@ -685,7 +675,8 @@ set_sched_priority_master(THD* thd, st_mysql_sys_var*, void*, const void*)
/* Original default 19 */
static MYSQL_SYSVAR_ULONG(sched_priority_master, srv_sched_priority_master,
PLUGIN_VAR_RQCMDARG,
- "Deprecated. Nice value for the master thread scheduling",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, &set_sched_priority_master, 0, 0, 39, 0);
static
@@ -700,7 +691,8 @@ set_sched_priority_purge(THD* thd, st_mysql_sys_var*, void*, const void*)
/* Original default 19 */
static MYSQL_SYSVAR_ULONG(sched_priority_purge, srv_sched_priority_purge,
PLUGIN_VAR_RQCMDARG,
- "Deprecated. Nice value for the purge thread scheduling",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, &set_sched_priority_purge, 0, 0, 39, 0);
#endif /* UNIV_DEBUG || UNIV_PERF_DEBUG */
#endif /* UNIV_LINUX */
@@ -717,7 +709,8 @@ set_show_locks_held(THD* thd, st_mysql_sys_var*, void*, const void*)
/* TODO: Implement */
static MYSQL_SYSVAR_ULONG(show_locks_held, srv_show_locks_held,
PLUGIN_VAR_RQCMDARG,
- "Number of locks held to print for each InnoDB transaction in SHOW INNODB STATUS.",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, &set_show_locks_held, 0, 0, 1000, 0);
static
@@ -732,12 +725,14 @@ set_show_verbose_locks(THD* thd, st_mysql_sys_var*, void*, const void*)
/* TODO: Implement */
static MYSQL_SYSVAR_ULONG(show_verbose_locks, srv_show_verbose_locks,
PLUGIN_VAR_RQCMDARG,
- "Whether to show records locked in SHOW INNODB STATUS.",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, &set_show_verbose_locks, 0, 0, 1, 0);
static MYSQL_SYSVAR_BOOL(track_changed_pages, srv_track_changed_pages,
PLUGIN_VAR_NOCMDARG | PLUGIN_VAR_READONLY,
- "Deprecated. Track the redo log for changed pages and output a changed page bitmap",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, NULL, FALSE);
static
@@ -752,7 +747,8 @@ set_track_redo_log_now(THD* thd, st_mysql_sys_var*, void*, const void*)
static MYSQL_SYSVAR_BOOL(track_redo_log_now,
innodb_track_redo_log_now,
PLUGIN_VAR_OPCMDARG,
- "Deprecated. Force log tracker to catch up with checkpoint now",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, &set_track_redo_log_now, FALSE);
static
@@ -766,12 +762,14 @@ set_use_global_flush_log_at_trx_commit(THD* thd, st_mysql_sys_var*, void*, const
}
static MYSQL_SYSVAR_BOOL(use_global_flush_log_at_trx_commit, srv_use_global_flush_log_at_trx_commit,
PLUGIN_VAR_NOCMDARG,
- "Deprecated. Use global innodb_flush_log_at_trx_commit value.",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, &set_use_global_flush_log_at_trx_commit, FALSE);
static MYSQL_SYSVAR_BOOL(use_stacktrace, srv_use_stacktrace,
PLUGIN_VAR_NOCMDARG | PLUGIN_VAR_READONLY,
- "Deprecated. Print stacktrace on long semaphore wait (off by default supported only on linux)",
+ "Deprecated and ignored; only exists to allow easier upgrade from "
+ "earlier XtraDB versions.",
NULL, NULL, FALSE);
/** Print deprecation message for a given system variable.