Debian Codegraph @

mysql-test/suite/large_tests/r/innodb_innochecksum_3gb.result

raw
1 DROP TABLE IF EXISTS tab2;
2 SHOW variables like '%innodb_checksum_algorithm%';
3 Variable_name Value
4 innodb_checksum_algorithm crc32
5 SELECT @@default_storage_engine;
6 @@default_storage_engine
7 InnoDB
8 CREATE TABLE tab2(col_1 CHAR (255) ,
9 col_2 VARCHAR (255), col_3 longtext,
10 col_4 longtext,col_5 BLOB,
11 col_6 LONGBLOB , col_7 bigint)
12 engine = innodb ;
13 CREATE INDEX idx1 ON tab2(col_3(10));
14 CREATE INDEX idx2 ON tab2(col_4(10));
15 CREATE INDEX idx3 ON tab2(col_5(10));
16 # Generate a input text file for loading the table
17 # check whether file exist
18 # load the data into the table
19 SELECT COUNT(*) FROM tab2;
20 COUNT(*)
21 7014000
22 # Stop the server
23 # Rewrite the tab2.ibd file into new checksum=CRC32
24 # Restart the DB server with default innodb_checksum_algorithm=InnoDB (Default)
25 # no need to pass to the server.
26 # Load the with repeat function
27 SET @col_1 = repeat('A', 5);
28 SET @col_2 = repeat('B', 20);
29 SET @col_3 = repeat('D', 100);
30 SET @col_4 = repeat('E', 100);
31 SET @col_5 = repeat('F', 100);
32 SET @col_6 = repeat('G', 100);
33 # Check the table status with DML
34 INSERT INTO tab2(col_1,col_2,col_3,col_4,col_5,col_6,col_7)
35 VALUES (@col_1,@col_2,@col_3,@col_4,@cl_5,@col_6,1000);
36 # Check with Read operation by record count
37 SELECT COUNT(*) FROM tab2 where col_7=1000;
38 COUNT(*)
39 1
40 # Stop the server
41 # Rewrite the tab2.ibd file into new checksum=None
42 # Check the page type summary with longform for *.ibd
43
44 File::tab#.ibd
45 ================PAGE TYPE SUMMARY==============
46 #PAGE_COUNT PAGE_TYPE
47 ===============================================
48 # Index page
49 # SDI Index page
50 # Undo log page
51 # Inode page
52 # Insert buffer free list page
53 # Freshly allocated page
54 # Insert buffer bitmap
55 # System page
56 # Transaction system page
57 # File Space Header
58 # Extent descriptor page
59 # BLOB page
60 # Compressed BLOB page
61 # Subsequent Compressed BLOB page
62 # SDI BLOB page
63 # Compressed SDI BLOB page
64 # Other type of page
65 ===============================================
66 Additional information:
67 Undo page type: # insert, # update, # other
68 Undo page state: # active, # cached, # to_free, # to_purge, # prepared, # other
69 # Page type dump for tab2.ibd
70 # check whether dump.txt file exist
71 # Restart the DB server with default innodb_checksum_algorithm=CRC32
72 SHOW variables like '%innodb_checksum_algorithm%';
73 Variable_name Value
74 innodb_checksum_algorithm crc32
75 # Check the default engine is always InnoDB after restart
76 SELECT @@default_storage_engine;
77 @@default_storage_engine
78 InnoDB
79 # Load the with repeat function
80 SET @col_1 = repeat('G', 5);
81 SET @col_2 = repeat('H', 20);
82 SET @col_3 = repeat('I', 100);
83 SET @col_4 = repeat('J', 100);
84 SET @col_5 = repeat('K', 100);
85 SET @col_6 = repeat('L', 100);
86 # Check the table status with DML
87 INSERT INTO tab2(col_1,col_2,col_3,col_4,col_5,col_6,col_7)
88 VALUES (@col_1,@col_2,@col_3,@col_4,@cl_5,@col_6,2000);
89 # Check with Read operation that record count
90 SELECT COUNT(*) FROM tab2 where col_7=2000;
91 COUNT(*)
92 1
93 DROP TABLE IF EXISTS tab2;