Debian Codegraph @

mysql-test/suite/innodb/include/log_disable_page_cleaners.inc

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