Debian Codegraph @

mysql-test/suite/sys_vars/t/innodb_buffer_pool_dump_abort_loads.test

raw
1 #
2 # MDEV-11455 - add status variable innodb_buffer_pool_load_abort
3 #
4 --source include/have_innodb.inc
5 --source include/have_debug.inc
6 --source include/no_valgrind_without_big.inc
7
8 --echo
9 --echo # innodb_buffer_pool_load_incomplete defaults 0
10 SELECT variable_name, variable_value
11 FROM information_schema.global_status
12 WHERE LOWER(variable_name) = 'innodb_buffer_pool_load_incomplete';
13
14 --echo
15 --echo # populate with data
16
17 CREATE TABLE t1 (
18 c01 blob, c02 blob, c03 blob, c04 blob, c05 blob,
19 c06 blob, c07 blob, c08 blob, c09 blob, c10 blob,
20 c11 blob, c12 blob, c13 blob, c14 blob, c15 blob,
21 c16 blob, c17 blob, c18 blob, c19 blob, c20 blob,
22 c21 blob, c22 blob, c23 blob, c24 blob, c25 blob,
23 c26 blob, c27 blob, c28 blob, c29 blob, c30 blob,
24 c31 blob, c32 blob, c33 blob, c34 blob, c35 blob,
25 c36 blob, c37 blob, c38 blob, c39 blob, c40 blob,
26 c41 blob, c42 blob, c43 blob, c44 blob, c45 blob,
27 c46 blob, c47 blob, c48 blob, c49 blob, c50 blob,
28 c51 blob, c52 blob, c53 blob, c54 blob, c55 blob,
29 c56 blob, c57 blob, c58 blob, c59 blob, c60 blob,
30 c61 blob, c62 blob, c63 blob, c64 blob
31 ) ROW_FORMAT=dynamic;
32
33 SET @a = repeat('a', 16 * 1024);
34 INSERT INTO t1 VALUES (@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,@a,
39 @a,@a,@a,@a,@a,
40 @a,@a,@a,@a,@a,
41 @a,@a,@a,@a,@a,
42 @a,@a,@a,@a,@a,
43 @a,@a,@a,@a,@a,
44 @a,@a,@a,@a,@a,
45 @a,@a,@a,@a,@a,
46 @a,@a,@a,@a
47 );
48
49 SET GLOBAL innodb_buffer_pool_dump_now=1;
50 # Wait for for the dump to complete
51 let $wait_condition =
52 SELECT SUBSTR(variable_value, 1, 33) = 'Buffer pool(s) dump completed at '
53 FROM information_schema.global_status
54 WHERE LOWER(variable_name) = 'innodb_buffer_pool_dump_status';
55 -- source include/wait_condition.inc
56
57 --echo
58 --echo # Restart server
59 --source include/restart_mysqld.inc
60
61 --echo
62 --echo # Abort after 16 pages
63 SET GLOBAL innodb_buffer_pool_load_pages_abort=16,
64 GLOBAL innodb_buffer_pool_load_now=1,
65 GLOBAL innodb_buffer_pool_dump_at_shutdown=1;
66
67 let $wait_condition =
68 SELECT SUBSTR(variable_value, 1, 19) = 'Buffer pool(s) load'
69 FROM information_schema.global_status
70 WHERE LOWER(variable_name) = 'innodb_buffer_pool_load_status';
71 -- source include/wait_condition.inc
72
73 SELECT variable_name, SUBSTR(variable_value, 1, 38) as VALUE
74 FROM information_schema.global_status
75 WHERE LOWER(variable_name) IN ('innodb_buffer_pool_load_incomplete','innodb_buffer_pool_load_status')
76 ORDER BY variable_name;
77
78 --let $incomplete=`select count(*) as BLOB_PAGES from information_schema.INNODB_BUFFER_PAGE WHERE PAGE_TYPE='BLOB' group by PAGE_TYPE`
79
80 # Shouldn't dump at shutdown due to innodb_buffer_pool_load_incomplete
81
82 --echo
83 --echo # Restart server
84 --source include/restart_mysqld.inc
85
86 --echo
87 --echo # Load buffer pool
88 SET GLOBAL innodb_buffer_pool_load_now=1;
89
90 # Wait for for the load to complete
91 let $wait_condition =
92 SELECT SUBSTR(variable_value, 1, 33) = 'Buffer pool(s) load completed at '
93 FROM information_schema.global_status
94 WHERE LOWER(variable_name) = 'innodb_buffer_pool_load_status';
95 -- source include/wait_condition.inc
96
97 --echo
98 --echo # Should be more than previous as we didn't overwrite our save file
99 --replace_result $incomplete Previous_loaded
100 --eval select count(*) > $incomplete as Loaded_more from information_schema.INNODB_BUFFER_PAGE WHERE PAGE_TYPE='BLOB' group by PAGE_TYPE;
101
102 --echo
103 --echo # Successful, so innodb_buffer_pool_load_incomplete should be FALSE
104 SELECT variable_name, SUBSTR(variable_value, 1, 33) as VALUE
105 FROM information_schema.global_status
106 WHERE LOWER(variable_name) IN ('innodb_buffer_pool_load_incomplete','innodb_buffer_pool_load_status')
107 ORDER BY variable_name;
108
109 --echo
110 --echo # innodb_buffer_pool_dump_now=1 should reset the innodb_buffer_pool_load_incomplete status
111
112 SET GLOBAL innodb_buffer_pool_dump_now=1;
113 # Wait for for the dump to complete
114 let $wait_condition =
115 SELECT SUBSTR(variable_value, 1, 33) = 'Buffer pool(s) dump completed at '
116 FROM information_schema.global_status
117 WHERE LOWER(variable_name) = 'innodb_buffer_pool_dump_status';
118 -- source include/wait_condition.inc
119
120 SELECT variable_name, SUBSTR(variable_value, 1, 33) as VALUE
121 FROM information_schema.global_status
122 WHERE LOWER(variable_name) IN ('innodb_buffer_pool_load_incomplete', 'innodb_buffer_pool_dump_status');
123
124 --let $fulldump=`select count(*) as BLOB_PAGES from information_schema.INNODB_BUFFER_PAGE WHERE PAGE_TYPE='BLOB' group by PAGE_TYPE`
125
126 --echo
127 --echo # Restart server
128 --source include/restart_mysqld.inc
129
130 --echo
131 --echo # Load buffer pool
132 SET GLOBAL innodb_buffer_pool_load_now=1;
133
134 # Wait for for the load to complete
135 let $wait_condition =
136 SELECT SUBSTR(variable_value, 1, 33) = 'Buffer pool(s) load completed at '
137 FROM information_schema.global_status
138 WHERE LOWER(variable_name) = 'innodb_buffer_pool_load_status';
139 -- source include/wait_condition.inc
140
141 --echo
142 --echo # Should be same amount
143 --replace_result $fulldump Previously_dumped
144 --eval select abs($fulldump - count(*)) <= 2 as Loaded_about_same_size from information_schema.INNODB_BUFFER_PAGE WHERE PAGE_TYPE='BLOB' group by PAGE_TYPE;
145
146 --echo
147 --echo # Clean up
148
149 --remove_file $MYSQLTEST_VARDIR/mysqld.1/data/ib_buffer_pool
150 DROP TABLE t1;