Debian Codegraph @

mysql-test/suite/innodb_zip/r/innochecksum_2.result

raw
1 SET GLOBAL innodb_compression_level=0;
2 SELECT @@innodb_compression_level;
3 @@innodb_compression_level
4 0
5 CREATE TABLE t1 (j LONGBLOB) ENGINE = InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;
6 INSERT INTO t1 VALUES (repeat('abcdefghijklmnopqrstuvwxyz',200));
7 INSERT INTO t1 SELECT * from t1;
8 INSERT INTO t1 SELECT * from t1;
9 INSERT INTO t1 SELECT * from t1;
10 INSERT INTO t1 SELECT * from t1;
11 INSERT INTO t1 SELECT * from t1;
12 INSERT INTO t1 SELECT * from t1;
13 INSERT INTO t1 SELECT * from t1;
14 INSERT INTO t1 SELECT * from t1;
15 INSERT INTO t1 SELECT * from t1;
16 INSERT INTO t1 SELECT * from t1;
17 CREATE TABLE t2 (j LONGBLOB) ENGINE = InnoDB
18 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=2;
19 CREATE TABLE t3 (j LONGBLOB) ENGINE = InnoDB
20 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
21 CREATE TABLE t4(c1 INT PRIMARY KEY,c2 VARCHAR(20),
22 INDEX(c2(10))) ENGINE=InnoDB;
23 # stop the server
24
25 Variables (--variable-name=value)
26 and boolean options {FALSE|TRUE} Value (after reading options)
27 --------------------------------- ----------------------------------------
28 verbose TRUE
29 debug FALSE
30 count FALSE
31 start-page 0
32 end-page 0
33 page 0
34 no-check FALSE
35 allow-mismatches 0
36 write FALSE
37 page-type-summary FALSE
38 page-type-dump MYSQLTEST_VARDIR/tmp/dump.txt
39 per-page-details FALSE
40 log (No default value)
41 leaf FALSE
42 merge 0
43 skip-freed-pages FALSE
44 tablespace-flags 4294967295
45 [1]:# check the both short and long options for "help"
46 [2]:# Run the innochecksum when file isn't provided.
47 # It will print the innochecksum usage similar to --help option.
48 innochecksum Ver #.#.#
49 Copyright (c) YEAR, YEAR , Oracle, MariaDB Corporation Ab and others.
50
51 InnoDB offline file checksum utility.
52 Usage: innochecksum [-c] [-r] [-s <start page>] [-e <end page>] [-p <page>] [-i] [-v] [-a <allow mismatches>] [-n] [-S] [-D <page type dump>] [-l <log>] [-l] [-m <merge pages>] <filename or [-]>
53 See https://mariadb.com/kb/en/library/innochecksum/ for usage hints.
54 -?, --help Displays this help and exits.
55 -I, --info Synonym for --help.
56 -V, --version Displays version information and exits.
57 -v, --verbose Verbose (prints progress every 5 seconds).
58 https://mariadb.com/kb/en/library/creating-a-trace-file/
59 -c, --count Print the count of pages in the file and exits.
60 -s, --start-page=# Start on this page number (0 based).
61 -e, --end-page=# End at this page number (0 based).
62 -p, --page=# Check only this page (0 based).
63 -n, --no-check Ignore the checksum verification.
64 -a, --allow-mismatches=#
65 Maximum checksum mismatch allowed.
66 -w, --write Rewrite the checksum.
67 -S, --page-type-summary
68 Display a count of each page type in a tablespace.
69 -D, --page-type-dump=name
70 Dump the page type info for each page in a tablespace.
71 -i, --per-page-details
72 Print out per-page detail information.
73 -l, --log=name log output.
74 -f, --leaf Examine leaf index pages
75 -m, --merge=# leaf page count if merge given number of consecutive
76 pages
77 -r, --skip-freed-pages
78 skip freed pages for the tablespace
79 --tablespace-flags=#
80 InnoDB tablespace flags (default: 4294967295 = read from
81 page 0)
82
83 Variables (--variable-name=value)
84 and boolean options {FALSE|TRUE} Value (after reading options)
85 --------------------------------- ----------------------------------------
86 verbose FALSE
87 count FALSE
88 start-page 0
89 end-page 0
90 page 0
91 no-check FALSE
92 allow-mismatches 0
93 write FALSE
94 page-type-summary FALSE
95 page-type-dump (No default value)
96 per-page-details FALSE
97 log (No default value)
98 leaf FALSE
99 merge 0
100 skip-freed-pages FALSE
101 tablespace-flags 4294967295
102 [3]:# check the both short and long options for "count" and exit
103 Number of pages:#
104 Number of pages:#
105 [4]:# Print the version of innochecksum and exit
106 innochecksum from #.#.#-MariaDB, client #.# for OS (ARCH)
107 [5]:# check t1.ibd and t2.ibd summary with and without tablespace_flags
108 # Restart the DB server
109 DROP TABLE t4, t3, t2, t1;