Debian Codegraph @

mysql-test/suite/innodb/t/log_file_size_online.test

raw
1 --source include/have_innodb.inc
2 --source include/have_sequence.inc
3 --source include/no_valgrind_without_big.inc
4
5 let SEARCH_FILE = $MYSQLTEST_VARDIR/log/mysqld.1.err;
6
7 SET GLOBAL innodb_log_file_size=4194304;
8 SHOW VARIABLES LIKE 'innodb_log_file_size';
9 SELECT global_value FROM information_schema.system_variables
10 WHERE variable_name = 'innodb_log_file_size';
11
12 CREATE TABLE t (
13 a INT PRIMARY KEY AUTO_INCREMENT,
14 b CHAR(255) NOT NULL)
15 ENGINE=INNODB;
16
17 INSERT INTO t SELECT NULL, REPEAT('a', 255) FROM seq_1_to_20000;
18
19 --let $restart_parameters=--innodb-log-file-size=4194304
20 --source include/restart_mysqld.inc
21
22 SELECT COUNT(*) FROM t;
23
24 SHOW VARIABLES LIKE 'innodb_log_file_size';
25 let SEARCH_PATTERN = InnoDB: Resized log to 4\\.000MiB;
26 --source include/search_pattern_in_file.inc
27
28 --error 0,ER_UNKNOWN_SYSTEM_VARIABLE
29 SET @save=@@global.innodb_log_file_buffering;
30 --error 0,ER_UNKNOWN_SYSTEM_VARIABLE
31 SET GLOBAL innodb_log_file_buffering=OFF;
32 --error 0,ER_UNKNOWN_SYSTEM_VARIABLE
33 SET GLOBAL innodb_log_file_buffering=ON;
34 --error 0,ER_UNKNOWN_SYSTEM_VARIABLE
35 SET GLOBAL innodb_log_file_buffering=@save;
36 --error ER_INCORRECT_GLOBAL_LOCAL_VAR,ER_UNKNOWN_SYSTEM_VARIABLE
37 SET GLOBAL innodb_log_file_mmap=OFF;
38
39 --connect con1,localhost,root
40 let $ID= `SELECT @id := CONNECTION_ID()`;
41 send SET GLOBAL innodb_log_file_size=7340032;
42 --connection default
43 let $ignore= `SELECT @id := $ID`;
44 KILL QUERY @id;
45 --connection con1
46 --error 0,ER_QUERY_INTERRUPTED
47 reap;
48
49 --connection default
50 send SET GLOBAL innodb_log_file_size=5242880;
51
52 --connection con1
53 send UPDATE t SET b='' WHERE a<10;
54
55 --connection default
56 reap;
57 SHOW VARIABLES LIKE 'innodb_log_file_size';
58 SELECT global_value FROM information_schema.system_variables
59 WHERE variable_name = 'innodb_log_file_size';
60
61 --connection con1
62 reap;
63 --disconnect con1
64 --connection default
65
66 --let $shutdown_timeout=0
67 --let $restart_parameters=
68 --source include/restart_mysqld.inc
69
70 SELECT * FROM t WHERE a<10;
71 SELECT COUNT(*),LENGTH(b) FROM t GROUP BY b;
72
73 SHOW VARIABLES LIKE 'innodb_log_file_size';
74 SET GLOBAL innodb_log_file_size=6291456;
75 SHOW VARIABLES LIKE 'innodb_log_file_size';
76 SET GLOBAL innodb_log_file_size=5242880;
77 SHOW VARIABLES LIKE 'innodb_log_file_size';
78 let SEARCH_PATTERN = InnoDB: Resized log to 6\\.000MiB;
79 --source include/search_pattern_in_file.inc
80
81 DROP TABLE t;