Debian Codegraph @

mysql-test/suite/innodb/r/log_file_resize_2.result

raw
1 # Prepare schema used in the tests.
2 # Ensure there is a lot of free space in the redo log.
3 SET GLOBAL innodb_log_checkpoint_now = ON;
4 SET GLOBAL DEBUG="+d,log_force_consumption";
5 # Waiting until we have exactly 1 redo log file.
6 There are <= 1 non-temporary redo log files.
7 # Disable checkpointing
8 SET GLOBAL innodb_checkpoint_disabled = ON;
9 CREATE TABLE t (a INT) ENGINE=InnoDB;
10 # Create connection which generates spam to the redo log.
11 CALL log_spammer();
12 # Redo log data is being generated and redo is resized-up after each round.
13 "Waiting for physical size to reach 75% of"
14 SELECT @@innodb_redo_log_capacity;
15 @@innodb_redo_log_capacity
16 10485760
17 SET GLOBAL innodb_redo_log_capacity = @@innodb_redo_log_capacity * 2;
18 "Waiting for physical size to reach 75% of"
19 SELECT @@innodb_redo_log_capacity;
20 @@innodb_redo_log_capacity
21 20971520
22 SET GLOBAL innodb_redo_log_capacity = @@innodb_redo_log_capacity * 2;
23 "Waiting for physical size to reach 75% of"
24 SELECT @@innodb_redo_log_capacity;
25 @@innodb_redo_log_capacity
26 41943040
27 SET GLOBAL innodb_redo_log_capacity = @@innodb_redo_log_capacity * 2;
28 "Waiting for physical size to reach 75% of"
29 SELECT @@innodb_redo_log_capacity;
30 @@innodb_redo_log_capacity
31 83886080
32 SET GLOBAL innodb_redo_log_capacity = @@innodb_redo_log_capacity * 2;
33 # Create 1 row in t.
34 INSERT INTO t(a) VALUES(42);
35 # Enable checkpointing
36 SET GLOBAL innodb_checkpoint_disabled = OFF;
37 # Redo log is resized-down in single shot.
38 SET GLOBAL innodb_redo_log_capacity = 10485760;
39 Timeout in wait_condition.inc for SELECT variable_value <= @@innodb_redo_log_capacity/1024/1024
40 FROM performance_schema.global_status WHERE variable_name = 'Innodb_redo_log_physical_size'
41 # Kill the MySQL and recover to see all is fine
42 # Kill and restart
43 SELECT * FROM t;
44 a
45 42
46 # Cleanup
47 DROP TABLE t;