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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
|
--disable_query_log
# MTR's check of test cases ensures that the state of innodb
# monitors(enabled/disabled) are not changed by tests.
# Some InnoDB monitors are enabled by default. In case some
# monitors are enabled during a test, there is no direct way
# to get back to the initial state of enabled monitors
# other than disabling them on a case-by-case basis.
#
# The purpose of this .inc file is to only retain those
# monitors which are enabled by default and disable the
# rest so that monitors changed in a test do not affect
# other tests.
SET GLOBAL innodb_monitor_disable=all;
SET GLOBAL innodb_monitor_enable="adaptive_hash_searches";
SET GLOBAL innodb_monitor_enable="adaptive_hash_searches_btree";
SET GLOBAL innodb_monitor_enable="buffer_data_reads";
SET GLOBAL innodb_monitor_enable="buffer_data_written";
SET GLOBAL innodb_monitor_enable="buffer_pages_created";
SET GLOBAL innodb_monitor_enable="buffer_pages_read";
SET GLOBAL innodb_monitor_enable="buffer_pages_written";
SET GLOBAL innodb_monitor_enable="buffer_pool_bytes_data";
SET GLOBAL innodb_monitor_enable="buffer_pool_bytes_dirty";
SET GLOBAL innodb_monitor_enable="buffer_pool_pages_data";
SET GLOBAL innodb_monitor_enable="buffer_pool_pages_dirty";
SET GLOBAL innodb_monitor_enable="buffer_pool_pages_free";
SET GLOBAL innodb_monitor_enable="buffer_pool_pages_misc";
SET GLOBAL innodb_monitor_enable="buffer_pool_pages_total";
SET GLOBAL innodb_monitor_enable="buffer_pool_reads";
SET GLOBAL innodb_monitor_enable="buffer_pool_read_ahead";
SET GLOBAL innodb_monitor_enable="buffer_pool_read_ahead_evicted";
SET GLOBAL innodb_monitor_enable="buffer_pool_read_requests";
SET GLOBAL innodb_monitor_enable="buffer_pool_size";
SET GLOBAL innodb_monitor_enable="buffer_pool_wait_free";
SET GLOBAL innodb_monitor_enable="buffer_pool_write_requests";
SET GLOBAL innodb_monitor_enable="dml_deletes";
SET GLOBAL innodb_monitor_enable="dml_inserts";
SET GLOBAL innodb_monitor_enable="dml_system_deletes";
SET GLOBAL innodb_monitor_enable="dml_system_inserts";
SET GLOBAL innodb_monitor_enable="dml_system_reads";
SET GLOBAL innodb_monitor_enable="dml_system_updates";
SET GLOBAL innodb_monitor_enable="dml_updates";
SET GLOBAL innodb_monitor_enable="file_num_open_files";
SET GLOBAL innodb_monitor_enable="ibuf_merges";
SET GLOBAL innodb_monitor_enable="ibuf_merges_delete";
SET GLOBAL innodb_monitor_enable="ibuf_merges_delete_mark";
SET GLOBAL innodb_monitor_enable="ibuf_merges_discard_delete";
SET GLOBAL innodb_monitor_enable="ibuf_merges_discard_delete_mark";
SET GLOBAL innodb_monitor_enable="ibuf_merges_discard_insert";
SET GLOBAL innodb_monitor_enable="ibuf_merges_insert";
SET GLOBAL innodb_monitor_enable="ibuf_size";
SET GLOBAL innodb_monitor_enable="innodb_activity_count";
SET GLOBAL innodb_monitor_enable="innodb_dblwr_pages_written";
SET GLOBAL innodb_monitor_enable="innodb_dblwr_writes";
SET GLOBAL innodb_monitor_enable="innodb_page_size";
SET GLOBAL innodb_monitor_enable="innodb_rwlock_sx_os_waits";
SET GLOBAL innodb_monitor_enable="innodb_rwlock_sx_spin_rounds";
SET GLOBAL innodb_monitor_enable="innodb_rwlock_sx_spin_waits";
SET GLOBAL innodb_monitor_enable="innodb_rwlock_s_os_waits";
SET GLOBAL innodb_monitor_enable="innodb_rwlock_s_spin_rounds";
SET GLOBAL innodb_monitor_enable="innodb_rwlock_s_spin_waits";
SET GLOBAL innodb_monitor_enable="innodb_rwlock_x_os_waits";
SET GLOBAL innodb_monitor_enable="innodb_rwlock_x_spin_rounds";
SET GLOBAL innodb_monitor_enable="innodb_rwlock_x_spin_waits";
SET GLOBAL innodb_monitor_enable="lock_deadlocks";
SET GLOBAL innodb_monitor_enable="lock_deadlock_false_positives";
SET GLOBAL innodb_monitor_enable="lock_deadlock_rounds";
SET GLOBAL innodb_monitor_enable="lock_rec_grant_attempts";
SET GLOBAL innodb_monitor_enable="lock_rec_release_attempts";
SET GLOBAL innodb_monitor_enable="lock_row_lock_current_waits";
SET GLOBAL innodb_monitor_enable="lock_row_lock_time";
SET GLOBAL innodb_monitor_enable="lock_row_lock_time_avg";
SET GLOBAL innodb_monitor_enable="lock_row_lock_time_max";
SET GLOBAL innodb_monitor_enable="lock_row_lock_waits";
SET GLOBAL innodb_monitor_enable="lock_schedule_refreshes";
SET GLOBAL innodb_monitor_enable="lock_threads_waiting";
SET GLOBAL innodb_monitor_enable="lock_timeouts";
SET GLOBAL innodb_monitor_enable="log_waits";
SET GLOBAL innodb_monitor_enable="log_writes";
SET GLOBAL innodb_monitor_enable="log_write_requests";
SET GLOBAL innodb_monitor_enable="os_data_fsyncs";
SET GLOBAL innodb_monitor_enable="os_data_reads";
SET GLOBAL innodb_monitor_enable="os_data_writes";
SET GLOBAL innodb_monitor_enable="os_log_bytes_written";
SET GLOBAL innodb_monitor_enable="os_log_fsyncs";
SET GLOBAL innodb_monitor_enable="os_log_pending_fsyncs";
SET GLOBAL innodb_monitor_enable="os_log_pending_writes";
SET GLOBAL innodb_monitor_enable="trx_rseg_history_len";
# NOTE:
# The default value for below variables is an empty string
# it assigning an empty string using the SET statement results
# in an error. The only way we can restore the value of the
# variable and avoid check_testcase failures is by trying to
# set the variable to its default value. Even though the
# variable has no default value, the value gets reset to an
# empty string and throws the below warning:
# Warning NNNN Default value is not defined for this set option.
# Please specify correct counter or module name.
--disable_warnings ER_NO_DEFAULT
SET GLOBAL innodb_monitor_enable=default;
SET GLOBAL innodb_monitor_disable=default;
SET GLOBAL innodb_monitor_reset=default;
SET GLOBAL innodb_monitor_reset_all=default;
--enable_warnings ER_NO_DEFAULT
--enable_query_log
|
