-a, --analyze Analyze distribution of keys. Will make some joins in MySQL faster. You can check the calculated distribution. -b, --block-search=# No help available. -B, --backup Make a backup of the .MAD file as 'filename-time.BAK'. --character-sets-dir=name Directory where character sets are. -c, --check Check table for errors. -C, --check-only-changed Check only tables that have changed since last check. It also applies to other requested actions (e.g. --analyze will be ignored if the table is already analyzed). --correct-checksum Correct checksum information for table. --create-missing-keys Create missing keys. This assumes that the data file is correct and that the the number of rows stored in the index file is correct. Enables --quick -d, --description Prints some information about table. -D, --data-file-length=# Max length of data file (when recreating data-file when it's full). -e, --extend-check If used when checking a table, ensure that the table is 100 percent consistent, which will take a long time. If used when repairing a table, try to recover every possible row from the data file. Normally this will also find a lot of garbage rows; Don't use this option with repair if you are not totally desperate. -F, --fast Check only tables that haven't been closed properly. It also applies to other requested actions (e.g. --analyze will be ignored if the table is already analyzed). -f, --force Restart with -r if there are any errors in the table. States will be updated as with --update-state. -H, --HELP Print all argument options sorted alphabetically and exit. -?, --help Print all options by groups and exit. See also --HELP -i, --information Print statistics information about table that is checked. --ignore-control-file Ignore the control file -k, --keys-used=# Tell Aria to update only some specific keys. # is a bit mask of which keys to use. This can be used to get faster inserts. -h, --datadir=name Path for control file (and logs if --logdir not used). --logdir=name Path for log files. --max-record-length=# Skip rows bigger than this if aria_chk can't allocate memory to hold it -m, --medium-check Faster than extend-check, but only finds 99.99% of all errors. Should be good enough for most cases. -q, --quick Faster repair by not modifying the data file. -T, --read-only Don't mark table as checked. -r, --recover Can fix almost anything except unique keys that aren't unique. -p, --parallel-recover Same as '-r' but creates all the keys in parallel. -o, --safe-recover Uses old recovery method; Slower than '-r' but can handle a couple of cases where '-r' reports that it can't fix the data file. -n, --sort-recover Force recovering with sorting even if the temporary file was very big. --require-control-file Abort if cannot find control file -A, --set-auto-increment[=#] Force auto_increment to start at this or higher value. If no value is given, then sets the next auto_increment value to the highest used value for the auto key + 1. --set-collation=name Change the collation used by the index -s, --silent Only print errors. One can use two -s to make aria_chk very silent. -S, --sort-index Sort index blocks. This speeds up 'read-next' in applications. -R, --sort-records=# Sort records according to an index. This makes your data much more localized and may speed up things. (It may be VERY slow to do a sort the first time!) -t, --tmpdir=name Path for temporary files. --transaction-log Log repair command to transaction log -U, --update-state Mark tables as crashed if any errors were found and clean if check didn't find any errors but table was marked as 'not clean' before. This allows one to get rid of warnings like 'table not properly closed'. If table was updated, update also the timestamp for when check was made. This option is on by default! (Defaults to on; use --skip-update-state to disable.) -u, --unpack Unpack file packed with aria_pack. -v, --verbose Print more information. This can be used with --description and --check. Use many -v for more verbosity! -V, --version Print version and exit. -w, --wait Wait if table is locked. --warning-for-wrong-transaction-id Give a warning if we find a transaction id in the table that is biggerthan what exists in the control file. Use --skip-... to disable warning (Defaults to on; use --skip-warning-for-wrong-transaction-id to disable.) --page-buffer-size=# Size of page buffer. Used by --safe-repair --read-buffer-size=# Read buffer size for sequential reads during scanning --write-buffer-size=# Write buffer size for sequential writes during repair of fixed size or dynamic size rows --sort-buffer-size=# Size of sort buffer. Used by --recover --sort-key-blocks=# Internal buffer for sorting keys; Don't touch :) --decode-bits=# --ft-min-word-len=# --ft-max-word-len=# --aria-ft-stopword-file=name Use stopwords from this file instead of built-in list. --stats-method=name Specifies how index statistics collection code should treat NULLs. Possible values of name are "nulls_unequal" (default behavior for 4.1/5.0), "nulls_equal" (emulate 4.0 behavior), and "nulls_ignored". -z, --zerofill Fill empty space in data and index files with zeroes. This makes the data file movable between different servers. It also fixes any wrong transaction or LSN numbers in the table after a crash or if someone removed the Aria log files. --zerofill-keep-lsn Like --zerofill but does not zero out LSN of data/index pages; used only for testing and debugging Variables (--variable-name=value) and boolean options {FALSE|TRUE} Value (after reading options) --------------------------------- ---------------------------------------- character-sets-dir (No default value) data-file-length 0 ignore-control-file FALSE keys-used 18446744073709551615 datadir . logdir . max-record-length 9223372036854775807 require-control-file FALSE set-auto-increment 0 set-collation (No default value) sort-records 0 tmpdir (No default value) transaction-log FALSE update-state TRUE warning-for-wrong-transaction-id TRUE page-buffer-size 268427264 read-buffer-size 261120 write-buffer-size 261120 sort-buffer-size 268434432 sort-key-blocks 16 decode-bits 9 ft-min-word-len 4 ft-max-word-len 84 aria-ft-stopword-file (No default value) stats-method nulls_unequal