[Commits] fefc25bd03e: Merge branch '10.0' into 10.1

1 Feb 2019

revision-id: fefc25bd03e34d775ab7de875dd050792d73bd1a (mariadb-10.1.37-86-gfefc25bd03e)
parent(s): a193c5720ea461ce82390af3fe9c292581242223 d9d83f1d92b696ef56f4944df036b8a78364ebb4
author: Oleksandr Byelkin
committer: Oleksandr Byelkin
timestamp: 2019-02-01 12:35:00 +0100
message:

Merge branch '10.0' into 10.1


 CMakeLists.txt                                     |   10 +-
 client/mysqltest.cc                                |    7 +-
 cmake/build_configurations/mysql_release.cmake     |    1 -
 cmake/ssl.cmake                                    |   10 +-
 config.h.cmake                                     |    6 +-
 include/my_valgrind.h                              |    4 +-
 include/mysql.h                                    |    2 +-
 include/mysql.h.pp                                 |    2 +-
 mysql-test/disabled.def                            |    2 +
 mysql-test/r/alter_table.test                      | 1908 ----------------
 mysql-test/r/grant.test                            | 2291 --------------------
 mysql-test/r/lowercase_fs_off.test                 |  124 --
 mysql-test/r/mysql.result                          |   26 +
 mysql-test/r/row-checksum-old.result               |   16 +
 mysql-test/r/row-checksum.result                   |   16 +
 mysql-test/r/sp-security.test                      | 1069 ---------
 mysql-test/r/subselect2.result                     |   22 +
 mysql-test/r/subselect_mat.result                  |   16 +
 mysql-test/r/type_float.test                       |  417 ----
 mysql-test/suite/innodb/r/foreign_key.result       |   33 +
 mysql-test/suite/innodb/t/foreign_key.test         |   31 +
 .../perfschema/r/dml_setup_instruments.result      |    4 +-
 .../suite/perfschema/t/dml_setup_instruments.test  |    5 +-
 mysql-test/suite/rpl/r/rpl_set_statement.test      |    0
 .../sys_vars/r/sysvars_innodb,32bit,xtradb.rdiff   |    4 +-
 .../suite/sys_vars/r/sysvars_innodb,xtradb.rdiff   |    4 +-
 mysql-test/suite/sys_vars/r/sysvars_innodb.result  |    2 +-
 mysql-test/t/mysql.test                            |   22 +
 mysql-test/t/row-checksum.test                     |   17 +
 mysql-test/t/subselect2.test                       |   20 +
 mysql-test/t/subselect_mat.test                    |   13 +
 mysys/my_file.c                                    |    7 +-
 scripts/mysql_install_db.sh                        |   19 +-
 sql-common/client.c                                |   30 +-
 sql/CMakeLists.txt                                 |    2 +-
 sql/log.cc                                         |    6 +-
 sql/mysql_install_db.cc                            |   72 +-
 sql/sql_lex.cc                                     |    3 +-
 sql/sql_repl.cc                                    |    6 +-
 sql/sql_table.cc                                   |   69 +-
 sql/sql_yacc.yy                                    |   22 +-
 storage/connect/global.h                           |    6 +-
 storage/connect/ha_connect.cc                      |    4 +-
 storage/connect/jsonudf.cpp                        |   12 +-
 .../mysql-test/connect/r/jdbc_oracle.result        |   18 +-
 .../mysql-test/connect/r/jdbc_postgresql.result    |   10 +-
 .../connect/mysql-test/connect/r/part_table.result |    4 +-
 .../connect/mysql-test/connect/t/part_table.test   |    2 +-
 storage/connect/plugutil.cpp                       |   28 +-
 storage/connect/reldef.cpp                         |   11 +-
 storage/connect/tabfmt.h                           |    2 +-
 storage/connect/tabjson.cpp                        |   52 +-
 storage/connect/tabjson.h                          |    8 +-
 storage/connect/tabodbc.cpp                        |  317 +--
 storage/connect/tabxml.cpp                         |  292 +--
 storage/connect/tabxml.h                           |    6 +-
 storage/connect/user_connect.cc                    |    4 +-
 storage/innobase/handler/handler0alter.cc          |   84 +-
 storage/innobase/include/univ.i                    |    2 +-
 storage/innobase/row/row0mysql.cc                  |    3 -
 storage/tokudb/PerconaFT/COPYING.APACHEv2          |  174 ++
 storage/tokudb/PerconaFT/README.md                 |    5 +-
 storage/tokudb/PerconaFT/ft/txn/txn_manager.h      |    4 +-
 .../tokudb/PerconaFT/locktree/concurrent_tree.cc   |   14 +
 .../tokudb/PerconaFT/locktree/concurrent_tree.h    |   14 +
 storage/tokudb/PerconaFT/locktree/keyrange.cc      |   13 +
 storage/tokudb/PerconaFT/locktree/keyrange.h       |   13 +
 storage/tokudb/PerconaFT/locktree/lock_request.cc  |   13 +
 storage/tokudb/PerconaFT/locktree/lock_request.h   |   13 +
 storage/tokudb/PerconaFT/locktree/locktree.cc      |   13 +
 storage/tokudb/PerconaFT/locktree/locktree.h       |   13 +
 storage/tokudb/PerconaFT/locktree/manager.cc       |   13 +
 storage/tokudb/PerconaFT/locktree/range_buffer.cc  |   13 +
 storage/tokudb/PerconaFT/locktree/range_buffer.h   |   13 +
 storage/tokudb/PerconaFT/locktree/treenode.cc      |   13 +
 storage/tokudb/PerconaFT/locktree/treenode.h       |   13 +
 storage/tokudb/PerconaFT/locktree/txnid_set.cc     |   13 +
 storage/tokudb/PerconaFT/locktree/txnid_set.h      |   13 +
 storage/tokudb/PerconaFT/locktree/wfg.cc           |   13 +
 storage/tokudb/PerconaFT/locktree/wfg.h            |   13 +
 .../PerconaFT/portability/toku_instr_mysql.cc      |   12 +-
 .../PerconaFT/portability/toku_instr_mysql.h       |   11 +-
 .../tokudb/PerconaFT/portability/toku_pthread.h    |   78 +-
 storage/tokudb/PerconaFT/util/growable_array.h     |   13 +
 storage/tokudb/PerconaFT/util/omt.cc               | 2261 ++++++++++---------
 storage/tokudb/PerconaFT/util/omt.h                |   13 +
 storage/tokudb/ha_tokudb.cc                        |   10 +
 storage/tokudb/hatoku_hton.cc                      |    4 +-
 storage/tokudb/hatoku_hton.h                       |    1 -
 .../tokudb/mysql-test/tokudb_bugs/r/PS-4979.result |    2 +
 .../tokudb/mysql-test/tokudb_bugs/t/PS-4979.test   |   13 +
 storage/tokudb/tokudb_background.cc                |    4 +-
 storage/tokudb/tokudb_sysvars.cc                   |   14 +-
 storage/tokudb/tokudb_sysvars.h                    |    4 +-
 storage/xtradb/handler/handler0alter.cc            |   84 +-
 storage/xtradb/include/univ.i                      |    4 +-
 storage/xtradb/log/log0online.cc                   |   41 +-
 storage/xtradb/row/row0mysql.cc                    |   12 -
 support-files/mysql.server.sh                      |    6 +-
 unittest/mysys/thr_template.c                      |    4 +-
 win/packaging/heidisql.cmake                       |    2 +-
 101 files changed, 2761 insertions(+), 7443 deletions(-)

diff --cc CMakeLists.txt
index 53d67813b5c,92c1f9ef060..ef8786aff12

