blob: f3c559a60a90835badd958490fd980d94c899941 (
plain)
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
|
--source include/have_innodb.inc
--source include/have_sequence.inc
let SEARCH_FILE = $MYSQLTEST_VARDIR/log/mysqld.1.err;
SET GLOBAL innodb_log_file_size=4194304;
SHOW VARIABLES LIKE 'innodb_log_file_size';
SELECT global_value FROM information_schema.system_variables
WHERE variable_name = 'innodb_log_file_size';
CREATE TABLE t (
a INT PRIMARY KEY AUTO_INCREMENT,
b CHAR(255) NOT NULL)
ENGINE=INNODB;
INSERT INTO t SELECT NULL, REPEAT('a', 255) FROM seq_1_to_20000;
--let $restart_parameters=--innodb-log-file-size=4194304
--source include/restart_mysqld.inc
SELECT COUNT(*) FROM t;
SHOW VARIABLES LIKE 'innodb_log_file_size';
let SEARCH_PATTERN = InnoDB: Resized log to 4\\.000MiB;
--source include/search_pattern_in_file.inc
UPDATE t SET b='' WHERE a<10;
SET GLOBAL innodb_log_file_size=5242880;
SHOW VARIABLES LIKE 'innodb_log_file_size';
SELECT global_value FROM information_schema.system_variables
WHERE variable_name = 'innodb_log_file_size';
--let $restart_parameters=
--source include/restart_mysqld.inc
SELECT * FROM t WHERE a<10;
SHOW VARIABLES LIKE 'innodb_log_file_size';
let SEARCH_PATTERN = InnoDB: Resized log to 5\\.000MiB;
--source include/search_pattern_in_file.inc
DROP TABLE t;
|