mirror of
https://github.com/MariaDB/server.git
synced 2025-02-09 23:24:11 +01:00
9608773f75
This essentially reverts commit 4e89ec6692
and only disables InnoDB persistent statistics for tests where it is
desirable. By design, InnoDB persistent statistics will not be updated
except by ANALYZE TABLE or by STATS_AUTO_RECALC.
The internal transactions that update persistent InnoDB statistics
in background tasks (with innodb_stats_auto_recalc=ON) may cause
nondeterministic query plans or interfere with some tests that deal
with other InnoDB internals, such as the purge of transaction history.
28 lines
793 B
Text
28 lines
793 B
Text
# mysqlbinlog_row_innodb.test
|
|
#
|
|
# Show that mysqlbinlog displays human readable comments to
|
|
# row-based log events.
|
|
#
|
|
# Main module for the InnoDB storage engine.
|
|
#
|
|
# Calls include/mysqlbinlog_row.inc
|
|
# See there for more informaton.
|
|
#
|
|
|
|
--source include/have_innodb.inc
|
|
let $engine_type=InnoDB;
|
|
|
|
SET @save_stats_auto_recalc=@@GLOBAL.innodb_stats_auto_recalc;
|
|
SET GLOBAL innodb_stats_auto_recalc=OFF;
|
|
|
|
#
|
|
# The test case would also work with statement based or mixed mode logging.
|
|
# But this would require different result files. To handle this with the
|
|
# current test suite, new main test cases are required.
|
|
#
|
|
--source include/have_binlog_format_row.inc
|
|
--source include/have_ucs2.inc
|
|
|
|
--source include/mysqlbinlog_row_engine.inc
|
|
|
|
SET GLOBAL innodb_stats_auto_recalc=@save_stats_auto_recalc;
|