Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-12767

sys_vars.sysvars_innodb test fails in buildbot and outside

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.2
    • Fix Version/s: 10.2.6
    • Component/s: Tests
    • Labels:
      None

      Description

      The test started failing after adding XtraDB options.
      https://internal.askmonty.org/buildbot/builders/kvm-fulltest2/builds/8086/steps/test_2/logs/stdio

      sys_vars.sysvars_innodb '32bit,innodb'   w2 [ fail ]
              Test ended at 2017-05-10 00:20:32
       
      CURRENT_TEST: sys_vars.sysvars_innodb
      --- /mnt/buildbot/build/mariadb-10.2.6/mysql-test/suite/sys_vars/r/sysvars_innodb,32bit.result~	2017-05-09 23:34:42.000000000 +0300
      +++ /mnt/buildbot/build/mariadb-10.2.6/mysql-test/suite/sys_vars/r/sysvars_innodb,32bit.reject	2017-05-10 00:20:32.000000000 +0300
      @@ -48,6 +48,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	8
      +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
      +DEFAULT_VALUE	8
      +VARIABLE_SCOPE	GLOBAL
      +VARIABLE_TYPE	INT UNSIGNED
      +VARIABLE_COMMENT	Number of InnoDB Adaptive Hash Index Partitions (default 8)
      +NUMERIC_MIN_VALUE	1
      +NUMERIC_MAX_VALUE	512
      +NUMERIC_BLOCK_SIZE	0
      +ENUM_VALUE_LIST	NULL
      +READ_ONLY	YES
      +COMMAND_LINE_ARGUMENT	OPTIONAL
       VARIABLE_NAME	INNODB_ADAPTIVE_HASH_INDEX_PARTS
       SESSION_VALUE	NULL
       GLOBAL_VALUE	8
      @@ -314,6 +328,20 @@
       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.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
      @@ -426,6 +454,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	0
      +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
      +DEFAULT_VALUE	0
      +VARIABLE_SCOPE	GLOBAL
      +VARIABLE_TYPE	INT UNSIGNED
      +VARIABLE_COMMENT	Divide page cleaner flush list flush batches into chunks of this size
      +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_FREE_LIST_LWM
      +SESSION_VALUE	NULL
      +GLOBAL_VALUE	0
      +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
      +DEFAULT_VALUE	0
      +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	0
      +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
      +DEFAULT_VALUE	0
      +VARIABLE_SCOPE	GLOBAL
      +VARIABLE_TYPE	INT UNSIGNED
      +VARIABLE_COMMENT	Divide page cleaner LRU list flush batches into chunks of this size
      +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_LSN_AGE_FACTOR
      +SESSION_VALUE	NULL
      +GLOBAL_VALUE	DEPRECATED
      +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
      +DEFAULT_VALUE	DEPRECATED
      +VARIABLE_SCOPE	GLOBAL
      +VARIABLE_TYPE	ENUM
      +VARIABLE_COMMENT	Deprecated. 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,DEPRECATED
      +READ_ONLY	NO
      +COMMAND_LINE_ARGUMENT	OPTIONAL
      +VARIABLE_NAME	INNODB_CLEANER_MAX_FLUSH_TIME
      +SESSION_VALUE	NULL
      +GLOBAL_VALUE	0
      +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
      +DEFAULT_VALUE	0
      +VARIABLE_SCOPE	GLOBAL
      +VARIABLE_TYPE	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	0
      +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
      +DEFAULT_VALUE	0
      +VARIABLE_SCOPE	GLOBAL
      +VARIABLE_TYPE	INT UNSIGNED
      +VARIABLE_COMMENT	Deprecated. 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
      @@ -538,6 +664,20 @@
       ENUM_VALUE_LIST	NULL
       READ_ONLY	NO
       COMMAND_LINE_ARGUMENT	REQUIRED
      +VARIABLE_NAME	INNODB_CORRUPT_TABLE_ACTION
      +SESSION_VALUE	NULL
      +GLOBAL_VALUE	deprecated
      +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
      +DEFAULT_VALUE	deprecated
      +VARIABLE_SCOPE	GLOBAL
      +VARIABLE_TYPE	ENUM
      +VARIABLE_COMMENT	Deprecated. 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,deprecated
      +READ_ONLY	NO
      +COMMAND_LINE_ARGUMENT	REQUIRED
       VARIABLE_NAME	INNODB_DATA_FILE_PATH
       SESSION_VALUE	NULL
       GLOBAL_VALUE	ibdata1:12M:autoextend
      @@ -804,6 +944,20 @@
       ENUM_VALUE_LIST	NULL
       READ_ONLY	YES
       COMMAND_LINE_ARGUMENT	OPTIONAL
      +VARIABLE_NAME	INNODB_EMPTY_FREE_LIST_ALGORITHM
      +SESSION_VALUE	NULL
      +GLOBAL_VALUE	DEPRECATED
      +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
      +DEFAULT_VALUE	DEPRECATED
      +VARIABLE_SCOPE	GLOBAL
      +VARIABLE_TYPE	ENUM
      +VARIABLE_COMMENT	Deprecated. 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,DEPRECATED
      +READ_ONLY	NO
      +COMMAND_LINE_ARGUMENT	OPTIONAL
       VARIABLE_NAME	INNODB_ENCRYPTION_ROTATE_KEY_AGE
       SESSION_VALUE	NULL
       GLOBAL_VALUE	1
      @@ -874,6 +1028,20 @@
       ENUM_VALUE_LIST	OFF,ON,FORCE
       READ_ONLY	NO
       COMMAND_LINE_ARGUMENT	OPTIONAL
      +VARIABLE_NAME	INNODB_FAKE_CHANGES
      +SESSION_VALUE	OFF
      +GLOBAL_VALUE	OFF
      +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
      +DEFAULT_VALUE	OFF
      +VARIABLE_SCOPE	SESSION
      +VARIABLE_TYPE	BOOLEAN
      +VARIABLE_COMMENT	Deprecated. 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
      @@ -1112,6 +1280,20 @@
       ENUM_VALUE_LIST	NULL
       READ_ONLY	YES
       COMMAND_LINE_ARGUMENT	REQUIRED
      +VARIABLE_NAME	INNODB_FOREGROUND_PREFLUSH
      +SESSION_VALUE	NULL
      +GLOBAL_VALUE	DEPRECATED
      +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
      +DEFAULT_VALUE	DEPRECATED
      +VARIABLE_SCOPE	GLOBAL
      +VARIABLE_TYPE	ENUM
      +VARIABLE_COMMENT	Deprecated: 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,DEPRECATED
      +READ_ONLY	NO
      +COMMAND_LINE_ARGUMENT	OPTIONAL
       VARIABLE_NAME	INNODB_FT_AUX_TABLE
       SESSION_VALUE	NULL
       GLOBAL_VALUE	
      @@ -1350,6 +1532,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	2147483647
      +NUMERIC_BLOCK_SIZE	0
      +ENUM_VALUE_LIST	NULL
      +READ_ONLY	NO
      +COMMAND_LINE_ARGUMENT	REQUIRED
       VARIABLE_NAME	INNODB_LARGE_PREFIX
       SESSION_VALUE	NULL
       GLOBAL_VALUE	ON
      @@ -1378,6 +1574,20 @@
       ENUM_VALUE_LIST	NULL
       READ_ONLY	NO
       COMMAND_LINE_ARGUMENT	REQUIRED
      +VARIABLE_NAME	INNODB_LOCKING_FAKE_CHANGES
      +SESSION_VALUE	NULL
      +GLOBAL_VALUE	OFF
      +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
      +DEFAULT_VALUE	OFF
      +VARIABLE_SCOPE	GLOBAL
      +VARIABLE_TYPE	BOOLEAN
      +VARIABLE_COMMENT	Deprecated. ###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
      @@ -1420,6 +1630,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	Deprecated. 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	
      +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
      +DEFAULT_VALUE	
      +VARIABLE_SCOPE	GLOBAL
      +VARIABLE_TYPE	VARCHAR
      +VARIABLE_COMMENT	Deprecated. 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	Deprecated. 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	0
      +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
      +DEFAULT_VALUE	0
      +VARIABLE_SCOPE	GLOBAL
      +VARIABLE_TYPE	INT UNSIGNED
      +VARIABLE_COMMENT	Deprecated. ###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	0
      +NUMERIC_MAX_VALUE	65536
      +NUMERIC_BLOCK_SIZE	0
      +ENUM_VALUE_LIST	NULL
      +READ_ONLY	YES
      +COMMAND_LINE_ARGUMENT	REQUIRED
       VARIABLE_NAME	INNODB_LOG_BUFFER_SIZE
       SESSION_VALUE	NULL
       GLOBAL_VALUE	1048576
      @@ -1462,6 +1728,20 @@
       ENUM_VALUE_LIST	OFF,ON
       READ_ONLY	NO
       COMMAND_LINE_ARGUMENT	REQUIRED
      +VARIABLE_NAME	INNODB_LOG_CHECKSUM_ALGORITHM
      +SESSION_VALUE	NULL
      +GLOBAL_VALUE	DEPRECATED
      +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
      +DEFAULT_VALUE	DEPRECATED
      +VARIABLE_SCOPE	GLOBAL
      +VARIABLE_TYPE	ENUM
      +VARIABLE_COMMENT	Deprecated. 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,DEPRECATED
      +READ_ONLY	NO
      +COMMAND_LINE_ARGUMENT	REQUIRED
       VARIABLE_NAME	INNODB_LOG_COMPRESSED_PAGES
       SESSION_VALUE	NULL
       GLOBAL_VALUE	ON
      @@ -1560,6 +1840,34 @@
       ENUM_VALUE_LIST	OFF,ON
       READ_ONLY	NO
       COMMAND_LINE_ARGUMENT	OPTIONAL
      +VARIABLE_NAME	INNODB_MAX_BITMAP_FILE_SIZE
      +SESSION_VALUE	NULL
      +GLOBAL_VALUE	0
      +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
      +DEFAULT_VALUE	0
      +VARIABLE_SCOPE	GLOBAL
      +VARIABLE_TYPE	BIGINT UNSIGNED
      +VARIABLE_COMMENT	Deprecated. The maximum size of changed page bitmap files
      +NUMERIC_MIN_VALUE	0
      +NUMERIC_MAX_VALUE	18446744073709551615
      +NUMERIC_BLOCK_SIZE	0
      +ENUM_VALUE_LIST	NULL
      +READ_ONLY	NO
      +COMMAND_LINE_ARGUMENT	REQUIRED
      +VARIABLE_NAME	INNODB_MAX_CHANGED_PAGES
      +SESSION_VALUE	NULL
      +GLOBAL_VALUE	0
      +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
      +DEFAULT_VALUE	0
      +VARIABLE_SCOPE	GLOBAL
      +VARIABLE_TYPE	BIGINT UNSIGNED
      +VARIABLE_COMMENT	Deprecated. 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
      @@ -1644,6 +1952,20 @@
       ENUM_VALUE_LIST	NULL
       READ_ONLY	NO
       COMMAND_LINE_ARGUMENT	REQUIRED
      +VARIABLE_NAME	INNODB_MIRRORED_LOG_GROUPS
      +SESSION_VALUE	NULL
      +GLOBAL_VALUE	0
      +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
      +DEFAULT_VALUE	0
      +VARIABLE_SCOPE	GLOBAL
      +VARIABLE_TYPE	INT UNSIGNED
      +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	
      @@ -1868,6 +2190,62 @@
       ENUM_VALUE_LIST	OFF,ON
       READ_ONLY	NO
       COMMAND_LINE_ARGUMENT	OPTIONAL
      +VARIABLE_NAME	INNODB_PRIORITY_CLEANER
      +SESSION_VALUE	NULL
      +GLOBAL_VALUE	OFF
      +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
      +DEFAULT_VALUE	OFF
      +VARIABLE_SCOPE	GLOBAL
      +VARIABLE_TYPE	BOOLEAN
      +VARIABLE_COMMENT	Deprecated. 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	Deprecated. 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	Deprecated. 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
      @@ -2050,6 +2428,48 @@
       ENUM_VALUE_LIST	NULL
       READ_ONLY	NO
       COMMAND_LINE_ARGUMENT	OPTIONAL
      +VARIABLE_NAME	INNODB_SCHED_PRIORITY_IO
      +SESSION_VALUE	NULL
      +GLOBAL_VALUE	0
      +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
      +DEFAULT_VALUE	0
      +VARIABLE_SCOPE	GLOBAL
      +VARIABLE_TYPE	INT UNSIGNED
      +VARIABLE_COMMENT	Deprecated. 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	0
      +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
      +DEFAULT_VALUE	0
      +VARIABLE_SCOPE	GLOBAL
      +VARIABLE_TYPE	INT UNSIGNED
      +VARIABLE_COMMENT	Deprecated. 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	0
      +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
      +DEFAULT_VALUE	0
      +VARIABLE_SCOPE	GLOBAL
      +VARIABLE_TYPE	INT UNSIGNED
      +VARIABLE_COMMENT	Deprecated. 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
      @@ -2078,6 +2498,34 @@
       ENUM_VALUE_LIST	NULL
       READ_ONLY	NO
       COMMAND_LINE_ARGUMENT	OPTIONAL
      +VARIABLE_NAME	INNODB_SHOW_LOCKS_HELD
      +SESSION_VALUE	NULL
      +GLOBAL_VALUE	0
      +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
      +DEFAULT_VALUE	0
      +VARIABLE_SCOPE	GLOBAL
      +VARIABLE_TYPE	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	REQUIRED
       VARIABLE_NAME	INNODB_SIMULATE_COMP_FAILURES
       SESSION_VALUE	NULL
       GLOBAL_VALUE	0
      @@ -2428,6 +2876,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	Deprecated. 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	YES
      +COMMAND_LINE_ARGUMENT	NONE
      +VARIABLE_NAME	INNODB_TRACK_REDO_LOG_NOW
      +SESSION_VALUE	NULL
      +GLOBAL_VALUE	OFF
      +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
      +DEFAULT_VALUE	OFF
      +VARIABLE_SCOPE	GLOBAL
      +VARIABLE_TYPE	BOOLEAN
      +VARIABLE_COMMENT	Deprecated. 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
      @@ -2540,6 +3016,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	OFF
      +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
      +DEFAULT_VALUE	OFF
      +VARIABLE_SCOPE	GLOBAL
      +VARIABLE_TYPE	BOOLEAN
      +VARIABLE_COMMENT	Deprecated. Use global innodb_flush_log_at_trx_commit value.
      +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
      @@ -2551,6 +3041,20 @@
       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_STACKTRACE
      +SESSION_VALUE	NULL
      +GLOBAL_VALUE	OFF
      +GLOBAL_VALUE_ORIGIN	COMPILE-TIME
      +DEFAULT_VALUE	OFF
      +VARIABLE_SCOPE	GLOBAL
      +VARIABLE_TYPE	BOOLEAN
      +VARIABLE_COMMENT	Deprecated. 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
       
      mysqltest: Result length mismatch
      

      Please make sure to fix the base 64-bit version, and the 32-bit rdiff.

        Attachments

          Activity

            People

            Assignee:
            sanja Oleksandr Byelkin
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: