|
1.1.4
by Otto Kekäläinen
Import upstream version 5.5.38 |
1 |
.TH ARIA_READ_LOG "1" "May 2014" "aria_read_log Ver 1.3" "User Commands" |
2 |
.SH NAME |
|
3 |
aria_read_log \- display Aria log file contents
|
|
4 |
.SH SYNOPSIS |
|
5 |
.B aria_read_log |
|
6 |
\fIOPTIONS\fR |
|
7 |
.SH DESCRIPTION |
|
8 |
Display and apply log records from a Aria transaction log |
|
9 |
found in the current directory (for now) |
|
10 |
.PP
|
|
11 |
Note: Aria is compiled without \fB\-DIDENTICAL_PAGES_AFTER_RECOVERY\fR |
|
12 |
which means that the table files are not byte\-to\-byte identical to |
|
13 |
files created during normal execution. This should be ok, except for |
|
14 |
test scripts that tries to compare files before and after recovery. |
|
15 |
.PP
|
|
16 |
You need to use one of \fB\-d\fR or \fB\-a\fR |
|
17 |
.TP
|
|
18 |
\fB\-a\fR, \fB\-\-apply\fR |
|
19 |
Apply log to tables: modifies tables! you should make a |
|
20 |
backup first! Displays a lot of information if not run |
|
21 |
with \fB\-\-silent\fR |
|
22 |
.TP
|
|
23 |
\fB\-\-character\-sets\-dir\fR=\fIname\fR |
|
24 |
Directory where character sets are. |
|
25 |
.TP
|
|
26 |
\fB\-c\fR, \fB\-\-check\fR |
|
27 |
if \fB\-\-display\-only\fR, check if record is fully readable (for |
|
28 |
debugging) |
|
29 |
.TP
|
|
30 |
\fB\-#\fR, \fB\-\-debug\fR[=\fIname\fR] |
|
31 |
Output debug log. Often the argument is 'd:t:o,filename'. |
|
32 |
.TP
|
|
33 |
\fB\-\-force\-crash=\fR# |
|
34 |
Force crash after # recovery events |
|
35 |
.TP
|
|
36 |
\fB\-?\fR, \fB\-\-help\fR |
|
37 |
Display this help and exit. |
|
38 |
.TP
|
|
39 |
\fB\-d\fR, \fB\-\-display\-only\fR |
|
40 |
display brief info read from records' header |
|
41 |
.TP
|
|
42 |
\fB\-e\fR, \fB\-\-end\-lsn=\fR# |
|
43 |
Stop applying at this lsn. If end\-lsn is used, UNDO:s
|
|
44 |
will not be applied |
|
45 |
.TP
|
|
46 |
\fB\-h\fR, \fB\-\-aria\-log\-dir\-path\fR=\fIname\fR |
|
47 |
Path to the directory where to store transactional log |
|
48 |
.TP
|
|
49 |
\fB\-P\fR, \fB\-\-page\-buffer\-size=\fR# |
|
50 |
The size of the buffer used for index blocks for Aria |
|
51 |
tables |
|
52 |
.TP
|
|
53 |
\fB\-o\fR, \fB\-\-start\-from\-lsn=\fR# |
|
54 |
Start reading log from this lsn |
|
55 |
.TP
|
|
56 |
\fB\-C\fR, \fB\-\-start\-from\-checkpoint\fR |
|
57 |
Start applying from last checkpoint |
|
58 |
.TP
|
|
59 |
\fB\-s\fR, \fB\-\-silent\fR |
|
60 |
Print less information during apply/undo phase |
|
61 |
.TP
|
|
62 |
\fB\-T\fR, \fB\-\-tables\-to\-redo\fR=\fIname\fR |
|
63 |
List of tables sepearated with , that we should apply |
|
64 |
REDO on. Use this if you only want to recover some tables |
|
65 |
.TP
|
|
66 |
\fB\-t\fR, \fB\-\-tmpdir\fR=\fIname\fR |
|
67 |
Path for temporary files. Multiple paths can be |
|
68 |
specified, separated by colon (:) |
|
69 |
.TP
|
|
70 |
\fB\-\-translog\-buffer\-size=\fR# |
|
71 |
The size of the buffer used for transaction log for Aria |
|
72 |
tables |
|
73 |
.TP
|
|
74 |
\fB\-u\fR, \fB\-\-undo\fR |
|
75 |
Apply UNDO records to tables. (disable with |
|
76 |
\fB\-\-disable\-undo\fR) |
|
77 |
(Defaults to on; use \fB\-\-skip\-undo\fR to disable.) |
|
78 |
.TP
|
|
79 |
\fB\-v\fR, \fB\-\-verbose\fR |
|
80 |
Print more information during apply/undo phase |
|
81 |
.TP
|
|
82 |
\fB\-V\fR, \fB\-\-version\fR |
|
83 |
Print version and exit. |
|
84 |
.PP
|
|
85 |
Default options are read from the following files in the given order: |
|
86 |
\fB/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf\fR |
|
87 |
.PP
|
|
88 |
The following groups are read: \fBaria_read_log\fR |
|
89 |
.PP
|
|
90 |
The following options may be given as the first argument: |
|
91 |
.TP
|
|
92 |
\fB\-\-print\-defaults\fR |
|
93 |
Print the program argument list and exit. |
|
94 |
.TP
|
|
95 |
\fB\-\-no\-defaults\fR |
|
96 |
Don't read default options from any option file. |
|
97 |
.TP
|
|
98 |
\fB\-\-defaults\-file=\fR# |
|
99 |
Only read default options from the given file #. |
|
100 |
.TP
|
|
101 |
\fB\-\-defaults\-extra\-file=\fR# |
|
102 |
Read this file after the global files are read. |
|
103 |
.PP
|
|
104 |
.SH "SEE ALSO" |
|
105 |
\fBmyisamlog(1)\fR |
|
106 |
.PP
|
|
107 |
For more information, please refer to the MariaDB Knowledge Base, |
|
108 |
which is available online at http://mariadb.com/kb/ |