1ARIA_CHK(1)                      User Commands                     ARIA_CHK(1)
2
3
4

NAME

6       aria_chk - Aria table-maintenance utility
7

SYNOPSIS

9       aria_chk [OPTIONS] tables[.MAI]
10

DESCRIPTION

12       Describe,  check  and  repair of Aria tables.  Used without options all
13       tables on the command will be checked for errors
14
15   Global options
16       -#, --debug=...
17              Output debug log. Often this is 'd:t:o,filename'.
18
19       -H, --HELP
20              Print all argument options sorted alphabetically.
21
22       -?, --help
23              Print all options by groups
24
25       --datadir=path
26              Path for control file (and logs if --logdir not used)
27
28       --logdir=path
29              Path for log files
30
31       --ignore-control-file
32              Don't open the control file. Only use this if you are  sure  the
33              tables are not in use by another program!
34
35       --require-control-file
36              Abort if we can't find/read the maria_log_control file
37
38       -s, --silent
39              Only  print  errors.   One can use two -s to make maria_chk very
40              silent.
41
42       -t, --tmpdir=path
43              Path for temporary files. Multiple paths can be specified, sepa‐
44              rated by colon (:), they will be used in a round-robin fashion.
45
46       -v, --verbose
47              Print  more information. This can be used with --description and
48              --check. Use many -v for more verbosity.
49
50       -V, --version
51              Print version and exit.
52
53       -w, --wait
54              Wait if table is locked.
55
56   Check options (check is the default action for aria_chk)
57       -c, --check
58              Check table for errors.
59
60       -e, --extend-check
61              Check the table VERY throughly.  Only use this in extreme  cases
62              as  aria_chk should normally be able to find out if the table is
63              ok even without this switch.
64
65       -F, --fast
66              Check only tables that haven't been closed properly.
67
68       -C, --check-only-changed
69              Check only tables that have changed since last check.
70
71       -f, --force
72              Restart with '-r' if there are any errors in the table.   States
73              will be updated as with '--update-state'.
74
75       -i, --information
76              Print statistics information about table that is checked.
77
78       -m, --medium-check
79              Faster  than  extend-check, but only finds 99.99% of all errors.
80              Should be good enough for most cases.
81
82       -T, --read-only
83              Don't mark table as checked.
84
85       -U, --update-state
86              Mark tables as crashed if any errors were  found  and  clean  if
87              check didn't find any errors but table was marked as 'not clean'
88              before. This allows one to get rid of warnings like  'table  not
89              properly  closed'.  If  table was updated, update also the time‐
90              stamp for when the check was made. This option is on by default!
91              Use --skip-update-state to disable.
92
93       --warning-for-wrong-transaction-id
94
95              Give  a warning if we find a transaction id in the table that is
96              bigger than what exists in the control file. Use  --skip-...  to
97              disable warning
98
99   Recover (repair)/ options (When using '--recover' or '--safe-recover')
100       -B, --backup
101              Make a backup of the .MAD file as 'filename-time.BAK'.
102
103       --correct-checksum
104              Correct checksum information for table.
105
106       -D, --data-file-length=#
107              Max  length  of  data  file (when recreating data file when it's
108              full).
109
110       -e, --extend-check
111              Try to recover every possible row from the  data  file  Normally
112              this will also find a lot of garbage rows; Don't use this option
113              if you are not totally desperate.
114
115       -f, --force
116              Overwrite old temporary files.
117
118       -k, --keys-used=#
119              Tell Aria to update only some specific keys. # is a bit mask  of
120              which keys to use. This can be used to get faster inserts.
121
122       --max-record-length=#
123              Skip  rows bigger than this if aria_chk can't allocate memory to
124              hold it.
125
126       -r, --recover
127              Can fix almost anything except unique keys that aren't unique.
128
129       -n, --sort-recover
130              Forces recovering with sorting even if the temporary file  would
131              be very big.
132
133       -p, --parallel-recover
134              Uses  the  same  technique as '-r' and '-n', but creates all the
135              keys in parallel, in different threads.
136
137       -o, --safe-recover
138              Uses old recovery method; Slower than '-r' but can handle a cou‐
139              ple of cases where '-r' reports that it can't fix the data file.
140
141       --transaction-log
142              Log  repair  command  to  transaction log. This is needed if one
143              wants to use the aria_read_log to repeat the repair
144
145       --character-sets-dir=...
146              Directory where character sets are.
147
148       --set-collation=name
149              Change the collation used by the index.
150
151       -q, --quick
152              Faster repair by not modifying the data file.  One  can  give  a
153              second '-q' to force aria_chk to modify the original datafile in
154              case of duplicate keys.  NOTE: Tables where  the  data  file  is
155              currupted can't be fixed with this option.
156
157       -u, --unpack
158              Unpack file packed with ariapack.
159
160   Other actions
161       -a, --analyze
162              Analyze  distribution  of  keys. Will make some joins in MariaDB
163              faster.  You can check  the  calculated  distribution  by  using
164              '--description --verbose table_name'.
165
166       --stats_method=name
167              Specifies  how  index  statistics  collection  code should treat
168              NULLs. Possible values of name are "nulls_unequal" (default  for
169              4.1/5.0), "nulls_equal" (emulate 4.0), and "nulls_ignored".
170
171       -d, --description
172              Prints some information about table.
173
174       -A, --set-auto-increment[=value]
175              Force  auto_increment  to  start  at  this or higher value If no
176              value is given, then sets the next auto_increment value  to  the
177              highest used value for the auto key + 1.
178
179       -S, --sort-index
180              Sort index blocks.  This speeds up 'read-next' in applications.
181
182       -R, --sort-records=#
183              Sort  records  according to an index.  This makes your data much
184              more localized and may speed up things (It may be VERY  slow  to
185              do a sort the first time!).
186
187       -b,  --block-search=#
188              Find a record, a block at given offset belongs to.
189
190       -z,  --zerofill
191              Fill  empty  space  in  data  and index files with zeroes.  This
192              makes the data file movable between different servers.
193
194       --zerofill-keep-lsn
195              Like --zerofill but does not zero out LSN of data/index pages.
196
197   Variables
198       --page_buffer_size=#
199              Size of page buffer. Used by --safe-repair
200
201       --read_buffer_size=#
202              Read buffer size for sequential reads during scanning
203
204       --sort_buffer_size=#
205              Size of sort buffer. Used by --recover
206
207       --sort_key_blocks=#
208              Internal buffer for sorting keys; Don't touch.
209
210       --write_buffer_size=#
211              Write buffer size for sequential writes during repair
212
213       Default options are read from the following files in the  given  order:
214       /etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf
215
216       The following groups are read: aria_chk
217
218       The following options may be given as the first argument:
219
220       --print-defaults
221              Print the program argument list and exit.
222
223       --no-defaults
224              Don't read default options from any option file.
225
226       --defaults-file=#
227              Only read default options from the given file #.
228
229       --defaults-extra-file=#
230              Read this file after the global files are read.
231

SEE ALSO

233       myisamchk(1)
234
235       For more information, please refer to the MariaDB Knowledge Base, which
236       is available online at http://mariadb.com/kb/
237
238
239
240aria_chk Ver 1.2                   May 2014                        ARIA_CHK(1)
Impressum