Debian Codegraph @

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

raw
1 #
2 # MDEV-29445: Reorganize buffer pool (and remove chunks)
3 #
4 set global innodb_adaptive_hash_index=ON;
5 select @@innodb_buffer_pool_size;
6 @@innodb_buffer_pool_size
7 8388608
8 set global innodb_buffer_pool_size = 9437184;
9 set global innodb_buffer_pool_size = 10485760;
10 select @@innodb_buffer_pool_size;
11 @@innodb_buffer_pool_size
12 10485760
13 create table t1 (id int primary key, val int not null)
14 ENGINE=InnoDB ROW_FORMAT=COMPRESSED;
15 create table t2 (id int primary key, val int not null)
16 ENGINE=InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=$kbs;
17 SET STATEMENT foreign_key_checks=0, unique_checks=0 FOR
18 INSERT INTO t1 SELECT seq*4,seq*4 FROM seq_1_to_262144;
19 SET STATEMENT foreign_key_checks=0, unique_checks=0 FOR
20 INSERT INTO t2 SELECT seq*4,seq*4 FROM seq_1_to_16384;
21 SELECT @@GLOBAL.innodb_adaptive_hash_index;
22 @@GLOBAL.innodb_adaptive_hash_index
23 1
24 SET STATEMENT max_statement_time=1e-9 FOR
25 SET GLOBAL innodb_buffer_pool_size = 7340032;
26 SELECT @@GLOBAL.innodb_adaptive_hash_index;
27 @@GLOBAL.innodb_adaptive_hash_index
28 1
29 FOUND 1 /innodb_buffer_pool_size=7m.*resized from|innodb_buffer_pool_size change aborted/ in mysqld.1.err
30 set global innodb_buffer_pool_size = 7340032;
31 select count(val) from t1;
32 count(val)
33 262144
34 select count(val) from t2;
35 count(val)
36 16384
37 set global innodb_adaptive_hash_index=OFF;
38 set global innodb_buffer_pool_size = 24117248;
39 set global innodb_buffer_pool_size = 26214400;
40 Warnings:
41 Warning 1292 Truncated incorrect innodb_buffer_pool_size value: '26214400'
42 select @@innodb_buffer_pool_size;
43 @@innodb_buffer_pool_size
44 25165824
45 select count(val) from t1;
46 count(val)
47 262144
48 select count(val) from t2;
49 count(val)
50 16384
51 drop table t1,t2;
52 SET GLOBAL innodb_max_purge_lag_wait = 0;
53 SET @save_pct= @@GLOBAL.innodb_max_dirty_pages_pct;
54 SET @save_pct_lwm= @@GLOBAL.innodb_max_dirty_pages_pct_lwm;
55 SET GLOBAL innodb_max_dirty_pages_pct_lwm = 0.0;
56 SET GLOBAL innodb_max_dirty_pages_pct = 0.0;
57 SET GLOBAL innodb_buffer_pool_size = @old_innodb_buffer_pool_size;
58 SET GLOBAL innodb_adaptive_hash_index = @old_innodb_adaptive_hash_index;
59 SET GLOBAL innodb_max_dirty_pages_pct = @save_pct;
60 SET GLOBAL innodb_max_dirty_pages_pct_lwm = @save_pct_lwm;