Debian Codegraph @

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

raw
1 SET GLOBAL innodb_log_file_size=4194304;
2 SHOW VARIABLES LIKE 'innodb_log_file_size';
3 Variable_name Value
4 innodb_log_file_size 4194304
5 SELECT global_value FROM information_schema.system_variables
6 WHERE variable_name = 'innodb_log_file_size';
7 global_value
8 4194304
9 CREATE TABLE t (
10 a INT PRIMARY KEY AUTO_INCREMENT,
11 b CHAR(255) NOT NULL)
12 ENGINE=INNODB;
13 INSERT INTO t SELECT NULL, REPEAT('a', 255) FROM seq_1_to_20000;
14 # restart: --innodb-log-file-size=4194304
15 SELECT COUNT(*) FROM t;
16 COUNT(*)
17 20000
18 SHOW VARIABLES LIKE 'innodb_log_file_size';
19 Variable_name Value
20 innodb_log_file_size 4194304
21 FOUND 1 /InnoDB: Resized log to 4\.000MiB/ in mysqld.1.err
22 SET @save=@@global.innodb_log_file_buffering;
23 SET GLOBAL innodb_log_file_buffering=OFF;
24 SET GLOBAL innodb_log_file_buffering=ON;
25 SET GLOBAL innodb_log_file_buffering=@save;
26 SET GLOBAL innodb_log_file_mmap=OFF;
27 Got one of the listed errors
28 connect con1,localhost,root;
29 SET GLOBAL innodb_log_file_size=7340032;
30 connection default;
31 KILL QUERY @id;
32 connection con1;
33 connection default;
34 SET GLOBAL innodb_log_file_size=5242880;
35 connection con1;
36 UPDATE t SET b='' WHERE a<10;
37 connection default;
38 SHOW VARIABLES LIKE 'innodb_log_file_size';
39 Variable_name Value
40 innodb_log_file_size 5242880
41 SELECT global_value FROM information_schema.system_variables
42 WHERE variable_name = 'innodb_log_file_size';
43 global_value
44 5242880
45 connection con1;
46 disconnect con1;
47 connection default;
48 # restart
49 SELECT * FROM t WHERE a<10;
50 a b
51 1
52 2
53 3
54 4
55 5
56 6
57 7
58 8
59 9
60 SELECT COUNT(*),LENGTH(b) FROM t GROUP BY b;
61 COUNT(*) LENGTH(b)
62 9 0
63 19991 255
64 SHOW VARIABLES LIKE 'innodb_log_file_size';
65 Variable_name Value
66 innodb_log_file_size 5242880
67 SET GLOBAL innodb_log_file_size=6291456;
68 SHOW VARIABLES LIKE 'innodb_log_file_size';
69 Variable_name Value
70 innodb_log_file_size 6291456
71 SET GLOBAL innodb_log_file_size=5242880;
72 SHOW VARIABLES LIKE 'innodb_log_file_size';
73 Variable_name Value
74 innodb_log_file_size 5242880
75 FOUND 1 /InnoDB: Resized log to 6\.000MiB/ in mysqld.1.err
76 DROP TABLE t;