Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_buffer_pool_dump_abort_loads.result

raw
1
2 # innodb_buffer_pool_load_incomplete defaults 0
3 SELECT variable_name, variable_value
4 FROM information_schema.global_status
5 WHERE LOWER(variable_name) = 'innodb_buffer_pool_load_incomplete';
6 variable_name variable_value
7 INNODB_BUFFER_POOL_LOAD_INCOMPLETE OFF
8
9 # populate with data
10 CREATE TABLE t1 (
11 c01 blob, c02 blob, c03 blob, c04 blob, c05 blob,
12 c06 blob, c07 blob, c08 blob, c09 blob, c10 blob,
13 c11 blob, c12 blob, c13 blob, c14 blob, c15 blob,
14 c16 blob, c17 blob, c18 blob, c19 blob, c20 blob,
15 c21 blob, c22 blob, c23 blob, c24 blob, c25 blob,
16 c26 blob, c27 blob, c28 blob, c29 blob, c30 blob,
17 c31 blob, c32 blob, c33 blob, c34 blob, c35 blob,
18 c36 blob, c37 blob, c38 blob, c39 blob, c40 blob,
19 c41 blob, c42 blob, c43 blob, c44 blob, c45 blob,
20 c46 blob, c47 blob, c48 blob, c49 blob, c50 blob,
21 c51 blob, c52 blob, c53 blob, c54 blob, c55 blob,
22 c56 blob, c57 blob, c58 blob, c59 blob, c60 blob,
23 c61 blob, c62 blob, c63 blob, c64 blob
24 ) ROW_FORMAT=dynamic;
25 SET @a = repeat('a', 16 * 1024);
26 INSERT INTO t1 VALUES (@a,@a,@a,@a,@a,
27 @a,@a,@a,@a,@a,
28 @a,@a,@a,@a,@a,
29 @a,@a,@a,@a,@a,
30 @a,@a,@a,@a,@a,
31 @a,@a,@a,@a,@a,
32 @a,@a,@a,@a,@a,
33 @a,@a,@a,@a,@a,
34 @a,@a,@a,@a,@a,
35 @a,@a,@a,@a,@a,
36 @a,@a,@a,@a,@a,
37 @a,@a,@a,@a,@a,
38 @a,@a,@a,@a
39 );
40 SET GLOBAL innodb_buffer_pool_dump_now=1;
41
42 # Restart server
43 # restart
44
45 # Abort after 16 pages
46 SET GLOBAL innodb_buffer_pool_load_pages_abort=16,
47 GLOBAL innodb_buffer_pool_load_now=1,
48 GLOBAL innodb_buffer_pool_dump_at_shutdown=1;
49 SELECT variable_name, SUBSTR(variable_value, 1, 38) as VALUE
50 FROM information_schema.global_status
51 WHERE LOWER(variable_name) IN ('innodb_buffer_pool_load_incomplete','innodb_buffer_pool_load_status')
52 ORDER BY variable_name;
53 variable_name VALUE
54 INNODB_BUFFER_POOL_LOAD_INCOMPLETE ON
55 INNODB_BUFFER_POOL_LOAD_STATUS Buffer pool(s) load aborted on request
56
57 # Restart server
58 # restart
59
60 # Load buffer pool
61 SET GLOBAL innodb_buffer_pool_load_now=1;
62
63 # Should be more than previous as we didn't overwrite our save file
64 select count(*) > Previous_loaded as Loaded_more from information_schema.INNODB_BUFFER_PAGE WHERE PAGE_TYPE='BLOB' group by PAGE_TYPE;;
65 Loaded_more
66 1
67
68 # Successful, so innodb_buffer_pool_load_incomplete should be FALSE
69 SELECT variable_name, SUBSTR(variable_value, 1, 33) as VALUE
70 FROM information_schema.global_status
71 WHERE LOWER(variable_name) IN ('innodb_buffer_pool_load_incomplete','innodb_buffer_pool_load_status')
72 ORDER BY variable_name;
73 variable_name VALUE
74 INNODB_BUFFER_POOL_LOAD_INCOMPLETE OFF
75 INNODB_BUFFER_POOL_LOAD_STATUS Buffer pool(s) load completed at
76
77 # innodb_buffer_pool_dump_now=1 should reset the innodb_buffer_pool_load_incomplete status
78 SET GLOBAL innodb_buffer_pool_dump_now=1;
79 SELECT variable_name, SUBSTR(variable_value, 1, 33) as VALUE
80 FROM information_schema.global_status
81 WHERE LOWER(variable_name) IN ('innodb_buffer_pool_load_incomplete', 'innodb_buffer_pool_dump_status');
82 variable_name VALUE
83 INNODB_BUFFER_POOL_DUMP_STATUS Buffer pool(s) dump completed at
84 INNODB_BUFFER_POOL_LOAD_INCOMPLETE OFF
85
86 # Restart server
87 # restart
88
89 # Load buffer pool
90 SET GLOBAL innodb_buffer_pool_load_now=1;
91
92 # Should be same amount
93 select abs(Previously_dumped - count(*)) <= 2 as Loaded_about_same_size from information_schema.INNODB_BUFFER_PAGE WHERE PAGE_TYPE='BLOB' group by PAGE_TYPE;;
94 Loaded_about_same_size
95 1
96
97 # Clean up
98 DROP TABLE t1;