--- a/CMakeLists.txt
+++ b/CMakeLists.txt
@@@ -235,14 -252,27 +235,20 @@@ SET(CMAKE_CXX_FLAGS_DEBUG "${CMAKE_CXX_
  SET(CMAKE_C_FLAGS_DEBUG "${CMAKE_C_FLAGS_DEBUG} -DENABLED_DEBUG_SYNC")
   
  OPTION(ENABLE_GCOV "Enable gcov (debug, Linux builds only)" OFF)
 -IF (ENABLE_GCOV AND NOT WIN32 AND NOT APPLE)
 -  SET(CMAKE_CXX_FLAGS_DEBUG "${CMAKE_CXX_FLAGS_DEBUG} -fprofile-arcs -ftest-coverage")
 -  SET(CMAKE_C_FLAGS_DEBUG "${CMAKE_C_FLAGS_DEBUG} -fprofile-arcs -ftest-coverage")
 -  SET(CMAKE_EXE_LINKER_FLAGS_DEBUG "${CMAKE_EXE_LINKER_FLAGS_DEBUG} -fprofile-arcs -ftest-coverage -lgcov")
 +IF (ENABLE_GCOV)
 +  MY_CHECK_AND_SET_COMPILER_FLAG("-fprofile-arcs -ftest-coverage -lgcov" DEBUG)
  ENDIF()
  
 -MY_CHECK_C_COMPILER_FLAG(-ggdb3 HAVE_GGDB3)
 -IF(HAVE_GGDB3)
 -  SET(CMAKE_C_FLAGS_DEBUG "${CMAKE_C_FLAGS_DEBUG} -ggdb3")
 -  SET(CMAKE_CXX_FLAGS_DEBUG "${CMAKE_CXX_FLAGS_DEBUG} -ggdb3")
 -ENDIF(HAVE_GGDB3)
 +MY_CHECK_AND_SET_COMPILER_FLAG(-ggdb3 DEBUG)
  
- OPTION(ENABLED_LOCAL_INFILE
-  "If we should should enable LOAD DATA LOCAL by default" ${IF_WIN})
+ SET(ENABLED_LOCAL_INFILE "AUTO" CACHE STRING "If we should should enable LOAD DATA LOCAL by default (OFF/ON/AUTO)")
 -MARK_AS_ADVANCED(ENABLED_LOCAL_INFILE)
+ IF (ENABLED_LOCAL_INFILE MATCHES "^(0|FALSE)$")
+   SET(ENABLED_LOCAL_INFILE OFF)
+ ELSEIF(ENABLED_LOCAL_INFILE MATCHES "^(1|TRUE)$")
+   SET(ENABLED_LOCAL_INFILE ON)
+ ELSEIF (NOT ENABLED_LOCAL_INFILE MATCHES "^(ON|OFF|AUTO)$")
+   MESSAGE(FATAL_ERROR "ENABLED_LOCAL_INFILE must be one of OFF, ON, AUTO")
+ ENDIF()
  
  OPTION(WITH_FAST_MUTEXES "Compile with fast mutexes" OFF)
  MARK_AS_ADVANCED(WITH_FAST_MUTEXES)
diff --cc cmake/build_configurations/mysql_release.cmake
index 04860a40dbb,b82b87b6237..b73b44cddc3
--- a/cmake/build_configurations/mysql_release.cmake
+++ b/cmake/build_configurations/mysql_release.cmake
@@@ -81,13 -82,21 +81,12 @@@ IF(FEATURE_SET
     # better no set this, otherwise server would be linked 
     # statically with experimental stuff like audit_null
    ENDIF()
 -  
 -  # Update cache with current values, remove engines we do not care about
 -  # from build.
 -  FOREACH(eng ARCHIVE BLACKHOLE FEDERATED INNOBASE PARTITION)
 -    IF(NOT WITH_${eng}_STORAGE_ENGINE)
 -      SET(WITHOUT_${eng}_STORAGE_ENGINE ON CACHE BOOL "")
 -      MARK_AS_ADVANCED(WITHOUT_${eng}_STORAGE_ENGINE)
 -      SET(WITH_${eng}_STORAGE_ENGINE OFF CACHE BOOL "")
 -    ELSE()
 -     SET(WITH_${eng}_STORAGE_ENGINE ON CACHE BOOL "")
 -    ENDIF()
 -  ENDFOREACH()
  ENDIF()
  
- OPTION(ENABLED_LOCAL_INFILE "" ON)
 -IF(RPM)
 +SET(WITH_INNODB_SNAPPY OFF CACHE STRING "")
 +IF(WIN32)
 +  SET(WITH_LIBARCHIVE STATIC CACHE STRING "")
 +ELSEIF(RPM)
    SET(WITH_SSL system CACHE STRING "")
    SET(WITH_ZLIB system CACHE STRING "")
    SET(CHECKMODULE /usr/bin/checkmodule CACHE STRING "")
diff --cc cmake/ssl.cmake
index 24e18600402,6985932d165..308f725a02d
--- a/cmake/ssl.cmake
+++ b/cmake/ssl.cmake
@@@ -173,17 -173,31 +173,25 @@@ MACRO (MYSQL_CHECK_SSL
          "^.*OPENSSL_VERSION_NUMBER[\t ]+0x([0-9][0-9][0-9]).*$" "\\1"
          OPENSSL_MAJOR_VERSION "${OPENSSL_VERSION_NUMBER}"
        )
 -      INCLUDE(CheckSymbolExists)
 -      INCLUDE(CheckCSourceCompiles)
 -      SET(CMAKE_REQUIRED_INCLUDES ${OPENSSL_INCLUDE_DIR})
 -      CHECK_SYMBOL_EXISTS(SHA512_DIGEST_LENGTH "openssl/sha.h"
 -                          HAVE_SHA512_DIGEST_LENGTH)
 -      CHECK_C_SOURCE_COMPILES("
 -        #include <openssl/dh.h>
 -        int main()
 -        {
 -          DH dh;
 -          return sizeof(dh.version);
 -        }" OLD_OPENSSL_API)
 -
 -      SET(OPENSSL_FOUND TRUE)
 -    ELSE()
 -      SET(OPENSSL_FOUND FALSE)
 -    ENDIF()
 -
 -    IF(OPENSSL_FOUND AND OLD_OPENSSL_API AND
 -       HAVE_SHA512_DIGEST_LENGTH)
 -      MESSAGE(STATUS "OPENSSL_INCLUDE_DIR = ${OPENSSL_INCLUDE_DIR}")
 -      MESSAGE(STATUS "OPENSSL_LIBRARIES = ${OPENSSL_LIBRARIES}")
 -      MESSAGE(STATUS "CRYPTO_LIBRARY = ${CRYPTO_LIBRARY}")
        MESSAGE(STATUS "OPENSSL_MAJOR_VERSION = ${OPENSSL_MAJOR_VERSION}")
 +    ENDIF()
  
 +    INCLUDE(CheckSymbolExists)
++    INCLUDE(CheckCSourceCompiles)
 +    SET(CMAKE_REQUIRED_INCLUDES ${OPENSSL_INCLUDE_DIR})
 +    CHECK_SYMBOL_EXISTS(SHA512_DIGEST_LENGTH "openssl/sha.h" 
 +                        HAVE_SHA512_DIGEST_LENGTH)
++    CHECK_C_SOURCE_COMPILES("
++      #include <openssl/dh.h>
++      int main()
++      {
++        DH dh;
++        return sizeof(dh.version);
++      }" OLD_OPENSSL_API)
 +    SET(CMAKE_REQUIRED_INCLUDES)
 +    IF(OPENSSL_INCLUDE_DIR AND OPENSSL_LIBRARIES AND
-        OPENSSL_MAJOR_VERSION STRLESS "101" AND
++       OLD_OPENSSL_API AND
 +       CRYPTO_LIBRARY AND HAVE_SHA512_DIGEST_LENGTH)
  
        SET(SSL_SOURCES "")
        SET(SSL_LIBRARIES ${OPENSSL_LIBRARIES} ${CRYPTO_LIBRARY})
diff --cc config.h.cmake
index 52d837fad2a,c22638a6cc0..3750ab717f8
--- a/config.h.cmake
+++ b/config.h.cmake
@@@ -544,9 -536,14 +544,13 @@@
  /*
    MySQL features
  */
- #cmakedefine ENABLED_LOCAL_INFILE 1
+ #define LOCAL_INFILE_MODE_OFF  0
+ #define LOCAL_INFILE_MODE_ON   1
+ #define LOCAL_INFILE_MODE_AUTO 2
+ #define ENABLED_LOCAL_INFILE LOCAL_INFILE_MODE_@ENABLED_LOCAL_INFILE@
+ 
  #cmakedefine ENABLED_PROFILING 1
  #cmakedefine EXTRA_DEBUG 1
 -#cmakedefine BACKUP_TEST 1
  #cmakedefine CYBOZU 1
  #cmakedefine USE_SYMDIR 1
  
diff --cc mysql-test/disabled.def
index b489139a59f,9292081b45e..b72f07d0345
--- a/mysql-test/disabled.def
+++ b/mysql-test/disabled.def
@@@ -17,7 -17,6 +17,9 @@@ mysql_embedded           : Bug#1256129
  ssl_crl_clients_valid    : broken upstream
  ssl_crl                  : broken upstream
  ssl_crl_clrpath          : broken upstream
 +innodb-wl5522-debug-zip  : broken upstream
 +innodb_bug12902967       : broken upstream
  file_contents            : MDEV-6526 these files are not installed anymore
 +max_statement_time       : cannot possibly work, depends on timing
+ lowercase_fs_on          : lower_case_table_names=0 is not an error until 10.1
+ partition_open_files_limit : open_files_limit check broken by MDEV-18360
diff --cc mysql-test/r/subselect_mat.result
index ac117093133,7907b86135e..6fae057dd17
--- a/mysql-test/r/subselect_mat.result
+++ b/mysql-test/r/subselect_mat.result
@@@ -2865,17 -2823,18 +2865,33 @@@ SELECT * FROM t2 WHERE f IN ( SELECT LE
  f
  DROP TABLE t1, t2;
  #
+ # MDEV-18255: Server crashes in Bitmap<64u>::intersect
+ #
+ create table t1 (v1 varchar(1)) engine=myisam ;
+ create table t2 (v1 varchar(1)) engine=myisam ;
+ explain
+ select 1 from t1 where exists
+ (select 1 from t1 where t1.v1 in (select t2.v1 from t2 having t2.v1 < 'j')) ;
+ id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
+ 1	PRIMARY	NULL	NULL	NULL	NULL	NULL	NULL	NULL	Impossible WHERE
+ 2	SUBQUERY	NULL	NULL	NULL	NULL	NULL	NULL	NULL	no matching row in const table
+ 3	MATERIALIZED	NULL	NULL	NULL	NULL	NULL	NULL	NULL	no matching row in const table
+ select 1 from t1 where exists
+ (select 1 from t1 where t1.v1 in (select t2.v1 from t2 having t2.v1 < 'j')) ;
+ 1
+ drop table t1,t2;
++#
 +# MDEV-9489: Assertion `0' failed in Protocol::end_statement() on
 +# UNION ALL
 +#
 +CREATE TABLE t1 (f1 INT);
 +CREATE TABLE t2 (f2 INT);
 +INSERT INTO t1 VALUES (1),(2);
 +( SELECT 1 FROM t1 WHERE f1 NOT IN ( SELECT f2 FROM t2 ) LIMIT 0 )
 +UNION ALL
 +( SELECT 1 FROM t1 WHERE f1 NOT IN ( SELECT f2 FROM t2 ) )
 +;
 +1
 +1
 +1
 +drop table t1, t2;
diff --cc mysql-test/suite/perfschema/r/dml_setup_instruments.result
index ce1cdf1884e,8d561c48828..14ed8eb2def
--- a/mysql-test/suite/perfschema/r/dml_setup_instruments.result
+++ b/mysql-test/suite/perfschema/r/dml_setup_instruments.result
@@@ -11,12 -11,14 +11,14 @@@ wait/synch/mutex/sql/gtid_waiting::LOCK
  wait/synch/mutex/sql/hash_filo::lock	YES	YES
  wait/synch/mutex/sql/HA_DATA_PARTITION::LOCK_auto_inc	YES	YES
  wait/synch/mutex/sql/LOCK_active_mi	YES	YES
 +wait/synch/mutex/sql/LOCK_after_binlog_sync	YES	YES
  wait/synch/mutex/sql/LOCK_audit_mask	YES	YES
  wait/synch/mutex/sql/LOCK_binlog_state	YES	YES
 -wait/synch/mutex/sql/LOCK_commit_ordered	YES	YES
  select * from performance_schema.setup_instruments
  where name like 'Wait/Synch/Rwlock/sql/%'
-   and name not in ('wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock')
+   and name not in (
+ 'wait/synch/rwlock/sql/CRYPTO_dynlock_value::lock',
+ 'wait/synch/rwlock/sql/LOCK_named_pipe_full_access_group')
  order by name limit 10;
  NAME	ENABLED	TIMED
  wait/synch/rwlock/sql/LOCK_dboptions	YES	YES
diff --cc mysql-test/suite/sys_vars/r/sysvars_innodb,32bit,xtradb.rdiff
index 73dd57ed1fb,00000000000..2019c4dc616
mode 100644,000000..100644
--- a/mysql-test/suite/sys_vars/r/sysvars_innodb,32bit,xtradb.rdiff
+++ b/mysql-test/suite/sys_vars/r/sysvars_innodb,32bit,xtradb.rdiff
@@@ -1,1236 -1,0 +1,1236 @@@
 +--- suite/sys_vars/r/sysvars_innodb.result
 ++++ suite/sys_vars/r/sysvars_innodb,32bit.reject
 +@@ -47,13 +47,27 @@
 + ENUM_VALUE_LIST	OFF,ON
 + READ_ONLY	NO
 + COMMAND_LINE_ARGUMENT	OPTIONAL
 ++VARIABLE_NAME	INNODB_ADAPTIVE_HASH_INDEX_PARTITIONS
 ++SESSION_VALUE	NULL
 ++GLOBAL_VALUE	1
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	1
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	INT UNSIGNED
 ++VARIABLE_COMMENT	Number of InnoDB adaptive hash index partitions (default 1: disable partitioning)
 ++NUMERIC_MIN_VALUE	1
 ++NUMERIC_MAX_VALUE	32
 ++NUMERIC_BLOCK_SIZE	0
 ++ENUM_VALUE_LIST	NULL
 ++READ_ONLY	YES
 ++COMMAND_LINE_ARGUMENT	REQUIRED
 + VARIABLE_NAME	INNODB_ADAPTIVE_MAX_SLEEP_DELAY
 + SESSION_VALUE	NULL
 + GLOBAL_VALUE	150000
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	150000
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_TYPE	INT UNSIGNED
 + VARIABLE_COMMENT	The upper limit of the sleep delay in usec. Value of 0 disables it.
 + NUMERIC_MIN_VALUE	0
 + NUMERIC_MAX_VALUE	1000000
 +@@ -67,10 +81,10 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	8388608
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT
 ++VARIABLE_TYPE	INT
 + VARIABLE_COMMENT	DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. Size of a memory pool InnoDB uses to store data dictionary information and other internal data structures.
 + NUMERIC_MIN_VALUE	524288
 +-NUMERIC_MAX_VALUE	9223372036854775807
 ++NUMERIC_MAX_VALUE	2147483647
 + NUMERIC_BLOCK_SIZE	1024
 + ENUM_VALUE_LIST	NULL
 + READ_ONLY	YES
 +@@ -81,7 +95,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	5
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_TYPE	INT UNSIGNED
 + VARIABLE_COMMENT	Background commit interval in seconds
 + NUMERIC_MIN_VALUE	1
 + NUMERIC_MAX_VALUE	1073741824
 +@@ -137,7 +151,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	0
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_TYPE	INT UNSIGNED
 + VARIABLE_COMMENT	InnoDB API transaction isolation level
 + NUMERIC_MIN_VALUE	0
 + NUMERIC_MAX_VALUE	3
 +@@ -151,7 +165,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	64
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_TYPE	INT UNSIGNED
 + VARIABLE_COMMENT	Data file autoextend increment in megabytes
 + NUMERIC_MIN_VALUE	1
 + NUMERIC_MAX_VALUE	1000
 +@@ -165,7 +179,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + 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
 +@@ -263,7 +277,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	100
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_TYPE	INT UNSIGNED
 + VARIABLE_COMMENT	Dump only the hottest N% of each buffer pool, defaults to 100
 + NUMERIC_MIN_VALUE	1
 + NUMERIC_MAX_VALUE	100
 +@@ -305,7 +319,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	0
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT
 ++VARIABLE_TYPE	INT
 + VARIABLE_COMMENT	Number of buffer pool instances, set to higher value on high-end machines to increase scalability
 + NUMERIC_MIN_VALUE	0
 + NUMERIC_MAX_VALUE	64
 +@@ -355,6 +369,20 @@
 + 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. This option has no effect and will be removed in MariaDB 10.2.3.
 ++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
 +@@ -375,7 +403,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	0
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_TYPE	INT UNSIGNED
 + VARIABLE_COMMENT	A number between [0, 100] that tells how oftern 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
 +@@ -446,7 +474,7 @@
 + DEFAULT_VALUE	ON
 + VARIABLE_SCOPE	GLOBAL
 + VARIABLE_TYPE	BOOLEAN
 +-VARIABLE_COMMENT	DEPRECATED. Use innodb_checksum_algorithm=NONE instead of setting this to OFF. Enable InnoDB checksums validation (enabled by default). Disable with --skip-innodb-checksums.
 ++VARIABLE_COMMENT	DEPRECATED. Use innodb_checksum_algorithm=NONE instead of setting this to OFF
 + NUMERIC_MIN_VALUE	NULL
 + NUMERIC_MAX_VALUE	NULL
 + NUMERIC_BLOCK_SIZE	NULL
 +@@ -467,6 +495,104 @@
 + 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	Make page cleaner LRU flushes use evicted instead of flushed page counts for its heuristics
 ++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	100
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	100
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	INT UNSIGNED
 ++VARIABLE_COMMENT	Divide page cleaner flush list flush batches into chunks of this size
 ++NUMERIC_MIN_VALUE	1
 ++NUMERIC_MAX_VALUE	4294967295
 ++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	10
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	10
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	INT UNSIGNED
 ++VARIABLE_COMMENT	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
 ++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	100
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	100
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	INT UNSIGNED
 ++VARIABLE_COMMENT	Divide page cleaner LRU list flush batches into chunks of this size
 ++NUMERIC_MIN_VALUE	1
 ++NUMERIC_MAX_VALUE	4294967295
 ++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	HIGH_CHECKPOINT
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	HIGH_CHECKPOINT
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	ENUM
 ++VARIABLE_COMMENT	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.
 ++NUMERIC_MIN_VALUE	NULL
 ++NUMERIC_MAX_VALUE	NULL
 ++NUMERIC_BLOCK_SIZE	NULL
 ++ENUM_VALUE_LIST	LEGACY,HIGH_CHECKPOINT
 ++READ_ONLY	NO
 ++COMMAND_LINE_ARGUMENT	OPTIONAL
 ++VARIABLE_NAME	INNODB_CLEANER_MAX_FLUSH_TIME
 ++SESSION_VALUE	NULL
 ++GLOBAL_VALUE	1000
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	1000
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	INT UNSIGNED
 ++VARIABLE_COMMENT	The maximum time limit for a single flush list flush iteration by the page cleaner thread in miliseconds
 ++NUMERIC_MIN_VALUE	0
 ++NUMERIC_MAX_VALUE	4294967295
 ++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	1000
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	1000
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	INT UNSIGNED
 ++VARIABLE_COMMENT	The maximum time limit for a single LRU tail flush iteration by the page cleaner thread in miliseconds
 ++NUMERIC_MIN_VALUE	0
 ++NUMERIC_MAX_VALUE	4294967295
 ++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
 +@@ -487,7 +613,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	0
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_TYPE	INT UNSIGNED
 + VARIABLE_COMMENT	Helps in performance tuning in heavily concurrent environments.
 + NUMERIC_MIN_VALUE	0
 + NUMERIC_MAX_VALUE	1000
 +@@ -515,7 +641,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + 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
 +@@ -543,7 +669,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + 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
 +@@ -557,14 +683,28 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	5000
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_TYPE	INT UNSIGNED
 + VARIABLE_COMMENT	Number of times a thread is allowed to enter InnoDB within the same SQL query after it has once got the ticket
 + NUMERIC_MIN_VALUE	1
 +-NUMERIC_MAX_VALUE	18446744073709551615
 ++NUMERIC_MAX_VALUE	4294967295
 + 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	assert
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	assert
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	ENUM
 ++VARIABLE_COMMENT	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.
 ++NUMERIC_MIN_VALUE	NULL
 ++NUMERIC_MAX_VALUE	NULL
 ++NUMERIC_BLOCK_SIZE	NULL
 ++ENUM_VALUE_LIST	assert,warn,salvage
 ++READ_ONLY	NO
 ++COMMAND_LINE_ARGUMENT	REQUIRED
 + VARIABLE_NAME	INNODB_DATA_FILE_PATH
 + SESSION_VALUE	NULL
 + GLOBAL_VALUE	ibdata1:12M:autoextend
 +@@ -781,7 +921,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	120
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_TYPE	INT UNSIGNED
 + VARIABLE_COMMENT	Number of pages reserved in doublewrite buffer for batch flushing
 + NUMERIC_MIN_VALUE	1
 + NUMERIC_MAX_VALUE	127
 +@@ -789,6 +929,20 @@
 + ENUM_VALUE_LIST	NULL
 + READ_ONLY	YES
 + COMMAND_LINE_ARGUMENT	OPTIONAL
 ++VARIABLE_NAME	INNODB_EMPTY_FREE_LIST_ALGORITHM
 ++SESSION_VALUE	NULL
 ++GLOBAL_VALUE	LEGACY
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	BACKOFF
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	ENUM
 ++VARIABLE_COMMENT	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.
 ++NUMERIC_MIN_VALUE	NULL
 ++NUMERIC_MAX_VALUE	NULL
 ++NUMERIC_BLOCK_SIZE	NULL
 ++ENUM_VALUE_LIST	LEGACY,BACKOFF
 ++READ_ONLY	NO
 ++COMMAND_LINE_ARGUMENT	OPTIONAL
 + VARIABLE_NAME	INNODB_ENCRYPTION_ROTATE_KEY_AGE
 + SESSION_VALUE	NULL
 + GLOBAL_VALUE	1
 +@@ -859,13 +1013,27 @@
 + 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	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.
 ++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
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	1
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_TYPE	INT UNSIGNED
 + VARIABLE_COMMENT	Speeds up the shutdown process of the InnoDB storage engine. Possible values are 0, 1 (faster) or 2 (fastest - crash-like).
 + NUMERIC_MIN_VALUE	0
 + NUMERIC_MAX_VALUE	2
 +@@ -879,7 +1047,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + 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
 +@@ -949,7 +1117,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	0
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_TYPE	INT UNSIGNED
 + VARIABLE_COMMENT	Make the first page of the given tablespace dirty.
 + NUMERIC_MIN_VALUE	0
 + NUMERIC_MAX_VALUE	4294967295
 +@@ -963,7 +1131,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + 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
 +@@ -986,12 +1154,12 @@
 + READ_ONLY	NO
 + COMMAND_LINE_ARGUMENT	OPTIONAL
 + VARIABLE_NAME	INNODB_FLUSH_LOG_AT_TRX_COMMIT
 +-SESSION_VALUE	NULL
 ++SESSION_VALUE	1
 + GLOBAL_VALUE	1
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	1
 +-VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_SCOPE	SESSION
 ++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
 +@@ -1019,7 +1187,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + 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
 +@@ -1061,7 +1229,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + 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.
 + NUMERIC_MIN_VALUE	0
 + NUMERIC_MAX_VALUE	6
 +@@ -1069,6 +1237,20 @@
 + ENUM_VALUE_LIST	NULL
 + READ_ONLY	YES
 + COMMAND_LINE_ARGUMENT	REQUIRED
 ++VARIABLE_NAME	INNODB_FOREGROUND_PREFLUSH
 ++SESSION_VALUE	NULL
 ++GLOBAL_VALUE	EXPONENTIAL_BACKOFF
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	EXPONENTIAL_BACKOFF
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	ENUM
 ++VARIABLE_COMMENT	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.
 ++NUMERIC_MIN_VALUE	NULL
 ++NUMERIC_MAX_VALUE	NULL
 ++NUMERIC_BLOCK_SIZE	NULL
 ++ENUM_VALUE_LIST	SYNC_PREFLUSH,EXPONENTIAL_BACKOFF
 ++READ_ONLY	NO
 ++COMMAND_LINE_ARGUMENT	OPTIONAL
 + VARIABLE_NAME	INNODB_FT_AUX_TABLE
 + SESSION_VALUE	NULL
 + GLOBAL_VALUE	
 +@@ -1089,7 +1271,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + 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	80000000
 +@@ -1131,7 +1313,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + 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
 +@@ -1145,7 +1327,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + 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
 +@@ -1159,7 +1341,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + 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
 +@@ -1173,10 +1355,10 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + 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
 +@@ -1201,7 +1383,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + 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
 +@@ -1215,7 +1397,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + 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	1600000000
 +@@ -1243,7 +1425,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	100
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_TYPE	INT UNSIGNED
 + VARIABLE_COMMENT	Up to what percentage of dirty pages should be flushed when innodb finds it has spare resources to do so.
 + NUMERIC_MIN_VALUE	0
 + NUMERIC_MAX_VALUE	100
 +@@ -1285,10 +1467,10 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + 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	18446744073709551615
 ++NUMERIC_MAX_VALUE	4294967295
 + NUMERIC_BLOCK_SIZE	0
 + ENUM_VALUE_LIST	NULL
 + READ_ONLY	NO
 +@@ -1297,12 +1479,26 @@
 + SESSION_VALUE	NULL
 + GLOBAL_VALUE	2000
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +-DEFAULT_VALUE	18446744073709551615
 ++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	18446744073709551615
 ++NUMERIC_MAX_VALUE	4294967295
 ++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	2147483647
 + NUMERIC_BLOCK_SIZE	0
 + ENUM_VALUE_LIST	NULL
 + READ_ONLY	NO
 +@@ -1335,6 +1531,20 @@
 + ENUM_VALUE_LIST	NULL
 + READ_ONLY	NO
 + COMMAND_LINE_ARGUMENT	REQUIRED
 ++VARIABLE_NAME	INNODB_LOCKING_FAKE_CHANGES
 ++SESSION_VALUE	NULL
 ++GLOBAL_VALUE	ON
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	ON
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	BOOLEAN
 ++VARIABLE_COMMENT	###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.
 ++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
 +@@ -1369,7 +1579,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	50
 + VARIABLE_SCOPE	SESSION
 +-VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_TYPE	INT UNSIGNED
 + VARIABLE_COMMENT	Timeout in seconds an InnoDB transaction may wait for a lock before being rolled back. Values above 100000000 disable the timeout.
 + NUMERIC_MIN_VALUE	1
 + NUMERIC_MAX_VALUE	1073741824
 +@@ -1377,16 +1587,72 @@
 + 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	Set to 1 if you want to have logs archived.
 ++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	PATH
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	VARCHAR
 ++VARIABLE_COMMENT	Where full logs should be archived.
 ++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	INT UNSIGNED
 ++VARIABLE_COMMENT	Expiration time for archived innodb transaction logs.
 ++NUMERIC_MIN_VALUE	0
 ++NUMERIC_MAX_VALUE	4294967295
 ++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	512
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	512
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	INT UNSIGNED
 ++VARIABLE_COMMENT	###EXPERIMENTAL###: The log block size of the transaction log file. Changing for created log file is not supported. Use on your own risk!
 ++NUMERIC_MIN_VALUE	512
 ++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
 + GLOBAL_VALUE_ORIGIN	CONFIG
 + DEFAULT_VALUE	16777216
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT
 ++VARIABLE_TYPE	INT
 + VARIABLE_COMMENT	The size of the buffer which InnoDB uses to write log to the log files on disk.
 + NUMERIC_MIN_VALUE	262144
 +-NUMERIC_MAX_VALUE	9223372036854775807
 ++NUMERIC_MAX_VALUE	2147483647
 + NUMERIC_BLOCK_SIZE	1024
 + ENUM_VALUE_LIST	NULL
 + READ_ONLY	YES
 +@@ -1405,6 +1671,20 @@
 + ENUM_VALUE_LIST	OFF,ON
 + READ_ONLY	NO
 + COMMAND_LINE_ARGUMENT	OPTIONAL
 ++VARIABLE_NAME	INNODB_LOG_CHECKSUM_ALGORITHM
 ++SESSION_VALUE	NULL
 ++GLOBAL_VALUE	INNODB
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	INNODB
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	ENUM
 ++VARIABLE_COMMENT	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 donot support this feature
 ++NUMERIC_MIN_VALUE	NULL
 ++NUMERIC_MAX_VALUE	NULL
 ++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_LOG_COMPRESSED_PAGES
 + SESSION_VALUE	NULL
 + GLOBAL_VALUE	ON
 +@@ -1425,7 +1705,7 @@
 + GLOBAL_VALUE_ORIGIN	CONFIG
 + DEFAULT_VALUE	2
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_TYPE	INT UNSIGNED
 + VARIABLE_COMMENT	Number of log files in the log group. InnoDB writes to the files in a circular fashion.
 + NUMERIC_MIN_VALUE	2
 + NUMERIC_MAX_VALUE	100
 +@@ -1467,9 +1747,37 @@
 + GLOBAL_VALUE_ORIGIN	CONFIG
 + DEFAULT_VALUE	1024
 + 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	4294967295
 ++NUMERIC_BLOCK_SIZE	0
 ++ENUM_VALUE_LIST	NULL
 ++READ_ONLY	NO
 ++COMMAND_LINE_ARGUMENT	REQUIRED
 ++VARIABLE_NAME	INNODB_MAX_BITMAP_FILE_SIZE
 ++SESSION_VALUE	NULL
 ++GLOBAL_VALUE	104857600
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	104857600
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_COMMENT	The maximum size of changed page bitmap files
 ++NUMERIC_MIN_VALUE	4096
 ++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	1000000
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	1000000
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_COMMENT	The maximum number of rows for INFORMATION_SCHEMA.INNODB_CHANGED_PAGES table, 0 - unlimited
 ++NUMERIC_MIN_VALUE	0
 + NUMERIC_MAX_VALUE	18446744073709551615
 + NUMERIC_BLOCK_SIZE	0
 + ENUM_VALUE_LIST	NULL
 +@@ -1509,10 +1817,10 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + 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
 +@@ -1523,7 +1831,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + 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
 +@@ -1537,7 +1845,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	0
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT
 ++VARIABLE_TYPE	INT
 + VARIABLE_COMMENT	Number of identical copies of log groups we keep for the database. Currently this should be set to 1.
 + NUMERIC_MIN_VALUE	0
 + NUMERIC_MAX_VALUE	10
 +@@ -1607,7 +1915,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	8
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT
 ++VARIABLE_TYPE	INT
 + VARIABLE_COMMENT	Number of multi-threaded flush threads
 + NUMERIC_MIN_VALUE	1
 + NUMERIC_MAX_VALUE	64
 +@@ -1659,14 +1967,14 @@
 + COMMAND_LINE_ARGUMENT	REQUIRED
 + VARIABLE_NAME	INNODB_OPEN_FILES
 + SESSION_VALUE	NULL
 +-GLOBAL_VALUE	2000
 ++GLOBAL_VALUE	300
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	0
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT
 ++VARIABLE_TYPE	INT
 + 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
 +@@ -1691,7 +1999,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	16
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_TYPE	INT UNSIGNED
 + VARIABLE_COMMENT	Number of rw_locks protecting buffer pool page_hash. Rounded up to the next power of 2
 + NUMERIC_MIN_VALUE	1
 + NUMERIC_MAX_VALUE	1024
 +@@ -1705,7 +2013,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + 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
 +@@ -1741,13 +2049,83 @@
 + ENUM_VALUE_LIST	OFF,ON
 + READ_ONLY	NO
 + COMMAND_LINE_ARGUMENT	OPTIONAL
 ++VARIABLE_NAME	INNODB_PRINT_LOCK_WAIT_TIMEOUT_INFO
 ++SESSION_VALUE	NULL
 ++GLOBAL_VALUE	OFF
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	OFF
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	BOOLEAN
 ++VARIABLE_COMMENT	Print lock wait timeout info to MySQL error log (off by default)
 ++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_CLEANER
 ++SESSION_VALUE	NULL
 ++GLOBAL_VALUE	OFF
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	OFF
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	BOOLEAN
 ++VARIABLE_COMMENT	Make buffer pool cleaner and LRU manager threads acquire shared resources with priority
 ++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	Make I/O threads acquire shared resources with priority
 ++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	Make buffer pool cleaner thread acquire shared resources with priority
 ++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	Make purge coordinator and worker threads acquire shared resources with priority
 ++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
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	300
 + 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
 +@@ -1789,7 +2167,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	1
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_TYPE	INT UNSIGNED
 + VARIABLE_COMMENT	Purge threads can be from 1 to 32. Default is 1.
 + NUMERIC_MIN_VALUE	1
 + NUMERIC_MAX_VALUE	32
 +@@ -1817,7 +2195,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + 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
 +@@ -1831,7 +2209,7 @@
 + GLOBAL_VALUE_ORIGIN	CONFIG
 + DEFAULT_VALUE	4
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_TYPE	INT UNSIGNED
 + VARIABLE_COMMENT	Number of background read I/O threads in InnoDB.
 + NUMERIC_MIN_VALUE	1
 + NUMERIC_MAX_VALUE	64
 +@@ -1859,10 +2237,10 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	0
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_TYPE	INT UNSIGNED
 + VARIABLE_COMMENT	Replication thread delay (ms) on the slave server if innodb_thread_concurrency is reached (0 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
 +@@ -1887,7 +2265,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	128
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_TYPE	INT UNSIGNED
 + VARIABLE_COMMENT	Number of undo logs to use (deprecated).
 + NUMERIC_MIN_VALUE	1
 + NUMERIC_MAX_VALUE	128
 +@@ -1901,7 +2279,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	0
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_TYPE	INT UNSIGNED
 + VARIABLE_COMMENT	An InnoDB page number.
 + NUMERIC_MIN_VALUE	0
 + NUMERIC_MAX_VALUE	4294967295
 +@@ -1909,6 +2287,48 @@
 + ENUM_VALUE_LIST	NULL
 + READ_ONLY	NO
 + COMMAND_LINE_ARGUMENT	OPTIONAL
 ++VARIABLE_NAME	INNODB_SCHED_PRIORITY_IO
 ++SESSION_VALUE	NULL
 ++GLOBAL_VALUE	19
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	19
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	INT UNSIGNED
 ++VARIABLE_COMMENT	Nice value for the I/O handler thread scheduling
 ++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	19
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	19
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	INT UNSIGNED
 ++VARIABLE_COMMENT	Nice value for the master thread scheduling
 ++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	19
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	19
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	INT UNSIGNED
 ++VARIABLE_COMMENT	Nice value for the purge thread scheduling
 ++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
 +@@ -1937,6 +2357,34 @@
 + ENUM_VALUE_LIST	NULL
 + READ_ONLY	NO
 + COMMAND_LINE_ARGUMENT	OPTIONAL
 ++VARIABLE_NAME	INNODB_SHOW_LOCKS_HELD
 ++SESSION_VALUE	NULL
 ++GLOBAL_VALUE	10
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	10
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	INT UNSIGNED
 ++VARIABLE_COMMENT	Number of locks held to print for each InnoDB transaction in SHOW INNODB STATUS.
 ++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	INT UNSIGNED
 ++VARIABLE_COMMENT	Whether to show records locked in SHOW INNODB STATUS.
 ++NUMERIC_MIN_VALUE	0
 ++NUMERIC_MAX_VALUE	1
 ++NUMERIC_BLOCK_SIZE	0
 ++ENUM_VALUE_LIST	NULL
 ++READ_ONLY	NO
 ++COMMAND_LINE_ARGUMENT	OPTIONAL
 + VARIABLE_NAME	INNODB_SIMULATE_COMP_FAILURES
 + SESSION_VALUE	NULL
 + GLOBAL_VALUE	0
 +@@ -1957,7 +2405,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + 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
 +@@ -1971,10 +2419,10 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	6
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_TYPE	INT UNSIGNED
 + VARIABLE_COMMENT	Maximum delay between polling for a spin lock (6 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
 +@@ -2014,7 +2462,7 @@
 + DEFAULT_VALUE	nulls_equal
 + VARIABLE_SCOPE	GLOBAL
 + VARIABLE_TYPE	ENUM
 +-VARIABLE_COMMENT	Specifies how InnoDB index statistics collection code should treat NULLs. Possible values are NULLS_EQUAL (default), NULLS_UNEQUAL and NULLS_IGNORED
 ++VARIABLE_COMMENT	Specifies how InnoDB index statistics collection code should treat NULLs
 + NUMERIC_MIN_VALUE	NULL
 + NUMERIC_MAX_VALUE	NULL
 + NUMERIC_BLOCK_SIZE	NULL
 +@@ -2181,7 +2629,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	1
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_TYPE	INT UNSIGNED
 + VARIABLE_COMMENT	Size of the mutex/lock wait array.
 + NUMERIC_MIN_VALUE	1
 + NUMERIC_MAX_VALUE	1024
 +@@ -2195,10 +2643,10 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + 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
 +@@ -2223,7 +2671,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	0
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_TYPE	INT UNSIGNED
 + VARIABLE_COMMENT	Helps in performance tuning in heavily concurrent environments. Sets the maximum number of threads allowed inside InnoDB. Value 0 will disable the thread throttling.
 + NUMERIC_MIN_VALUE	0
 + NUMERIC_MAX_VALUE	1000
 +@@ -2237,7 +2685,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	10000
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_TYPE	INT UNSIGNED
 + VARIABLE_COMMENT	Time of innodb thread sleeping before joining InnoDB queue (usec). Value 0 disable a sleep
 + NUMERIC_MIN_VALUE	0
 + NUMERIC_MAX_VALUE	1000000
 +@@ -2259,6 +2707,34 @@
 + 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	Track the redo log for changed pages and output a changed page bitmap
 ++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_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	Force log tracker to catch up with checkpoint now
 ++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
 +@@ -2307,7 +2783,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	128
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_TYPE	INT UNSIGNED
 + VARIABLE_COMMENT	Number of undo logs to use.
 + NUMERIC_MIN_VALUE	1
 + NUMERIC_MAX_VALUE	128
 +@@ -2321,7 +2797,7 @@
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	0
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_TYPE	INT UNSIGNED
 + VARIABLE_COMMENT	Number of undo tablespaces to use. 
 + NUMERIC_MIN_VALUE	0
 + NUMERIC_MAX_VALUE	126
 +@@ -2336,7 +2812,7 @@
 + DEFAULT_VALUE	OFF
 + VARIABLE_SCOPE	GLOBAL
 + VARIABLE_TYPE	BOOLEAN
 +-VARIABLE_COMMENT	Prevent partial page writes, via atomic writes.The option is used to prevent partial writes in case of a crash/poweroff, as faster alternative to doublewrite buffer.Currently this option works only on Linux only with FusionIO device, and directFS filesystem.
 ++VARIABLE_COMMENT	Prevent partial page writes, via atomic writes (beta). The option is used to prevent partial writes in case of a crash/poweroff, as faster alternative to doublewrite buffer. Currently this option works only on Linux only with FusionIO device, and directFS filesystem.
 + NUMERIC_MIN_VALUE	NULL
 + NUMERIC_MAX_VALUE	NULL
 + NUMERIC_BLOCK_SIZE	NULL
 +@@ -2357,6 +2833,20 @@
 + 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	ON
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	ON
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	BOOLEAN
 ++VARIABLE_COMMENT	Use global innodb_flush_log_at_trx_commit value. (default: ON).
 ++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
 +@@ -2371,6 +2861,20 @@
 + 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	Print stacktrace on long semaphore wait (off by default supported only on linux)
 ++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_SYS_MALLOC
 + SESSION_VALUE	NULL
 + GLOBAL_VALUE	ON
 +@@ -2401,12 +2905,12 @@
 + COMMAND_LINE_ARGUMENT	OPTIONAL
 + VARIABLE_NAME	INNODB_VERSION
 + SESSION_VALUE	NULL
- -GLOBAL_VALUE	5.6.42
- +GLOBAL_VALUE	5.6.41-84.1
++-GLOBAL_VALUE	5.6.43
+++GLOBAL_VALUE	5.6.42-84.2
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	NULL
 + VARIABLE_SCOPE	GLOBAL
 + VARIABLE_TYPE	VARCHAR
 +-VARIABLE_COMMENT	InnoDB version
 ++VARIABLE_COMMENT	Percona-InnoDB-plugin version
 + NUMERIC_MIN_VALUE	NULL
 + NUMERIC_MAX_VALUE	NULL
 + NUMERIC_BLOCK_SIZE	NULL
 +@@ -2419,7 +2923,7 @@
 + GLOBAL_VALUE_ORIGIN	CONFIG
 + DEFAULT_VALUE	4
 + VARIABLE_SCOPE	GLOBAL
 +-VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_TYPE	INT UNSIGNED
 + VARIABLE_COMMENT	Number of background write I/O threads in InnoDB.
 + NUMERIC_MIN_VALUE	1
 + NUMERIC_MAX_VALUE	64
diff --cc mysql-test/suite/sys_vars/r/sysvars_innodb,xtradb.rdiff
index 44269b2c74a,00000000000..998d95e523f
mode 100644,000000..100644
--- a/mysql-test/suite/sys_vars/r/sysvars_innodb,xtradb.rdiff
+++ b/mysql-test/suite/sys_vars/r/sysvars_innodb,xtradb.rdiff
@@@ -1,697 -1,0 +1,697 @@@
 +--- mysql-test/suite/sys_vars/r/sysvars_innodb.result	2018-07-30 23:41:05.030930072 +0200
 ++++ mysql-test/suite/sys_vars/r/sysvars_innodb,xtradb.reject	2018-07-31 09:45:20.330811949 +0200
 +@@ -47,6 +47,20 @@
 + ENUM_VALUE_LIST	OFF,ON
 + READ_ONLY	NO
 + COMMAND_LINE_ARGUMENT	OPTIONAL
 ++VARIABLE_NAME	INNODB_ADAPTIVE_HASH_INDEX_PARTITIONS
 ++SESSION_VALUE	NULL
 ++GLOBAL_VALUE	1
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	1
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_COMMENT	Number of InnoDB adaptive hash index partitions (default 1: disable partitioning)
 ++NUMERIC_MIN_VALUE	1
 ++NUMERIC_MAX_VALUE	64
 ++NUMERIC_BLOCK_SIZE	0
 ++ENUM_VALUE_LIST	NULL
 ++READ_ONLY	YES
 ++COMMAND_LINE_ARGUMENT	REQUIRED
 + VARIABLE_NAME	INNODB_ADAPTIVE_MAX_SLEEP_DELAY
 + SESSION_VALUE	NULL
 + GLOBAL_VALUE	150000
 +@@ -355,6 +369,20 @@
 + 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. This option has no effect and will be removed in MariaDB 10.2.3.
 ++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
 +@@ -446,7 +474,7 @@
 + DEFAULT_VALUE	ON
 + VARIABLE_SCOPE	GLOBAL
 + VARIABLE_TYPE	BOOLEAN
 +-VARIABLE_COMMENT	DEPRECATED. Use innodb_checksum_algorithm=NONE instead of setting this to OFF. Enable InnoDB checksums validation (enabled by default). Disable with --skip-innodb-checksums.
 ++VARIABLE_COMMENT	DEPRECATED. Use innodb_checksum_algorithm=NONE instead of setting this to OFF
 + NUMERIC_MIN_VALUE	NULL
 + NUMERIC_MAX_VALUE	NULL
 + NUMERIC_BLOCK_SIZE	NULL
 +@@ -467,6 +495,104 @@
 + 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	Make page cleaner LRU flushes use evicted instead of flushed page counts for its heuristics
 ++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	100
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	100
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_COMMENT	Divide page cleaner flush list flush batches into chunks of this size
 ++NUMERIC_MIN_VALUE	1
 ++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	10
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	10
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_COMMENT	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
 ++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	100
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	100
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_COMMENT	Divide page cleaner LRU list flush batches into chunks of this size
 ++NUMERIC_MIN_VALUE	1
 ++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	HIGH_CHECKPOINT
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	HIGH_CHECKPOINT
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	ENUM
 ++VARIABLE_COMMENT	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.
 ++NUMERIC_MIN_VALUE	NULL
 ++NUMERIC_MAX_VALUE	NULL
 ++NUMERIC_BLOCK_SIZE	NULL
 ++ENUM_VALUE_LIST	LEGACY,HIGH_CHECKPOINT
 ++READ_ONLY	NO
 ++COMMAND_LINE_ARGUMENT	OPTIONAL
 ++VARIABLE_NAME	INNODB_CLEANER_MAX_FLUSH_TIME
 ++SESSION_VALUE	NULL
 ++GLOBAL_VALUE	1000
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	1000
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_COMMENT	The maximum time limit for a single flush list flush iteration by the page cleaner thread in miliseconds
 ++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	1000
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	1000
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_COMMENT	The maximum time limit for a single LRU tail flush iteration by the page cleaner thread in miliseconds
 ++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
 +@@ -565,6 +691,20 @@
 + ENUM_VALUE_LIST	NULL
 + READ_ONLY	NO
 + COMMAND_LINE_ARGUMENT	REQUIRED
 ++VARIABLE_NAME	INNODB_CORRUPT_TABLE_ACTION
 ++SESSION_VALUE	NULL
 ++GLOBAL_VALUE	assert
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	assert
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	ENUM
 ++VARIABLE_COMMENT	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.
 ++NUMERIC_MIN_VALUE	NULL
 ++NUMERIC_MAX_VALUE	NULL
 ++NUMERIC_BLOCK_SIZE	NULL
 ++ENUM_VALUE_LIST	assert,warn,salvage
 ++READ_ONLY	NO
 ++COMMAND_LINE_ARGUMENT	REQUIRED
 + VARIABLE_NAME	INNODB_DATA_FILE_PATH
 + SESSION_VALUE	NULL
 + GLOBAL_VALUE	ibdata1:12M:autoextend
 +@@ -789,6 +929,20 @@
 + ENUM_VALUE_LIST	NULL
 + READ_ONLY	YES
 + COMMAND_LINE_ARGUMENT	OPTIONAL
 ++VARIABLE_NAME	INNODB_EMPTY_FREE_LIST_ALGORITHM
 ++SESSION_VALUE	NULL
 ++GLOBAL_VALUE	LEGACY
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	BACKOFF
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	ENUM
 ++VARIABLE_COMMENT	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.
 ++NUMERIC_MIN_VALUE	NULL
 ++NUMERIC_MAX_VALUE	NULL
 ++NUMERIC_BLOCK_SIZE	NULL
 ++ENUM_VALUE_LIST	LEGACY,BACKOFF
 ++READ_ONLY	NO
 ++COMMAND_LINE_ARGUMENT	OPTIONAL
 + VARIABLE_NAME	INNODB_ENCRYPTION_ROTATE_KEY_AGE
 + SESSION_VALUE	NULL
 + GLOBAL_VALUE	1
 +@@ -859,6 +1013,20 @@
 + 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	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.
 ++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
 +@@ -986,11 +1154,11 @@
 + READ_ONLY	NO
 + COMMAND_LINE_ARGUMENT	OPTIONAL
 + VARIABLE_NAME	INNODB_FLUSH_LOG_AT_TRX_COMMIT
 +-SESSION_VALUE	NULL
 ++SESSION_VALUE	1
 + GLOBAL_VALUE	1
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	1
 +-VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_SCOPE	SESSION
 + VARIABLE_TYPE	BIGINT 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
 +@@ -1069,6 +1237,20 @@
 + ENUM_VALUE_LIST	NULL
 + READ_ONLY	YES
 + COMMAND_LINE_ARGUMENT	REQUIRED
 ++VARIABLE_NAME	INNODB_FOREGROUND_PREFLUSH
 ++SESSION_VALUE	NULL
 ++GLOBAL_VALUE	EXPONENTIAL_BACKOFF
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	EXPONENTIAL_BACKOFF
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	ENUM
 ++VARIABLE_COMMENT	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.
 ++NUMERIC_MIN_VALUE	NULL
 ++NUMERIC_MAX_VALUE	NULL
 ++NUMERIC_BLOCK_SIZE	NULL
 ++ENUM_VALUE_LIST	SYNC_PREFLUSH,EXPONENTIAL_BACKOFF
 ++READ_ONLY	NO
 ++COMMAND_LINE_ARGUMENT	OPTIONAL
 + VARIABLE_NAME	INNODB_FT_AUX_TABLE
 + SESSION_VALUE	NULL
 + GLOBAL_VALUE	
 +@@ -1307,6 +1489,20 @@
 + 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	OFF
 +@@ -1335,6 +1531,20 @@
 + ENUM_VALUE_LIST	NULL
 + READ_ONLY	NO
 + COMMAND_LINE_ARGUMENT	REQUIRED
 ++VARIABLE_NAME	INNODB_LOCKING_FAKE_CHANGES
 ++SESSION_VALUE	NULL
 ++GLOBAL_VALUE	ON
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	ON
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	BOOLEAN
 ++VARIABLE_COMMENT	###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.
 ++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
 +@@ -1377,6 +1587,62 @@
 + 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	Set to 1 if you want to have logs archived.
 ++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	PATH
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	VARCHAR
 ++VARIABLE_COMMENT	Where full logs should be archived.
 ++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	Expiration time for archived innodb transaction logs.
 ++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	512
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	512
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_COMMENT	###EXPERIMENTAL###: The log block size of the transaction log file. Changing for created log file is not supported. Use on your own risk!
 ++NUMERIC_MIN_VALUE	512
 ++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
 +@@ -1405,6 +1671,20 @@
 + ENUM_VALUE_LIST	OFF,ON
 + READ_ONLY	NO
 + COMMAND_LINE_ARGUMENT	OPTIONAL
 ++VARIABLE_NAME	INNODB_LOG_CHECKSUM_ALGORITHM
 ++SESSION_VALUE	NULL
 ++GLOBAL_VALUE	INNODB
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	INNODB
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	ENUM
 ++VARIABLE_COMMENT	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 donot support this feature
 ++NUMERIC_MIN_VALUE	NULL
 ++NUMERIC_MAX_VALUE	NULL
 ++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_LOG_COMPRESSED_PAGES
 + SESSION_VALUE	NULL
 + GLOBAL_VALUE	ON
 +@@ -1475,6 +1755,34 @@
 + ENUM_VALUE_LIST	NULL
 + READ_ONLY	NO
 + COMMAND_LINE_ARGUMENT	REQUIRED
 ++VARIABLE_NAME	INNODB_MAX_BITMAP_FILE_SIZE
 ++SESSION_VALUE	NULL
 ++GLOBAL_VALUE	104857600
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	104857600
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_COMMENT	The maximum size of changed page bitmap files
 ++NUMERIC_MIN_VALUE	4096
 ++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	1000000
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	1000000
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_COMMENT	The maximum number of rows for INFORMATION_SCHEMA.INNODB_CHANGED_PAGES table, 0 - unlimited
 ++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
 +@@ -1659,7 +1967,7 @@
 + COMMAND_LINE_ARGUMENT	REQUIRED
 + VARIABLE_NAME	INNODB_OPEN_FILES
 + SESSION_VALUE	NULL
 +-GLOBAL_VALUE	2000
 ++GLOBAL_VALUE	300
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	0
 + VARIABLE_SCOPE	GLOBAL
 +@@ -1741,6 +2049,76 @@
 + ENUM_VALUE_LIST	OFF,ON
 + READ_ONLY	NO
 + COMMAND_LINE_ARGUMENT	OPTIONAL
 ++VARIABLE_NAME	INNODB_PRINT_LOCK_WAIT_TIMEOUT_INFO
 ++SESSION_VALUE	NULL
 ++GLOBAL_VALUE	OFF
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	OFF
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	BOOLEAN
 ++VARIABLE_COMMENT	Print lock wait timeout info to MySQL error log (off by default)
 ++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_CLEANER
 ++SESSION_VALUE	NULL
 ++GLOBAL_VALUE	OFF
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	OFF
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	BOOLEAN
 ++VARIABLE_COMMENT	Make buffer pool cleaner and LRU manager threads acquire shared resources with priority
 ++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	Make I/O threads acquire shared resources with priority
 ++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	Make buffer pool cleaner thread acquire shared resources with priority
 ++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	Make purge coordinator and worker threads acquire shared resources with priority
 ++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
 +@@ -1909,6 +2287,48 @@
 + ENUM_VALUE_LIST	NULL
 + READ_ONLY	NO
 + COMMAND_LINE_ARGUMENT	OPTIONAL
 ++VARIABLE_NAME	INNODB_SCHED_PRIORITY_IO
 ++SESSION_VALUE	NULL
 ++GLOBAL_VALUE	19
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	19
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_COMMENT	Nice value for the I/O handler thread scheduling
 ++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	19
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	19
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_COMMENT	Nice value for the master thread scheduling
 ++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	19
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	19
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_COMMENT	Nice value for the purge thread scheduling
 ++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
 +@@ -1937,6 +2357,34 @@
 + ENUM_VALUE_LIST	NULL
 + READ_ONLY	NO
 + COMMAND_LINE_ARGUMENT	OPTIONAL
 ++VARIABLE_NAME	INNODB_SHOW_LOCKS_HELD
 ++SESSION_VALUE	NULL
 ++GLOBAL_VALUE	10
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	10
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	BIGINT UNSIGNED
 ++VARIABLE_COMMENT	Number of locks held to print for each InnoDB transaction in SHOW INNODB STATUS.
 ++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	Whether to show records locked in SHOW INNODB STATUS.
 ++NUMERIC_MIN_VALUE	0
 ++NUMERIC_MAX_VALUE	1
 ++NUMERIC_BLOCK_SIZE	0
 ++ENUM_VALUE_LIST	NULL
 ++READ_ONLY	NO
 ++COMMAND_LINE_ARGUMENT	OPTIONAL
 + VARIABLE_NAME	INNODB_SIMULATE_COMP_FAILURES
 + SESSION_VALUE	NULL
 + GLOBAL_VALUE	0
 +@@ -2014,7 +2462,7 @@
 + DEFAULT_VALUE	nulls_equal
 + VARIABLE_SCOPE	GLOBAL
 + VARIABLE_TYPE	ENUM
 +-VARIABLE_COMMENT	Specifies how InnoDB index statistics collection code should treat NULLs. Possible values are NULLS_EQUAL (default), NULLS_UNEQUAL and NULLS_IGNORED
 ++VARIABLE_COMMENT	Specifies how InnoDB index statistics collection code should treat NULLs
 + NUMERIC_MIN_VALUE	NULL
 + NUMERIC_MAX_VALUE	NULL
 + NUMERIC_BLOCK_SIZE	NULL
 +@@ -2259,6 +2707,34 @@
 + 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	Track the redo log for changed pages and output a changed page bitmap
 ++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_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	Force log tracker to catch up with checkpoint now
 ++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
 +@@ -2336,7 +2812,7 @@
 + DEFAULT_VALUE	OFF
 + VARIABLE_SCOPE	GLOBAL
 + VARIABLE_TYPE	BOOLEAN
 +-VARIABLE_COMMENT	Prevent partial page writes, via atomic writes.The option is used to prevent partial writes in case of a crash/poweroff, as faster alternative to doublewrite buffer.Currently this option works only on Linux only with FusionIO device, and directFS filesystem.
 ++VARIABLE_COMMENT	Prevent partial page writes, via atomic writes (beta). The option is used to prevent partial writes in case of a crash/poweroff, as faster alternative to doublewrite buffer. Currently this option works only on Linux only with FusionIO device, and directFS filesystem.
 + NUMERIC_MIN_VALUE	NULL
 + NUMERIC_MAX_VALUE	NULL
 + NUMERIC_BLOCK_SIZE	NULL
 +@@ -2357,6 +2833,20 @@
 + 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	ON
 ++GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 ++DEFAULT_VALUE	ON
 ++VARIABLE_SCOPE	GLOBAL
 ++VARIABLE_TYPE	BOOLEAN
 ++VARIABLE_COMMENT	Use global innodb_flush_log_at_trx_commit value. (default: ON).
 ++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
 +@@ -2371,6 +2861,20 @@
 + 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	Print stacktrace on long semaphore wait (off by default supported only on linux)
 ++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_SYS_MALLOC
 + SESSION_VALUE	NULL
 + GLOBAL_VALUE	ON
 +@@ -2401,12 +2905,12 @@
 + COMMAND_LINE_ARGUMENT	OPTIONAL
 + VARIABLE_NAME	INNODB_VERSION
 + SESSION_VALUE	NULL
- -GLOBAL_VALUE	5.6.42
- +GLOBAL_VALUE	5.6.41-84.1
++-GLOBAL_VALUE	5.6.43
+++GLOBAL_VALUE	5.6.42-84.2
 + GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 + DEFAULT_VALUE	NULL
 + VARIABLE_SCOPE	GLOBAL
 + VARIABLE_TYPE	VARCHAR
 +-VARIABLE_COMMENT	InnoDB version
 ++VARIABLE_COMMENT	Percona-InnoDB-plugin version
 + NUMERIC_MIN_VALUE	NULL
 + NUMERIC_MAX_VALUE	NULL
 + NUMERIC_BLOCK_SIZE	NULL
diff --cc mysql-test/suite/sys_vars/r/sysvars_innodb.result
index 60b5f52f648,00000000000..f747a493b79
mode 100644,000000..100644
--- a/mysql-test/suite/sys_vars/r/sysvars_innodb.result
+++ b/mysql-test/suite/sys_vars/r/sysvars_innodb.result
@@@ -1,2429 -1,0 +1,2429 @@@
 +select * from information_schema.system_variables
 +where variable_name like 'innodb%' and
 +variable_name not in (
 +'innodb_disallow_writes',           # only available WITH_WSREP
 +'innodb_sched_priority_cleaner',    # linux only
 +'innodb_use_native_aio')            # default value depends on OS
 +order by variable_name;
 +VARIABLE_NAME	INNODB_ADAPTIVE_FLUSHING
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	ON
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	ON
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Attempt flushing dirty pages to avoid IO bursts at checkpoints.
 +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_ADAPTIVE_FLUSHING_LWM
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	10.000000
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	10.000000
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	DOUBLE
 +VARIABLE_COMMENT	Percentage of log capacity below which no adaptive flushing happens.
 +NUMERIC_MIN_VALUE	0
 +NUMERIC_MAX_VALUE	70
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_ADAPTIVE_HASH_INDEX
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	ON
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	ON
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Enable InnoDB adaptive hash index (enabled by default).  Disable with --skip-innodb-adaptive-hash-index.
 +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_ADAPTIVE_MAX_SLEEP_DELAY
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	150000
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	150000
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	The upper limit of the sleep delay in usec. Value of 0 disables it.
 +NUMERIC_MIN_VALUE	0
 +NUMERIC_MAX_VALUE	1000000
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_ADDITIONAL_MEM_POOL_SIZE
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	8388608
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	8388608
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT
 +VARIABLE_COMMENT	DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. Size of a memory pool InnoDB uses to store data dictionary information and other internal data structures.
 +NUMERIC_MIN_VALUE	524288
 +NUMERIC_MAX_VALUE	9223372036854775807
 +NUMERIC_BLOCK_SIZE	1024
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_API_BK_COMMIT_INTERVAL
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	5
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	5
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Background commit interval in seconds
 +NUMERIC_MIN_VALUE	1
 +NUMERIC_MAX_VALUE	1073741824
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	OPTIONAL
 +VARIABLE_NAME	INNODB_API_DISABLE_ROWLOCK
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Disable row lock when direct access InnoDB through InnoDB APIs
 +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_API_ENABLE_BINLOG
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Enable binlog for applications direct access InnoDB through InnoDB APIs
 +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_API_ENABLE_MDL
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Enable MDL for applications direct access InnoDB through InnoDB APIs
 +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_API_TRX_LEVEL
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	0
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	0
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	InnoDB API transaction isolation level
 +NUMERIC_MIN_VALUE	0
 +NUMERIC_MAX_VALUE	3
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	OPTIONAL
 +VARIABLE_NAME	INNODB_AUTOEXTEND_INCREMENT
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	64
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	64
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Data file autoextend increment in megabytes
 +NUMERIC_MIN_VALUE	1
 +NUMERIC_MAX_VALUE	1000
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_AUTOINC_LOCK_MODE
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	1
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	1
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT
 +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
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_BACKGROUND_SCRUB_DATA_CHECK_INTERVAL
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	3600
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	3600
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	INT UNSIGNED
 +VARIABLE_COMMENT	check if spaces needs scrubbing every innodb_background_scrub_data_check_interval seconds
 +NUMERIC_MIN_VALUE	1
 +NUMERIC_MAX_VALUE	4294967295
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_BACKGROUND_SCRUB_DATA_COMPRESSED
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Enable scrubbing of compressed data by background threads (same as encryption_threads)
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	OFF,ON
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_BACKGROUND_SCRUB_DATA_INTERVAL
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	604800
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	604800
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	INT UNSIGNED
 +VARIABLE_COMMENT	scrub spaces that were last scrubbed longer than  innodb_background_scrub_data_interval seconds ago
 +NUMERIC_MIN_VALUE	1
 +NUMERIC_MAX_VALUE	4294967295
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_BACKGROUND_SCRUB_DATA_UNCOMPRESSED
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Enable scrubbing of uncompressed data by background threads (same as encryption_threads)
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	OFF,ON
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_BUFFER_POOL_DUMP_AT_SHUTDOWN
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Dump the buffer pool into a file named @@innodb_buffer_pool_filename
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	OFF,ON
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_BUFFER_POOL_DUMP_NOW
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Trigger an immediate dump of the buffer pool into a file named @@innodb_buffer_pool_filename
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	OFF,ON
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_BUFFER_POOL_DUMP_PCT
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	100
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	100
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Dump only the hottest N% of each buffer pool, defaults to 100
 +NUMERIC_MIN_VALUE	1
 +NUMERIC_MAX_VALUE	100
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_BUFFER_POOL_EVICT
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	VARCHAR
 +VARIABLE_COMMENT	Evict pages from the buffer pool
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_BUFFER_POOL_FILENAME
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	ib_buffer_pool
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	ib_buffer_pool
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	VARCHAR
 +VARIABLE_COMMENT	Filename to/from which to dump/load the InnoDB buffer pool
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_BUFFER_POOL_INSTANCES
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	8
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	0
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT
 +VARIABLE_COMMENT	Number of buffer pool instances, set to higher value on high-end machines to increase scalability
 +NUMERIC_MIN_VALUE	0
 +NUMERIC_MAX_VALUE	64
 +NUMERIC_BLOCK_SIZE	1
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_BUFFER_POOL_LOAD_ABORT
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Abort a currently running load of the buffer pool
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	OFF,ON
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_BUFFER_POOL_LOAD_AT_STARTUP
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Load the buffer pool from a file named @@innodb_buffer_pool_filename
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	OFF,ON
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_BUFFER_POOL_LOAD_NOW
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Trigger an immediate load of the buffer pool from a file named @@innodb_buffer_pool_filename
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	OFF,ON
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_BUFFER_POOL_SIZE
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	8388608
 +GLOBAL_VALUE_ORIGIN	CONFIG
 +DEFAULT_VALUE	134217728
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT
 +VARIABLE_COMMENT	The size of the memory buffer InnoDB uses to cache data and indexes of its tables.
 +NUMERIC_MIN_VALUE	5242880
 +NUMERIC_MAX_VALUE	9223372036854775807
 +NUMERIC_BLOCK_SIZE	1048576
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_BUF_DUMP_STATUS_FREQUENCY
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	0
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	0
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	A number between [0, 100] that tells how oftern 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
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_BUF_FLUSH_LIST_NOW
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Force dirty page flush now
 +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_CHANGE_BUFFERING
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	all
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	all
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	VARCHAR
 +VARIABLE_COMMENT	Buffer changes to reduce random access: OFF, ON, inserting, deleting, changing, or purging.
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_CHANGE_BUFFERING_DEBUG
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	0
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	0
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	INT UNSIGNED
 +VARIABLE_COMMENT	Debug flags for InnoDB change buffering (0=none, 2=crash at merge)
 +NUMERIC_MIN_VALUE	0
 +NUMERIC_MAX_VALUE	2
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_CHANGE_BUFFER_MAX_SIZE
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	25
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	25
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	INT UNSIGNED
 +VARIABLE_COMMENT	Maximum on-disk size of change buffer in terms of percentage of the buffer pool.
 +NUMERIC_MIN_VALUE	0
 +NUMERIC_MAX_VALUE	50
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_CHECKSUMS
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	ON
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	ON
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	DEPRECATED. Use innodb_checksum_algorithm=NONE instead of setting this to OFF. Enable InnoDB checksums validation (enabled by default). Disable with --skip-innodb-checksums.
 +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_CHECKSUM_ALGORITHM
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	INNODB
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	INNODB
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	ENUM
 +VARIABLE_COMMENT	The algorithm InnoDB uses for page checksumming. 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; Files updated when this option is set to crc32 or strict_crc32 will not be readable by MySQL versions older than 5.6.3
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +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_CMP_PER_INDEX_ENABLED
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Enable INFORMATION_SCHEMA.innodb_cmp_per_index, may have negative impact on performance (off by default)
 +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_COMMIT_CONCURRENCY
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	0
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	0
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Helps in performance tuning in heavily concurrent environments.
 +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_COMPRESSION_ALGORITHM
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	zlib
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	zlib
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	ENUM
 +VARIABLE_COMMENT	Compression algorithm used on page compression. One of: none, zlib, lz4, lzo, lzma, or bzip2
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	none,zlib,lz4,lzo,lzma,bzip2,snappy
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	OPTIONAL
 +VARIABLE_NAME	INNODB_COMPRESSION_FAILURE_THRESHOLD_PCT
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	5
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	5
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT 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
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	OPTIONAL
 +VARIABLE_NAME	INNODB_COMPRESSION_LEVEL
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	6
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	6
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	INT UNSIGNED
 +VARIABLE_COMMENT	Compression level used for zlib compression.  0 is no compression, 1 is fastest, 9 is best compression and default is 6.
 +NUMERIC_MIN_VALUE	0
 +NUMERIC_MAX_VALUE	9
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_COMPRESSION_PAD_PCT_MAX
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	50
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	50
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT 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
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	OPTIONAL
 +VARIABLE_NAME	INNODB_CONCURRENCY_TICKETS
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	5000
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	5000
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Number of times a thread is allowed to enter InnoDB within the same SQL query after it has once got the ticket
 +NUMERIC_MIN_VALUE	1
 +NUMERIC_MAX_VALUE	18446744073709551615
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_DATA_FILE_PATH
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	ibdata1:12M:autoextend
 +GLOBAL_VALUE_ORIGIN	CONFIG
 +DEFAULT_VALUE	
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	VARCHAR
 +VARIABLE_COMMENT	Path to individual files and their sizes.
 +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_DATA_FILE_SIZE_DEBUG
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	0
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	0
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	INT UNSIGNED
 +VARIABLE_COMMENT	InnoDB system tablespace size to be set in recovery.
 +NUMERIC_MIN_VALUE	0
 +NUMERIC_MAX_VALUE	4294967295
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_DATA_HOME_DIR
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	VARCHAR
 +VARIABLE_COMMENT	The common part for InnoDB table spaces.
 +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_DEBUG_FORCE_SCRUBBING
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Perform extra scrubbing to increase test exposure
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	OFF,ON
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_DEFAULT_ENCRYPTION_KEY_ID
 +SESSION_VALUE	1
 +GLOBAL_VALUE	1
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	1
 +VARIABLE_SCOPE	SESSION
 +VARIABLE_TYPE	INT UNSIGNED
 +VARIABLE_COMMENT	Default encryption key id used for table encryption.
 +NUMERIC_MIN_VALUE	1
 +NUMERIC_MAX_VALUE	4294967295
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_DEFAULT_ROW_FORMAT
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	compact
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	compact
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	ENUM
 +VARIABLE_COMMENT	The default ROW FORMAT for all innodb tables created without explicit ROW_FORMAT. Possible values are REDUNDANT, COMPACT, and DYNAMIC. The ROW_FORMAT value COMPRESSED is not allowed
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	redundant,compact,dynamic
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_DEFRAGMENT
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Enable/disable InnoDB defragmentation (default FALSE). When set to FALSE, all existing defragmentation will be paused. And new defragmentation command will fail.Paused defragmentation commands will resume when this variable is set to true again.
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	OFF,ON
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_DEFRAGMENT_FILL_FACTOR
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	0.900000
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	0.900000
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	DOUBLE
 +VARIABLE_COMMENT	A number between [0.7, 1] that tells defragmentation how full it should fill a page. Default is 0.9. Number below 0.7 won't make much sense.This variable, together with innodb_defragment_fill_factor_n_recs, is introduced so defragmentation won't pack the page too full and cause page split on the next insert on every page. The variable indicating more defragmentation gain is the one effective.
 +NUMERIC_MIN_VALUE	0.7
 +NUMERIC_MAX_VALUE	1
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_DEFRAGMENT_FILL_FACTOR_N_RECS
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	20
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	20
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	INT UNSIGNED
 +VARIABLE_COMMENT	How many records of space defragmentation should leave on the page. This variable, together with innodb_defragment_fill_factor, is introduced so defragmentation won't pack the page too full and cause page split on the next insert on every page. The variable indicating more defragmentation gain is the one effective.
 +NUMERIC_MIN_VALUE	1
 +NUMERIC_MAX_VALUE	100
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_DEFRAGMENT_FREQUENCY
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	40
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	40
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	INT UNSIGNED
 +VARIABLE_COMMENT	Do not defragment a single index more than this number of time per second.This controls the number of time defragmentation thread can request X_LOCK on an index. Defragmentation thread will check whether 1/defragment_frequency (s) has passed since it worked on this index last time, and put the index back to the queue if not enough time has passed. The actual frequency can only be lower than this given number.
 +NUMERIC_MIN_VALUE	1
 +NUMERIC_MAX_VALUE	1000
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_DEFRAGMENT_N_PAGES
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	7
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	7
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	INT UNSIGNED
 +VARIABLE_COMMENT	Number of pages considered at once when merging multiple pages to defragment
 +NUMERIC_MIN_VALUE	2
 +NUMERIC_MAX_VALUE	32
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_DEFRAGMENT_STATS_ACCURACY
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	0
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	0
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	INT UNSIGNED
 +VARIABLE_COMMENT	How many defragment stats changes there are before the stats are written to persistent storage. Set to 0 meaning disable defragment stats tracking.
 +NUMERIC_MIN_VALUE	0
 +NUMERIC_MAX_VALUE	4294967295
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_DISABLE_BACKGROUND_MERGE
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Disable change buffering merges by the master thread
 +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_DISABLE_SORT_FILE_CACHE
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Whether to disable OS system file cache for sort I/O
 +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_DOUBLEWRITE
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	ON
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	ON
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Enable InnoDB doublewrite buffer (enabled by default). Disable with --skip-innodb-doublewrite.
 +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_DOUBLEWRITE_BATCH_SIZE
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	120
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	120
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Number of pages reserved in doublewrite buffer for batch flushing
 +NUMERIC_MIN_VALUE	1
 +NUMERIC_MAX_VALUE	127
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	OPTIONAL
 +VARIABLE_NAME	INNODB_ENCRYPTION_ROTATE_KEY_AGE
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	1
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	1
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	INT UNSIGNED
 +VARIABLE_COMMENT	Key rotation - re-encrypt in background all pages that were encrypted with a key that many (or more) versions behind. Value 0 indicates that key rotation is disabled.
 +NUMERIC_MIN_VALUE	0
 +NUMERIC_MAX_VALUE	4294967295
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_ENCRYPTION_ROTATION_IOPS
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	100
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	100
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	INT UNSIGNED
 +VARIABLE_COMMENT	Use this many iops for background key rotation
 +NUMERIC_MIN_VALUE	0
 +NUMERIC_MAX_VALUE	4294967295
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_ENCRYPTION_THREADS
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	0
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	0
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	INT UNSIGNED
 +VARIABLE_COMMENT	Number of threads performing background key rotation and scrubbing
 +NUMERIC_MIN_VALUE	0
 +NUMERIC_MAX_VALUE	4294967295
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_ENCRYPT_LOG
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Enable redo log encryption
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	OFF,ON
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	OPTIONAL
 +VARIABLE_NAME	INNODB_ENCRYPT_TABLES
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	ENUM
 +VARIABLE_COMMENT	Enable encryption for tables. Don't forget to enable --innodb-encrypt-log too
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	OFF,ON,FORCE
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	OPTIONAL
 +VARIABLE_NAME	INNODB_FAST_SHUTDOWN
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	1
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	1
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Speeds up the shutdown process of the InnoDB storage engine. Possible values are 0, 1 (faster) or 2 (fastest - crash-like).
 +NUMERIC_MIN_VALUE	0
 +NUMERIC_MAX_VALUE	2
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	OPTIONAL
 +VARIABLE_NAME	INNODB_FATAL_SEMAPHORE_WAIT_THRESHOLD
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	600
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	600
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Maximum number of seconds that semaphore times out in InnoDB.
 +NUMERIC_MIN_VALUE	1
 +NUMERIC_MAX_VALUE	4294967295
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_FILE_FORMAT
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	Antelope
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	Antelope
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	VARCHAR
 +VARIABLE_COMMENT	File format to use for new tables in .ibd files.
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_FILE_FORMAT_CHECK
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	ON
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	ON
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Whether to perform system file format check.
 +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_FILE_FORMAT_MAX
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	Antelope
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	Antelope
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	VARCHAR
 +VARIABLE_COMMENT	The highest file format in the tablespace.
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	OPTIONAL
 +VARIABLE_NAME	INNODB_FILE_PER_TABLE
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	ON
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	ON
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Stores each InnoDB table to an .ibd file in the database dir.
 +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_FIL_MAKE_PAGE_DIRTY_DEBUG
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	0
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	0
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Make the first page of the given tablespace dirty.
 +NUMERIC_MIN_VALUE	0
 +NUMERIC_MAX_VALUE	4294967295
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	OPTIONAL
 +VARIABLE_NAME	INNODB_FLUSHING_AVG_LOOPS
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	30
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	30
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Number of iterations over which the background flushing is averaged.
 +NUMERIC_MIN_VALUE	1
 +NUMERIC_MAX_VALUE	1000
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_FLUSH_LOG_AT_TIMEOUT
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	3
 +GLOBAL_VALUE_ORIGIN	CONFIG
 +DEFAULT_VALUE	1
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	INT UNSIGNED
 +VARIABLE_COMMENT	Write and flush logs every (n) second.
 +NUMERIC_MIN_VALUE	0
 +NUMERIC_MAX_VALUE	2700
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	OPTIONAL
 +VARIABLE_NAME	INNODB_FLUSH_LOG_AT_TRX_COMMIT
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	1
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	1
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT 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
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	OPTIONAL
 +VARIABLE_NAME	INNODB_FLUSH_METHOD
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	VARCHAR
 +VARIABLE_COMMENT	With which method to flush data.
 +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_FLUSH_NEIGHBORS
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	1
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	1
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT 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
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	OPTIONAL
 +VARIABLE_NAME	INNODB_FORCE_LOAD_CORRUPTED
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Force InnoDB to load metadata of corrupted table.
 +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_FORCE_PRIMARY_KEY
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Do not allow to create table without primary key (off by default)
 +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_FORCE_RECOVERY
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	0
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	0
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Helps to save your data in case the disk image of the database becomes corrupt.
 +NUMERIC_MIN_VALUE	0
 +NUMERIC_MAX_VALUE	6
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_FT_AUX_TABLE
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	VARCHAR
 +VARIABLE_COMMENT	FTS internal auxiliary table to be checked
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	NONE
 +VARIABLE_NAME	INNODB_FT_CACHE_SIZE
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	8000000
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	8000000
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	InnoDB Fulltext search cache size in bytes
 +NUMERIC_MIN_VALUE	1600000
 +NUMERIC_MAX_VALUE	80000000
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_FT_ENABLE_DIAG_PRINT
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Whether to enable additional FTS diagnostic printout 
 +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_FT_ENABLE_STOPWORD
 +SESSION_VALUE	ON
 +GLOBAL_VALUE	ON
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	ON
 +VARIABLE_SCOPE	SESSION
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Create FTS index with stopword.
 +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_FT_MAX_TOKEN_SIZE
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	84
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	84
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	InnoDB Fulltext search maximum token size in characters
 +NUMERIC_MIN_VALUE	10
 +NUMERIC_MAX_VALUE	84
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_FT_MIN_TOKEN_SIZE
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	3
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	3
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	InnoDB Fulltext search minimum token size in characters
 +NUMERIC_MIN_VALUE	0
 +NUMERIC_MAX_VALUE	16
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_FT_NUM_WORD_OPTIMIZE
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	2000
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	2000
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	InnoDB Fulltext search number of words to optimize for each optimize table call 
 +NUMERIC_MIN_VALUE	1000
 +NUMERIC_MAX_VALUE	10000
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	OPTIONAL
 +VARIABLE_NAME	INNODB_FT_RESULT_CACHE_LIMIT
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	2000000000
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	2000000000
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	InnoDB Fulltext search query result cache limit in bytes
 +NUMERIC_MIN_VALUE	1000000
 +NUMERIC_MAX_VALUE	18446744073709551615
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_FT_SERVER_STOPWORD_TABLE
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	VARCHAR
 +VARIABLE_COMMENT	The user supplied stopword table name.
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	OPTIONAL
 +VARIABLE_NAME	INNODB_FT_SORT_PLL_DEGREE
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	2
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	2
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT 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
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_FT_TOTAL_CACHE_SIZE
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	640000000
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	640000000
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Total memory allocated for InnoDB Fulltext Search cache
 +NUMERIC_MIN_VALUE	32000000
 +NUMERIC_MAX_VALUE	1600000000
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_FT_USER_STOPWORD_TABLE
 +SESSION_VALUE	
 +GLOBAL_VALUE	
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	
 +VARIABLE_SCOPE	SESSION
 +VARIABLE_TYPE	VARCHAR
 +VARIABLE_COMMENT	User supplied stopword table name, effective in the session level.
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	OPTIONAL
 +VARIABLE_NAME	INNODB_IDLE_FLUSH_PCT
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	100
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	100
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Up to what percentage of dirty pages should be flushed when innodb finds it has spare resources to do so.
 +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_IMMEDIATE_SCRUB_DATA_UNCOMPRESSED
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Enable scrubbing of data
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	OFF,ON
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_INSTRUMENT_SEMAPHORES
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Enable semaphore request instrumentation. This could have some effect on performance but allows better information on long semaphore wait problems. (Default: not enabled)
 +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_IO_CAPACITY
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	200
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	200
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Number of IOPs the server can do. Tunes the background IO rate
 +NUMERIC_MIN_VALUE	100
 +NUMERIC_MAX_VALUE	18446744073709551615
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_IO_CAPACITY_MAX
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	2000
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	18446744073709551615
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Limit to which innodb_io_capacity can be inflated.
 +NUMERIC_MIN_VALUE	100
 +NUMERIC_MAX_VALUE	18446744073709551615
 +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	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Support large index prefix length of REC_VERSION_56_MAX_INDEX_COL_LEN (3072) bytes.
 +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_LIMIT_OPTIMISTIC_INSERT_DEBUG
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	0
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	0
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	INT UNSIGNED
 +VARIABLE_COMMENT	Artificially limit the number of records per B-tree page (0=unlimited).
 +NUMERIC_MIN_VALUE	0
 +NUMERIC_MAX_VALUE	4294967295
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_LOCKS_UNSAFE_FOR_BINLOG
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	DEPRECATED. This option may be removed in future releases. Please use READ COMMITTED transaction isolation level instead. Force InnoDB to not use next-key locking, to use only row-level locking.
 +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_LOCK_SCHEDULE_ALGORITHM
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	fcfs
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	fcfs
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	ENUM
 +VARIABLE_COMMENT	The algorithm Innodb uses for deciding which locks to grant next when a lock is released. Possible values are FCFS grant the locks in First-Come-First-Served order; VATS use the Variance-Aware-Transaction-Scheduling algorithm, which uses an Eldest-Transaction-First heuristic.
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	fcfs,vats
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_LOCK_WAIT_TIMEOUT
 +SESSION_VALUE	50
 +GLOBAL_VALUE	50
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	50
 +VARIABLE_SCOPE	SESSION
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Timeout in seconds an InnoDB transaction may wait for a lock before being rolled back. Values above 100000000 disable the timeout.
 +NUMERIC_MIN_VALUE	1
 +NUMERIC_MAX_VALUE	1073741824
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_LOG_BUFFER_SIZE
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	1048576
 +GLOBAL_VALUE_ORIGIN	CONFIG
 +DEFAULT_VALUE	16777216
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT
 +VARIABLE_COMMENT	The size of the buffer which InnoDB uses to write log to the log files on disk.
 +NUMERIC_MIN_VALUE	262144
 +NUMERIC_MAX_VALUE	9223372036854775807
 +NUMERIC_BLOCK_SIZE	1024
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_LOG_CHECKPOINT_NOW
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Force checkpoint now
 +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_COMPRESSED_PAGES
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	ON
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	ON
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Enables/disables the logging of entire compressed page images. InnoDB logs the compressed pages to prevent corruption if the zlib compression algorithm changes. When turned OFF, InnoDB will assume that the zlib compression algorithm doesn't change.
 +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_FILES_IN_GROUP
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	2
 +GLOBAL_VALUE_ORIGIN	CONFIG
 +DEFAULT_VALUE	2
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Number of log files in the log group. InnoDB writes to the files in a circular fashion.
 +NUMERIC_MIN_VALUE	2
 +NUMERIC_MAX_VALUE	100
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_LOG_FILE_SIZE
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	5242880
 +GLOBAL_VALUE_ORIGIN	CONFIG
 +DEFAULT_VALUE	50331648
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT
 +VARIABLE_COMMENT	Size of each log file in a log group.
 +NUMERIC_MIN_VALUE	1048576
 +NUMERIC_MAX_VALUE	9223372036854775807
 +NUMERIC_BLOCK_SIZE	1048576
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_LOG_GROUP_HOME_DIR
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	PATH
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	VARCHAR
 +VARIABLE_COMMENT	Path to InnoDB log files.
 +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_LRU_SCAN_DEPTH
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	100
 +GLOBAL_VALUE_ORIGIN	CONFIG
 +DEFAULT_VALUE	1024
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	How deep to scan LRU to keep it clean
 +NUMERIC_MIN_VALUE	100
 +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
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	75.000000
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	DOUBLE
 +VARIABLE_COMMENT	Percentage of dirty pages allowed in bufferpool.
 +NUMERIC_MIN_VALUE	0.001
 +NUMERIC_MAX_VALUE	99.999
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_MAX_DIRTY_PAGES_PCT_LWM
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	0.001000
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	0.001000
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	DOUBLE
 +VARIABLE_COMMENT	Percentage of dirty pages at which flushing kicks in.
 +NUMERIC_MIN_VALUE	0
 +NUMERIC_MAX_VALUE	99.999
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_MAX_PURGE_LAG
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	0
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	0
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Desired maximum length of the purge queue (0 = no limit)
 +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_PURGE_LAG_DELAY
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	0
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	0
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Maximum delay of user threads in micro-seconds
 +NUMERIC_MIN_VALUE	0
 +NUMERIC_MAX_VALUE	10000000
 +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	1
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	0
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT
 +VARIABLE_COMMENT	Number of identical copies of log groups we keep for the database. Currently this should be set to 1.
 +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	
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	VARCHAR
 +VARIABLE_COMMENT	Turn off a monitor counter
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_MONITOR_ENABLE
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	VARCHAR
 +VARIABLE_COMMENT	Turn on a monitor counter
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_MONITOR_RESET
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	VARCHAR
 +VARIABLE_COMMENT	Reset a monitor counter
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_MONITOR_RESET_ALL
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	VARCHAR
 +VARIABLE_COMMENT	Reset all values for a monitor counter
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_MTFLUSH_THREADS
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	8
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	8
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT
 +VARIABLE_COMMENT	Number of multi-threaded flush threads
 +NUMERIC_MIN_VALUE	1
 +NUMERIC_MAX_VALUE	64
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_OLD_BLOCKS_PCT
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	37
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	37
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	INT UNSIGNED
 +VARIABLE_COMMENT	Percentage of the buffer pool to reserve for 'old' blocks.
 +NUMERIC_MIN_VALUE	5
 +NUMERIC_MAX_VALUE	95
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_OLD_BLOCKS_TIME
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	1000
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	1000
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	INT UNSIGNED
 +VARIABLE_COMMENT	Move blocks to the 'new' end of the buffer pool if the first access was at least this many milliseconds ago. The timeout is disabled if 0.
 +NUMERIC_MIN_VALUE	0
 +NUMERIC_MAX_VALUE	4294967295
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_ONLINE_ALTER_LOG_MAX_SIZE
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	134217728
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	134217728
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Maximum modification log file size for online index creation
 +NUMERIC_MIN_VALUE	65536
 +NUMERIC_MAX_VALUE	18446744073709551615
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_OPEN_FILES
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	2000
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	0
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT
 +VARIABLE_COMMENT	How many files at the maximum InnoDB keeps open at the same time.
 +NUMERIC_MIN_VALUE	0
 +NUMERIC_MAX_VALUE	9223372036854775807
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_OPTIMIZE_FULLTEXT_ONLY
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Only optimize the Fulltext index of the table
 +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_PAGE_HASH_LOCKS
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	16
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	16
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Number of rw_locks protecting buffer pool page_hash. Rounded up to the next power of 2
 +NUMERIC_MIN_VALUE	1
 +NUMERIC_MAX_VALUE	1024
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	OPTIONAL
 +VARIABLE_NAME	INNODB_PAGE_SIZE
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	16384
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	16384
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Page size to use for all InnoDB tablespaces.
 +NUMERIC_MIN_VALUE	4096
 +NUMERIC_MAX_VALUE	65536
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	OPTIONAL
 +VARIABLE_NAME	INNODB_PREFIX_INDEX_CLUSTER_OPTIMIZATION
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Enable prefix optimization to sometimes avoid cluster index lookups.
 +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_PRINT_ALL_DEADLOCKS
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Print all deadlocks to MySQL error log (off by default)
 +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
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	300
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT 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
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	OPTIONAL
 +VARIABLE_NAME	INNODB_PURGE_RUN_NOW
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Set purge state to RUN
 +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_STOP_NOW
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Set purge state to STOP
 +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_THREADS
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	1
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	1
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Purge threads can be from 1 to 32. Default is 1.
 +NUMERIC_MIN_VALUE	1
 +NUMERIC_MAX_VALUE	32
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	OPTIONAL
 +VARIABLE_NAME	INNODB_RANDOM_READ_AHEAD
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Whether to use read ahead for random access within an extent.
 +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_READ_AHEAD_THRESHOLD
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	56
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	56
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT 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
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_READ_IO_THREADS
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	2
 +GLOBAL_VALUE_ORIGIN	CONFIG
 +DEFAULT_VALUE	4
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Number of background read I/O threads in InnoDB.
 +NUMERIC_MIN_VALUE	1
 +NUMERIC_MAX_VALUE	64
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_READ_ONLY
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Start InnoDB in read only mode (off by default)
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	OFF,ON
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	OPTIONAL
 +VARIABLE_NAME	INNODB_REPLICATION_DELAY
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	0
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	0
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Replication thread delay (ms) on the slave server if innodb_thread_concurrency is reached (0 by default)
 +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_ROLLBACK_ON_TIMEOUT
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Roll back the complete transaction on lock wait timeout, for 4.x compatibility (disabled by default)
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	OFF,ON
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	OPTIONAL
 +VARIABLE_NAME	INNODB_ROLLBACK_SEGMENTS
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	128
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	128
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Number of undo logs to use (deprecated).
 +NUMERIC_MIN_VALUE	1
 +NUMERIC_MAX_VALUE	128
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	OPTIONAL
 +VARIABLE_NAME	INNODB_SAVED_PAGE_NUMBER_DEBUG
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	0
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	0
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	An InnoDB page number.
 +NUMERIC_MIN_VALUE	0
 +NUMERIC_MAX_VALUE	4294967295
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	OPTIONAL
 +VARIABLE_NAME	INNODB_SCRUB_LOG
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Enable background redo log (ib_logfile0, ib_logfile1...) scrubbing
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	OFF,ON
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	OPTIONAL
 +VARIABLE_NAME	INNODB_SCRUB_LOG_SPEED
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	256
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	256
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Background redo log scrubbing speed in bytes/sec
 +NUMERIC_MIN_VALUE	1
 +NUMERIC_MAX_VALUE	50000
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	OPTIONAL
 +VARIABLE_NAME	INNODB_SIMULATE_COMP_FAILURES
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	0
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	0
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	INT UNSIGNED
 +VARIABLE_COMMENT	Simulate compression failures.
 +NUMERIC_MIN_VALUE	0
 +NUMERIC_MAX_VALUE	99
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	NONE
 +VARIABLE_NAME	INNODB_SORT_BUFFER_SIZE
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	1048576
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	1048576
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Memory buffer size for index creation
 +NUMERIC_MIN_VALUE	65536
 +NUMERIC_MAX_VALUE	67108864
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_SPIN_WAIT_DELAY
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	6
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	6
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Maximum delay between polling for a spin lock (6 by default)
 +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_STATS_AUTO_RECALC
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	ON
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	ON
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	InnoDB automatic recalculation of persistent statistics enabled for all tables unless overridden at table level (automatic recalculation is only done when InnoDB decides that the table has changed too much and needs a new statistics)
 +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_STATS_INCLUDE_DELETE_MARKED
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Scan delete marked records for persistent stat
 +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_STATS_METHOD
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	nulls_equal
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	nulls_equal
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	ENUM
 +VARIABLE_COMMENT	Specifies how InnoDB index statistics collection code should treat NULLs. Possible values are NULLS_EQUAL (default), NULLS_UNEQUAL and NULLS_IGNORED
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	nulls_equal,nulls_unequal,nulls_ignored
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_STATS_MODIFIED_COUNTER
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	0
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	0
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	The number of rows modified before we calculate new statistics (default 0 = current limits)
 +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_STATS_ON_METADATA
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Enable statistics gathering for metadata commands such as SHOW TABLE STATUS for tables that use transient statistics (off by default)
 +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_STATS_PERSISTENT
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	CONFIG
 +DEFAULT_VALUE	ON
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	InnoDB persistent statistics enabled for all tables unless overridden at table level
 +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_STATS_PERSISTENT_SAMPLE_PAGES
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	20
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	20
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	The number of leaf index pages to sample when calculating persistent statistics (by ANALYZE, default 20)
 +NUMERIC_MIN_VALUE	1
 +NUMERIC_MAX_VALUE	18446744073709551615
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_STATS_SAMPLE_PAGES
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	8
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	8
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Deprecated, use innodb_stats_transient_sample_pages instead
 +NUMERIC_MIN_VALUE	1
 +NUMERIC_MAX_VALUE	18446744073709551615
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_STATS_TRADITIONAL
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	ON
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	ON
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Enable traditional statistic calculation based on number of configured pages (default true)
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	OFF,ON
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_STATS_TRANSIENT_SAMPLE_PAGES
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	8
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	8
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	The number of leaf index pages to sample when calculating transient statistics (if persistent statistics are not used, default 8)
 +NUMERIC_MIN_VALUE	1
 +NUMERIC_MAX_VALUE	18446744073709551615
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_STATUS_OUTPUT
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Enable InnoDB monitor output to the error log.
 +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_STATUS_OUTPUT_LOCKS
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Enable InnoDB lock monitor output to the error log. Requires innodb_status_output=ON.
 +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_STRICT_MODE
 +SESSION_VALUE	OFF
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	SESSION
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Use strict mode when evaluating create options.
 +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_SUPPORT_XA
 +SESSION_VALUE	ON
 +GLOBAL_VALUE	ON
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	ON
 +VARIABLE_SCOPE	SESSION
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Enable InnoDB support for the XA two-phase commit
 +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_SYNC_ARRAY_SIZE
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	1
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	1
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Size of the mutex/lock wait array.
 +NUMERIC_MIN_VALUE	1
 +NUMERIC_MAX_VALUE	1024
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	OPTIONAL
 +VARIABLE_NAME	INNODB_SYNC_SPIN_LOOPS
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	30
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	30
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Count of spin-loop rounds in InnoDB mutexes (30 by default)
 +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_TABLE_LOCKS
 +SESSION_VALUE	ON
 +GLOBAL_VALUE	ON
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	ON
 +VARIABLE_SCOPE	SESSION
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Enable InnoDB locking in LOCK TABLES
 +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_THREAD_CONCURRENCY
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	0
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	0
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Helps in performance tuning in heavily concurrent environments. Sets the maximum number of threads allowed inside InnoDB. Value 0 will disable the thread throttling.
 +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_THREAD_SLEEP_DELAY
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	10000
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	10000
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Time of innodb thread sleeping before joining InnoDB queue (usec). Value 0 disable a sleep
 +NUMERIC_MIN_VALUE	0
 +NUMERIC_MAX_VALUE	1000000
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_TMPDIR
 +SESSION_VALUE	
 +GLOBAL_VALUE	
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	
 +VARIABLE_SCOPE	SESSION
 +VARIABLE_TYPE	VARCHAR
 +VARIABLE_COMMENT	Directory for temporary non-tablespace files.
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	OPTIONAL
 +VARIABLE_NAME	INNODB_TRX_PURGE_VIEW_UPDATE_ONLY_DEBUG
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Pause actual purging any delete-marked records, but merely update the purge view. It is to create artificially the situation the purge view have been updated but the each purges were not done yet.
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	OFF,ON
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	NULL
 +VARIABLE_NAME	INNODB_TRX_RSEG_N_SLOTS_DEBUG
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	0
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	0
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	INT UNSIGNED
 +VARIABLE_COMMENT	Debug flags for InnoDB to limit TRX_RSEG_N_SLOTS for trx_rsegf_undo_find_free()
 +NUMERIC_MIN_VALUE	0
 +NUMERIC_MAX_VALUE	1024
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	NULL
 +VARIABLE_NAME	INNODB_UNDO_DIRECTORY
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	.
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	.
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	VARCHAR
 +VARIABLE_COMMENT	Directory where undo tablespace files live, this path can be absolute.
 +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_UNDO_LOGS
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	128
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	128
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Number of undo logs to use.
 +NUMERIC_MIN_VALUE	1
 +NUMERIC_MAX_VALUE	128
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	NO
 +COMMAND_LINE_ARGUMENT	OPTIONAL
 +VARIABLE_NAME	INNODB_UNDO_TABLESPACES
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	0
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	0
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Number of undo tablespaces to use. 
 +NUMERIC_MIN_VALUE	0
 +NUMERIC_MAX_VALUE	126
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	REQUIRED
 +VARIABLE_NAME	INNODB_USE_ATOMIC_WRITES
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Prevent partial page writes, via atomic writes.The option is used to prevent partial writes in case of a crash/poweroff, as faster alternative to doublewrite buffer.Currently this option works only on Linux only with FusionIO device, and directFS filesystem.
 +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_FALLOCATE
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Preallocate files fast, using operating system functionality. On POSIX systems, posix_fallocate system call is used.
 +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_MTFLUSH
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Use multi-threaded flush. Default FALSE.
 +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_SYS_MALLOC
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	ON
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	ON
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	DEPRECATED. This option may be removed in future releases, together with the InnoDB's internal memory allocator. Use OS memory allocator instead of InnoDB's internal memory allocator
 +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	OFF
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	OFF
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BOOLEAN
 +VARIABLE_COMMENT	Use trim. Default FALSE.
 +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_VERSION
 +SESSION_VALUE	NULL
- GLOBAL_VALUE	5.6.42
++GLOBAL_VALUE	5.6.43
 +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
 +DEFAULT_VALUE	NULL
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	VARCHAR
 +VARIABLE_COMMENT	InnoDB version
 +NUMERIC_MIN_VALUE	NULL
 +NUMERIC_MAX_VALUE	NULL
 +NUMERIC_BLOCK_SIZE	NULL
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	NULL
 +VARIABLE_NAME	INNODB_WRITE_IO_THREADS
 +SESSION_VALUE	NULL
 +GLOBAL_VALUE	2
 +GLOBAL_VALUE_ORIGIN	CONFIG
 +DEFAULT_VALUE	4
 +VARIABLE_SCOPE	GLOBAL
 +VARIABLE_TYPE	BIGINT UNSIGNED
 +VARIABLE_COMMENT	Number of background write I/O threads in InnoDB.
 +NUMERIC_MIN_VALUE	1
 +NUMERIC_MAX_VALUE	64
 +NUMERIC_BLOCK_SIZE	0
 +ENUM_VALUE_LIST	NULL
 +READ_ONLY	YES
 +COMMAND_LINE_ARGUMENT	REQUIRED
diff --cc mysql-test/t/subselect_mat.test
index bf5de741ea0,66a6cc97acb..f554d86c5a9
--- a/mysql-test/t/subselect_mat.test
+++ b/mysql-test/t/subselect_mat.test
@@@ -268,18 -268,15 +268,31 @@@ SELECT * FROM t2 WHERE f IN ( SELECT LE
  SELECT * FROM t2 WHERE f IN ( SELECT LEFT('foo',0) FROM t1 ORDER BY 1 );
  DROP TABLE t1, t2;
  
+ --echo #
+ --echo # MDEV-18255: Server crashes in Bitmap<64u>::intersect
+ --echo #
+ create table t1 (v1 varchar(1)) engine=myisam ;
+ create table t2 (v1 varchar(1)) engine=myisam ;
+ 
+ explain
+ select 1 from t1 where exists
+ 	(select 1 from t1 where t1.v1 in (select t2.v1 from t2 having t2.v1 < 'j')) ;
+ select 1 from t1 where exists
+ 	(select 1 from t1 where t1.v1 in (select t2.v1 from t2 having t2.v1 < 'j')) ;
+ drop table t1,t2;
++
 +--echo #
 +--echo # MDEV-9489: Assertion `0' failed in Protocol::end_statement() on
 +--echo # UNION ALL
 +--echo #
 +
 +CREATE TABLE t1 (f1 INT);
 +CREATE TABLE t2 (f2 INT);
 +INSERT INTO t1 VALUES (1),(2);
 +
 +( SELECT 1 FROM t1 WHERE f1 NOT IN ( SELECT f2 FROM t2 ) LIMIT 0 )
 +UNION ALL
 +( SELECT 1 FROM t1 WHERE f1 NOT IN ( SELECT f2 FROM t2 ) )
 +;
 +
 +drop table t1, t2;
diff --cc scripts/mysql_install_db.sh
index 0bbac8ba8c4,0c1dd7c724f..4c63245c923
--- a/scripts/mysql_install_db.sh
+++ b/scripts/mysql_install_db.sh
@@@ -35,10 -35,10 +35,13 @@@ force=
  in_rpm=0
  ip_only=0
  cross_bootstrap=0
 +install_params=""
 +auth_root_authentication_method=normal
 +auth_root_socket_user='root'
  
+ dirname0=`dirname $0 2>/dev/null`
+ dirname0=`dirname $dirname0 2>/dev/null`
+ 
  usage()
  {
    cat <<EOF
diff --cc sql/log.cc
index 767070799a9,6761934caf0..a1e7e5b218f
--- a/sql/log.cc
+++ b/sql/log.cc
@@@ -3923,10 -3757,11 +3923,10 @@@ int MYSQL_BIN_LOG::find_log_pos(LOG_INF
  
      // if the log entry matches, null string matching anything
      if (!log_name ||
 -	(log_name_len == fname_len-1 && full_fname[log_name_len] == '\n' &&
 +        (log_name_len == fname_len &&
- 	 !memcmp(full_fname, full_log_name, log_name_len)))
+ 	 !strncmp(full_fname, full_log_name, log_name_len)))
      {
        DBUG_PRINT("info", ("Found log file entry"));
 -      full_fname[fname_len-1]= 0;			// remove last \n
        linfo->index_file_start_offset= offset;
        linfo->index_file_offset = my_b_tell(&index_file);
        break;
diff --cc sql/sql_table.cc
index 670838a4cbb,8a4c6e025fb..55b77c8b934
--- a/sql/sql_table.cc
+++ b/sql/sql_table.cc
@@@ -6572,17 -6529,9 +6575,16 @@@ static bool fill_alter_inplace_info(TH
        (i) Old table doesn't have primary key, new table has it and vice-versa
        (ii) Primary key changed to another existing index
      */
-     if ((new_key == new_pk) !=
-         ((uint) (table_key - table->key_info) == table->s->primary_key))
+     if ((new_key == new_pk) != (table_key == old_pk))
        goto index_changed;
  
 +    /* Check that key comment is not changed. */
 +    if (table_key->comment.length != new_key->comment.length ||
 +        (table_key->comment.length &&
 +         memcmp(table_key->comment.str, new_key->comment.str,
 +                table_key->comment.length) != 0))
 +      goto index_changed;
 +
      continue;
  
    index_changed:
diff --cc storage/innobase/handler/handler0alter.cc
index c710a2403e3,40a04c8848f..7e8a8334a4d
--- a/storage/innobase/handler/handler0alter.cc
+++ b/storage/innobase/handler/handler0alter.cc
@@@ -1,7 -1,7 +1,7 @@@
  /*****************************************************************************
  
  Copyright (c) 2005, 2018, Oracle and/or its affiliates. All Rights Reserved.
- Copyright (c) 2013, 2018, MariaDB Corporation.
 -Copyright (c) 2017, 2019, MariaDB Corporation.
++Copyright (c) 2013, 2019, MariaDB Corporation.
  
  This program is free software; you can redistribute it and/or modify it under
  the terms of the GNU General Public License as published by the Free Software
diff --cc storage/tokudb/hatoku_hton.h
index e632a9afe88,e90af067b00..816a66aa440
--- a/storage/tokudb/hatoku_hton.h
+++ b/storage/tokudb/hatoku_hton.h
@@@ -187,10 -187,9 +187,9 @@@ inline int tokudb_killed_callback(void
  inline bool tokudb_killed_thd_callback(void* extra,
                                         TOKUDB_UNUSED(uint64_t deleted_rows)) {
      THD *thd = static_cast<THD *>(extra);
 -    return thd_killed(thd) != 0;
 +    return thd_kill_level(thd) != 0;
  }
  
- extern HASH tokudb_open_tables;
  extern const char* tokudb_hton_name;
  extern int tokudb_hton_initialized;
  extern tokudb::thread::rwlock_t tokudb_hton_initialized_lock;

    