Debian Codegraph @

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

raw
1 '#-----------------------------------------------------------#'
2 'Test what happens when the innodb_log_buffer_size is changed'
3 ' in runtime (both decreased and increased).'
4 INSERT INTO t VALUES (1000, 'a');
5 SET GLOBAL innodb_log_buffer_size = 1024*1024;
6 SELECT @@innodb_log_buffer_size;
7 @@innodb_log_buffer_size
8 1048576
9 INSERT INTO t VALUES (2000, 'b');
10 SET GLOBAL innodb_log_buffer_size = 256*1024;
11 SELECT @@innodb_log_buffer_size;
12 @@innodb_log_buffer_size
13 262144
14 INSERT INTO t VALUES (3000, 'c');
15 SET GLOBAL innodb_log_buffer_size = 2048*1024;
16 SELECT @@innodb_log_buffer_size;
17 @@innodb_log_buffer_size
18 2097152
19 INSERT INTO t VALUES (4000, 'd');
20 SET @conn_counter = 9;
21 CALL insert_rows();
22 SET @conn_counter = 8;
23 CALL insert_rows();
24 SET @conn_counter = 7;
25 CALL insert_rows();
26 SET @conn_counter = 6;
27 CALL insert_rows();
28 SET @conn_counter = 5;
29 CALL insert_rows();
30 SET @conn_counter = 4;
31 CALL insert_rows();
32 SET @conn_counter = 3;
33 CALL insert_rows();
34 SET @conn_counter = 2;
35 CALL insert_rows();
36 SET @conn_counter = 1;
37 CALL insert_rows();
38 SET GLOBAL innodb_log_buffer_size = 256*1024;
39 SELECT @@innodb_log_buffer_size;
40 @@innodb_log_buffer_size
41 262144
42 SET GLOBAL innodb_log_buffer_size = 256*1024 + 1024;
43 SELECT @@innodb_log_buffer_size;
44 @@innodb_log_buffer_size
45 263168
46 SET GLOBAL innodb_log_buffer_size = 4096*1024;
47 SELECT @@innodb_log_buffer_size;
48 @@innodb_log_buffer_size
49 4194304
50 SET GLOBAL innodb_log_buffer_size = 256*1024 + 1024;
51 SELECT @@innodb_log_buffer_size;
52 @@innodb_log_buffer_size
53 263168
54 SET GLOBAL innodb_log_buffer_size = 256*1024;
55 SELECT @@innodb_log_buffer_size;
56 @@innodb_log_buffer_size
57 262144
58 SET @@GLOBAL.innodb_log_buffer_size=16777216;
59 SELECT @@innodb_log_buffer_size;
60 @@innodb_log_buffer_size
61 16777216