mirror of
https://github.com/MariaDB/server.git
synced 2025-02-10 23:45:34 +01:00
9ba18d1aa0
- Innochecksum misinterprets the freed pages as active one. This leads the user to think there are too many valid pages exist. - To avoid this confusion, innochecksum introduced one more option --skip-freed-pages and -r to avoid the freed pages while dumping or printing the summary of the tablespace. - Innochecksum can safely assume the page is freed if the respective extent doesn't belong to a segment and marked as freed in XDES_BITMAP in extent descriptor page. - Innochecksum shouldn't assume that zero-filled page as extent descriptor page. Reviewed-by: Marko Mäkelä
96 lines
4.2 KiB
Text
96 lines
4.2 KiB
Text
SET GLOBAL innodb_compression_level=0;
|
|
SELECT @@innodb_compression_level;
|
|
@@innodb_compression_level
|
|
0
|
|
CREATE TABLE t1 (j LONGBLOB) ENGINE = InnoDB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=1;
|
|
INSERT INTO t1 VALUES (repeat('abcdefghijklmnopqrstuvwxyz',200));
|
|
INSERT INTO t1 SELECT * from t1;
|
|
INSERT INTO t1 SELECT * from t1;
|
|
INSERT INTO t1 SELECT * from t1;
|
|
INSERT INTO t1 SELECT * from t1;
|
|
INSERT INTO t1 SELECT * from t1;
|
|
INSERT INTO t1 SELECT * from t1;
|
|
INSERT INTO t1 SELECT * from t1;
|
|
INSERT INTO t1 SELECT * from t1;
|
|
INSERT INTO t1 SELECT * from t1;
|
|
INSERT INTO t1 SELECT * from t1;
|
|
# stop the server
|
|
|
|
Variables (--variable-name=value)
|
|
and boolean options {FALSE|TRUE} Value (after reading options)
|
|
--------------------------------- ----------------------------------------
|
|
verbose TRUE
|
|
debug FALSE
|
|
count FALSE
|
|
start-page 0
|
|
end-page 0
|
|
page 0
|
|
no-check FALSE
|
|
allow-mismatches 0
|
|
write FALSE
|
|
page-type-summary FALSE
|
|
page-type-dump MYSQLTEST_VARDIR/tmp/dump.txt
|
|
per-page-details FALSE
|
|
log (No default value)
|
|
leaf FALSE
|
|
merge 0
|
|
skip-freed-pages FALSE
|
|
[1]:# check the both short and long options for "help"
|
|
[2]:# Run the innochecksum when file isn't provided.
|
|
# It will print the innochecksum usage similar to --help option.
|
|
innochecksum Ver #.#.#
|
|
Copyright (c) YEAR, YEAR , Oracle, MariaDB Corporation Ab and others.
|
|
|
|
InnoDB offline file checksum utility.
|
|
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 [-]>
|
|
See https://mariadb.com/kb/en/library/innochecksum/ for usage hints.
|
|
-?, --help Displays this help and exits.
|
|
-I, --info Synonym for --help.
|
|
-V, --version Displays version information and exits.
|
|
-v, --verbose Verbose (prints progress every 5 seconds).
|
|
https://mariadb.com/kb/en/library/creating-a-trace-file/
|
|
-c, --count Print the count of pages in the file and exits.
|
|
-s, --start-page=# Start on this page number (0 based).
|
|
-e, --end-page=# End at this page number (0 based).
|
|
-p, --page=# Check only this page (0 based).
|
|
-n, --no-check Ignore the checksum verification.
|
|
-a, --allow-mismatches=#
|
|
Maximum checksum mismatch allowed.
|
|
-w, --write Rewrite the checksum.
|
|
-S, --page-type-summary
|
|
Display a count of each page type in a tablespace.
|
|
-D, --page-type-dump=name
|
|
Dump the page type info for each page in a tablespace.
|
|
-i, --per-page-details
|
|
Print out per-page detail information.
|
|
-l, --log=name log output.
|
|
-f, --leaf Examine leaf index pages
|
|
-m, --merge=# leaf page count if merge given number of consecutive
|
|
pages
|
|
-r, --skip-freed-pages
|
|
skip freed pages for the tablespace
|
|
|
|
Variables (--variable-name=value)
|
|
and boolean options {FALSE|TRUE} Value (after reading options)
|
|
--------------------------------- ----------------------------------------
|
|
verbose FALSE
|
|
count FALSE
|
|
start-page 0
|
|
end-page 0
|
|
page 0
|
|
no-check FALSE
|
|
allow-mismatches 0
|
|
write FALSE
|
|
page-type-summary FALSE
|
|
page-type-dump (No default value)
|
|
per-page-details FALSE
|
|
log (No default value)
|
|
leaf FALSE
|
|
merge 0
|
|
skip-freed-pages FALSE
|
|
[3]:# check the both short and long options for "count" and exit
|
|
Number of pages:#
|
|
Number of pages:#
|
|
[4]:# Print the version of innochecksum and exit
|
|
innochecksum Ver #.#.## Restart the DB server
|
|
DROP TABLE t1;
|