1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
|
# This script disables:
# - page cleaner threads,
# - threads which could assume that pages should have
# been flushed eventually,
# - background threads which potentially could try to
# modify a page,
# - checkpointing mechanism.
#
# This is a very useful utility in tests which need to freeze
# the checkpointing mechanism to fill the redo log. It allows
# to do that avoiding risk that some background thread could
# be awaiting for checkpoint advanced.
# Disable background threads that could modify pages.
SET GLOBAL innodb_dict_stats_disabled_debug = 1;
SET GLOBAL innodb_master_thread_disabled_debug = 1;
# Disable generating GTIDs, and disable periodic GTID write-out.
# Generating GTIDs can lead to foreground threads wait for the write-out.
SET GLOBAL debug = "+d,disable_se_persists_gtid";
FLUSH ENGINE LOGS;
SET GLOBAL debug = "+d,gtid_persist_flush_disable";
# Flush all dirty pages and write a checkpoint so we would
# always start filling redo log starting from an empty one.
SET GLOBAL innodb_log_checkpoint_now = 1;
# Disable page cleaner threads, because we are going to fill
# redo log and we want to collect a group of dirty pages for
# which the redo log records protect changes.
SET GLOBAL innodb_page_cleaner_disabled_debug = 1;
# Disable checkpoint writes (they potentially could end up
# awaiting for a page flush, but page cleaners are disabled).
SET GLOBAL innodb_checkpoint_disabled = 1;
# Disable undo purge coordinator thread, because it could try
# to use a mini-transaction and end up awaiting on a page,
# when keeping some rw-lock from DD (leading to a global stall
# when other threads needed that rw-lock).
SET GLOBAL innodb_purge_stop_now = 1;
|
