Debian Codegraph @

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

raw
1 set global innodb_file_per_table=ON;
2 set global innodb_thread_concurrency=20;
3 create table t2 (c1 int not null primary key, c2 int not null default 0) engine=InnoDB;
4 insert into t2 (c1, c2) values (1, 1);
5 create table t3 (c1 int not null primary key, c2 int not null default 0) engine=InnoDB;
6 insert into t3 (c1, c2) values (1, 1);
7 create table t4 (c1 int not null primary key, c2 int not null default 0) engine=InnoDB;
8 insert into t4 (c1, c2) values (1, 1);
9 create table t5 (c1 int not null primary key, c2 int not null default 0) engine=InnoDB;
10 insert into t5 (c1, c2) values (1, 1);
11 create table t6 (c1 int not null primary key, c2 int not null default 0) engine=InnoDB;
12 insert into t6 (c1, c2) values (1, 1);
13 create database test2;
14 create table test2.t7 (c1 int not null primary key, c2 int not null default 0) engine=InnoDB;
15 insert into test2.t7 (c1, c2) values (1, 1);
16 drop table test2.t7;
17 set global DEBUG="+d,ib_buf_pool_resize_wait_before_resize";
18 set global innodb_buffer_pool_size = 12*1024*1024;
19 set global innodb_buffer_pool_size = 8*1024*1024;
20 Warnings:
21 Warning 3166 Another buffer pool resize is already in progress.
22 select @@global.innodb_buffer_pool_size;
23 @@global.innodb_buffer_pool_size
24 12582912
25 select @@global.innodb_adaptive_hash_index;
26 @@global.innodb_adaptive_hash_index
27 0
28 set global innodb_adaptive_hash_index = ON;
29 select @@global.innodb_adaptive_hash_index;
30 @@global.innodb_adaptive_hash_index
31 0
32 set global innodb_adaptive_hash_index = OFF;
33 select @@global.innodb_adaptive_hash_index;
34 @@global.innodb_adaptive_hash_index
35 0
36 create table t1 (c1 int not null primary key, c2 int not null default 0) engine=InnoDB;
37 analyze table t2;
38 alter table t3 algorithm=inplace, add index idx (c1);
39 alter table t4 rename to t0;
40 drop table t5;
41 drop database test2;
42 select count(*) > 0 from information_schema.innodb_buffer_page;
43 set global DEBUG="-d,ib_buf_pool_resize_wait_before_resize";
44 Table Op Msg_type Msg_text
45 test.t2 analyze status OK
46 count(*) > 0
47 1
48 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* buffer pool 0 : failed to allocate new memory.");
49 set global DEBUG="+d,ib_buf_chunk_init_fails";
50 set global innodb_buffer_pool_size = 16*1024*1024;
51 set global DEBUG="-d,ib_buf_chunk_init_fails";
52 create table t8 (c1 int not null primary key, c2 int not null default 0) engine=InnoDB;
53 insert into t8 (c1, c2) values (1, 1);
54 drop table t8;
55 drop table t1;
56 drop table t2;
57 drop table t3;
58 drop table t0;
59 drop table t6;
60 #
61 # BUG#23590280 NO WARNING WHEN REDUCING INNODB_BUFFER_POOL_SIZE INSIZE THE FIRST CHUNK
62 #
63 SET GLOBAL innodb_fast_shutdown = 0;
64 # restart: --innodb-buffer-pool-size=24M --innodb-buffer-pool-chunk-size=24M
65 set @before_innodb_buffer_pool_size = @@innodb_buffer_pool_size;
66 set global innodb_buffer_pool_size=@before_innodb_buffer_pool_size div 2;
67 Warnings:
68 Warning 1210 InnoDB: Cannot resize buffer pool to lesser than chunk size of 25165824 bytes.
69 set global innodb_buffer_pool_size=@before_innodb_buffer_pool_size * 2;
70 set global innodb_buffer_pool_size=@before_innodb_buffer_pool_size;
71 set global innodb_buffer_pool_size=@before_innodb_buffer_pool_size;
72 # restart: