Debian Codegraph @

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

raw
1 # Set the environmental variables
2 # Create a table
3 CREATE TABLE tab5 (col1 int auto_increment primary key,
4 col2 VARCHAR(25), col3 varchar(25)) ENGINE=InnoDB;
5 # Create indexes
6 CREATE INDEX idx1 ON tab5(col2(10));
7 CREATE INDEX idx2 ON tab5(col3(10));
8 # Insert a sample record
9 INSERT INTO tab5(col2,col3) VALUES('Test for wl6504','Test for dump pct');
10 # Set the dump file name
11 SET GLOBAL innodb_buffer_pool_filename=ib_buffer_pool100;
12 SET GLOBAL innodb_buffer_pool_dump_pct=100;
13 SELECT variable_value INTO @IBPDS
14 FROM performance_schema.global_status
15 WHERE variable_name = 'INNODB_BUFFER_POOL_DUMP_STATUS';
16 # Take the dump file
17 SET GLOBAL innodb_buffer_pool_dump_now=ON;
18 # Wait until the system table get updated & dump get created
19 # Check the dump file exist in the DATADIR
20 # Set the dump file name
21 SET GLOBAL innodb_buffer_pool_filename=ib_buffer_pool50;
22 # Set the value 50
23 SET GLOBAL innodb_buffer_pool_dump_pct=50;
24 # Check the value is 50
25 SELECT @@global.innodb_buffer_pool_dump_pct;
26 @@global.innodb_buffer_pool_dump_pct
27 50
28 SELECT variable_value INTO @IBPDS
29 FROM performance_schema.global_status
30 WHERE variable_name = 'INNODB_BUFFER_POOL_DUMP_STATUS';
31 # Take the dump file
32 SET GLOBAL innodb_buffer_pool_dump_now=ON;
33 # Wait until the system table get updated & dump get created
34 # Check the dump file exist in the DATADIR
35 # Get the size of the dump files & compare
36 wl6504 test PASS
37 # Reset the default value
38 SET GLOBAL innodb_buffer_pool_dump_pct=Default;
39 SET GLOBAL innodb_buffer_pool_filename=Default;
40 # Cleanup
41 DROP TABLE tab5;