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
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
|
--source include/have_debug.inc
--source include/ib_log_spammer_init.inc
SET GLOBAL innodb_log_checkpoint_now = 1;
let SEARCH_FILE=$MYSQLTEST_VARDIR/log/mysqld.1.err;
--echo # Initial state:
SELECT variable_name, variable_value FROM performance_schema.global_status
WHERE variable_name = 'Innodb_redo_log_capacity_resized';
--echo # Resize redo log to 100M:
SET GLOBAL innodb_redo_log_capacity = 100*1024*1024;
let SEARCH_PATTERN=User has set innodb_redo_log_capacity to 100M;
--source include/search_pattern.inc
let SEARCH_PATTERN=Redo log has been resized to 100M;
--source include/search_pattern.inc
--echo # Current state:
SELECT variable_name, variable_value FROM performance_schema.global_status
WHERE variable_name = 'Innodb_redo_log_capacity_resized';
--echo # Create connection which generates spam to the redo log.
--connect(C1,localhost,root,,test)
--send CALL log_spammer()
--connection default
--echo # Disable checkpointing to ensure redo would grow and to allow test of redo-resize cancellation.
SET GLOBAL innodb_checkpoint_disabled = 1;
--echo # Wait until redo occupies at least 10MB
let $wait_timeout= 600;
let $wait_condition =
SELECT variable_value >= 10*1024*1024
FROM performance_schema.global_status
WHERE variable_name = 'Innodb_redo_log_logical_size';
--source include/wait_condition.inc
--echo # Start resizing down the redo log (spammer is working in background)
SET GLOBAL innodb_redo_log_capacity = 9*1024*1024;
let SEARCH_PATTERN=User has set innodb_redo_log_capacity to 9M;
--source include/search_pattern.inc
let SEARCH_PATTERN=Redo log has been requested to resize from 100M to 9M;
--source include/search_pattern.inc
--echo # Expected - not found:
let SEARCH_PATTERN=Redo log has been resized to 9M;
--source include/search_pattern.inc
--echo # Checkpoint is still disabled so resize hasn't been finished. Cancel the resize.
SET GLOBAL innodb_redo_log_capacity = 102*1024*1024;
let SEARCH_PATTERN=User has set innodb_redo_log_capacity to 102M;
--source include/search_pattern.inc
let SEARCH_PATTERN=Redo log resize has been cancelled;
--source include/search_pattern.inc
let SEARCH_PATTERN=Redo log has been resized to 102M;
--source include/search_pattern.inc
--echo # Restart resizing down.
SET GLOBAL innodb_redo_log_capacity = 8*1024*1024;
let SEARCH_PATTERN=User has set innodb_redo_log_capacity to 8M;
--source include/search_pattern.inc
let SEARCH_PATTERN=Redo log has been requested to resize from 102M to 8M;
--source include/search_pattern.inc
--echo # Expected - not found:
let SEARCH_PATTERN=Redo log has been resized to 8M;
--source include/search_pattern.inc
SET GLOBAL innodb_checkpoint_disabled = 0;
--echo # Waiting for status = OK....
let $wait_timeout= 600;
let $wait_condition =
SELECT variable_value = 'OK'
FROM performance_schema.global_status
WHERE variable_name = 'Innodb_redo_log_resize_status';
--source include/wait_condition.inc
let SEARCH_PATTERN=Redo log has been resized to 8M;
--source include/search_pattern.inc
--echo # Current state:
SELECT variable_name, variable_value FROM performance_schema.global_status
WHERE variable_name = 'Innodb_redo_log_capacity_resized';
let MYSQLD_DATADIR = `SELECT @@datadir`;
let MYSQLD_IB_REDO_LOG_PHYSICAL_CAPACITY = 8388608;
--source include/ib_redo_log_capacity_check.inc
--echo # Kill and restart mysql:
--source include/kill_and_restart_mysqld.inc
--echo # Initial state:
SELECT variable_name, variable_value FROM performance_schema.global_status
WHERE variable_name = 'Innodb_redo_log_capacity_resized';
--echo # Resize redo log to 500M:
SET GLOBAL innodb_redo_log_capacity = 500*1024*1024;
--echo # Current state:
SELECT variable_name, variable_value FROM performance_schema.global_status
WHERE variable_name = 'Innodb_redo_log_capacity_resized';
--echo # Create connection which generates spam to the redo log.
--connect(C2,localhost,root,,test)
--send CALL log_spammer()
--connection default
--echo # Wait until redo occupies at least 10MB
let $wait_timeout= 600;
let $wait_condition =
SELECT variable_value >= 10*1024*1024
FROM performance_schema.global_status
WHERE variable_name = 'Innodb_redo_log_physical_size';
--source include/wait_condition.inc
--echo # Kill and restart mysql with --innodb-redo-log-capacity=1G:
--let $restart_parameters = restart: --innodb-redo-log-capacity=1G
--source include/kill_and_restart_mysqld.inc
--echo # Initial state:
SELECT variable_name, variable_value FROM performance_schema.global_status
WHERE variable_name = 'Innodb_redo_log_capacity_resized';
--echo # Start resizing down the redo log (spammer is NOT working in background)
SET GLOBAL innodb_redo_log_capacity = 8*1024*1024;
--echo # Waiting for status = OK....
let $wait_timeout= 60000;
let $wait_condition =
SELECT variable_value = 'OK'
FROM performance_schema.global_status
WHERE variable_name = 'Innodb_redo_log_resize_status';
--source include/wait_condition.inc
--echo # Current state:
SELECT variable_name, variable_value FROM performance_schema.global_status
WHERE variable_name = 'Innodb_redo_log_capacity_resized';
let MYSQLD_DATADIR = `SELECT @@datadir`;
let MYSQLD_IB_REDO_LOG_PHYSICAL_CAPACITY = 8388608;
--source include/ib_redo_log_capacity_check.inc
--echo # Create connection which generates spam to the redo log.
--connect(C3,localhost,root,,test)
--send CALL log_spammer()
--connection default
--echo # Resize redo log to 1GB:
SET GLOBAL innodb_redo_log_capacity = 1024*1024*1024;
--echo # Current state:
SELECT variable_name, variable_value FROM performance_schema.global_status
WHERE variable_name = 'Innodb_redo_log_capacity_resized';
--echo # Wait until redo occupies at least 20MB
let $wait_timeout= 600;
let $wait_condition =
SELECT variable_value >= 20*1024*1024
FROM performance_schema.global_status
WHERE variable_name = 'Innodb_redo_log_physical_size';
--source include/wait_condition.inc
--echo # Kill and restart mysql without --innodb-redo-log-capacity
--let $restart_parameters = restart:
--source include/kill_and_restart_mysqld.inc
let SEARCH_PATTERN=Redo log has been requested to resize from .* to .*M;
--source include/search_pattern.inc
--source include/ib_log_spammer_cleanup.inc
|
