| 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; |