Debian Codegraph @

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

raw
1 SET @save_limit=@@GLOBAL.innodb_limit_optimistic_insert_debug;
2 SET @save_size=@@GLOBAL.innodb_buffer_pool_size;
3 SET GLOBAL innodb_limit_optimistic_insert_debug=2;
4 SET GLOBAL innodb_buffer_pool_size=16777216;
5 call mtr.add_suppression("innodb_buffer_pool_size change aborted");
6 SET @old_innodb_adaptive_hash_index = @@innodb_adaptive_hash_index;
7 SET GLOBAL innodb_adaptive_hash_index = ON;
8 SET STATEMENT debug_dbug='+d,buf_shrink_fail' FOR
9 SET GLOBAL innodb_buffer_pool_size=8388608;
10 ERROR HY000: innodb_buffer_pool_size change aborted
11 SELECT @@GLOBAL.innodb_adaptive_hash_index,@@GLOBAL.innodb_buffer_pool_size;
12 @@GLOBAL.innodb_adaptive_hash_index @@GLOBAL.innodb_buffer_pool_size
13 1 16777216
14 SET GLOBAL innodb_adaptive_hash_index = @old_innodb_adaptive_hash_index;
15 CREATE TEMPORARY TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
16 INSERT INTO t1 SELECT seq FROM seq_1_to_200;
17 SET GLOBAL innodb_max_purge_lag_wait=0;
18 SET @save_pct= @@GLOBAL.innodb_max_dirty_pages_pct;
19 SET @save_pct_lwm= @@GLOBAL.innodb_max_dirty_pages_pct_lwm;
20 SET GLOBAL innodb_max_dirty_pages_pct_lwm = 0.0;
21 SET GLOBAL innodb_max_dirty_pages_pct = 0.0;
22 SHOW STATUS LIKE 'innodb_buffer_pool_resize_status';
23 Variable_name Value
24 Innodb_buffer_pool_resize_status
25 connect con1,localhost,root;
26 SET DEBUG_SYNC='buf_pool_shrink_before_wakeup SIGNAL blocked WAIT_FOR go';
27 SET GLOBAL innodb_buffer_pool_size=8388608;
28 connection default;
29 SET DEBUG_SYNC='now WAIT_FOR blocked';
30 SHOW STATUS LIKE 'innodb_buffer_pool_resize_status';
31 Variable_name Value
32 Innodb_buffer_pool_resize_status Withdrawing blocks. (505/505).
33 SET DEBUG_SYNC='now SIGNAL go';
34 connection con1;
35 disconnect con1;
36 connection default;
37 SHOW STATUS LIKE 'innodb_buffer_pool_resize_status';
38 Variable_name Value
39 Innodb_buffer_pool_resize_status
40 SET DEBUG_SYNC=RESET;
41 SET GLOBAL innodb_max_dirty_pages_pct = @save_pct;
42 SET GLOBAL innodb_max_dirty_pages_pct_lwm = @save_pct_lwm;
43 SELECT COUNT(*),MIN(a),MAX(a) FROM t1;
44 COUNT(*) MIN(a) MAX(a)
45 200 1 200
46 DROP TEMPORARY TABLE t1;
47 SET GLOBAL innodb_limit_optimistic_insert_debug=@save_limit;
48 SET GLOBAL innodb_buffer_pool_size=@save_size;