Debian Codegraph @

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

raw
1 let buffer_size=`SELECT @@GLOBAL.innodb_log_buffer_size`;
2
3 --echo '#-----------------------------------------------------------#'
4 --echo 'Test what happens when the innodb_log_buffer_size is changed'
5 --echo ' in runtime (both decreased and increased).'
6
7 --disable_query_log
8 CREATE TABLE t (a INT NOT NULL PRIMARY KEY, b BLOB);
9 DELIMITER |;
10
11 CREATE PROCEDURE insert_rows()
12 BEGIN
13 DECLARE i INT DEFAULT 0;
14 DECLARE no INT DEFAULT 0;
15 SET no = (SELECT @conn_counter);
16 WHILE i < 99 DO
17 INSERT INTO t VALUES (no*100+i, REPEAT('.', 5000));
18 SET i = i + 1;
19 END WHILE;
20 END|
21
22 DELIMITER ;|
23 --enable_query_log
24
25 INSERT INTO t VALUES (1000, 'a');
26 SET GLOBAL innodb_log_buffer_size = 1024*1024;
27 SELECT @@innodb_log_buffer_size;
28 INSERT INTO t VALUES (2000, 'b');
29 SET GLOBAL innodb_log_buffer_size = 256*1024;
30 SELECT @@innodb_log_buffer_size;
31 INSERT INTO t VALUES (3000, 'c');
32 SET GLOBAL innodb_log_buffer_size = 2048*1024;
33 SELECT @@innodb_log_buffer_size;
34 INSERT INTO t VALUES (4000, 'd');
35
36
37 let $n = 9;
38 let $i = 0;
39 while ($n) {
40 connect(con$n, localhost, root,,);
41 eval SET @conn_counter = $n;
42 send CALL insert_rows();
43 inc $i;
44 dec $n;
45 }
46
47 let $n = 9;
48 let $i = 0;
49 while ($n) {
50 --connection con$n
51 --reap
52 --disconnect con$n
53 inc $i;
54 dec $n;
55 }
56
57
58 --connection default
59
60 SET GLOBAL innodb_log_buffer_size = 256*1024;
61 SELECT @@innodb_log_buffer_size;
62 SET GLOBAL innodb_log_buffer_size = 256*1024 + 1024;
63 SELECT @@innodb_log_buffer_size;
64 SET GLOBAL innodb_log_buffer_size = 4096*1024;
65 SELECT @@innodb_log_buffer_size;
66 SET GLOBAL innodb_log_buffer_size = 256*1024 + 1024;
67 SELECT @@innodb_log_buffer_size;
68 SET GLOBAL innodb_log_buffer_size = 256*1024;
69 SELECT @@innodb_log_buffer_size;
70
71 --disable_query_log
72 DROP TABLE t;
73 DROP PROCEDURE insert_rows;
74 --enable_query_log
75
76 eval SET @@GLOBAL.innodb_log_buffer_size=$buffer_size;
77 SELECT @@innodb_log_buffer_size;