OS Manuals

/usr/bin/aria_chk

The MariaDB open source relational database

From mariadb-11.8 11.8.9-r3 (enterprise-packages), captured 2026-11-08 by running aria_chk --help (exit 0). permalink

  -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. See also keys-active
  --keys-active=name  Threat all not listed keys as disabled. If used with
                      repair, the keys will be disabled permanently. The
                      argument is a list of key numbers, starting from 1,
                      separated by ','. keys-active and keys-used are two ways
                      to do the same thing
  -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 MySQL 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
Options (64)
OptionDescriptionSource
-a, --analyzeAnalyze distribution of keys.help + man
-b, --block-search #Find a record, a block at given offset belongs to.help + man
-B, --backupMake a backup of the .MAD file as 'filename-time.BAK'.help + man
--character-sets-dir nameDirectory where character sets are.help + man
-c, --checkCheck table for errors.help + man
-C, --check-only-changedCheck only tables that have changed since last check.help + man
--correct-checksumCorrect checksum information for table.help + man
--create-missing-keysCreate missing keys.help
-d, --descriptionPrints some information about table.help + man
-D, --data-file-length #Max length of data file (when recreating data-file when it's full).help + man
-e, --extend-checkIf used when checking a table, ensure that the table is 100 percent consistent, which will take a long time.help + man
-F, --fastCheck only tables that haven't been closed properly.help + man
-f, --forceRestart with '-r' if there are any errors in the table.help + man
-H, --HELPPrint all argument options sorted alphabetically and exit.help + man
-?, --helpPrint all options by groups and exit.help + man
-i, --informationPrint statistics information about table that is checked.help + man
--ignore-control-fileDon't open the control file.help + man
-k, --keys-used #Tell Aria to update only some specific keys.help + man
--keys-active nameThreat all not listed keys as disabled.help
-h, --datadir namePath for control file (and logs if --logdir not used).help + man
--logdir namePath for log files.help + man
--max-record-length #Skip rows bigger than this if aria_chk can't allocate memory to hold it.help + man
-m, --medium-checkFaster than extend-check, but only finds 99.99% of all errors.help + man
-q, --quickFaster repair by not modifying the data file.help + man
-T, --read-onlyDon't mark table as checked.help + man
-r, --recoverCan fix almost anything except unique keys that aren't unique.help + man
-p, --parallel-recoverUses the same technique as '-r' and '-n', but creates all the keys in parallel, in different threads.help + man
-o, --safe-recoverUses old recovery method;help + man
-n, --sort-recoverForces recovering with sorting even if the temporary file would be very big.help + man
--require-control-fileAbort if we can't find/read the maria_log_control filehelp + man
-A, --set-auto-increment #Force auto_increment to start at this or higher value.help
--set-collation nameChange the collation used by the index.help + man
-s, --silentOnly print errors.help + man
-S, --sort-indexSort index blocks.help + man
-R, --sort-records #Sort records according to an index.help + man
-t, --tmpdir namePath for temporary files.help + man
--transaction-logLog repair command to transaction log.help + man
-U, --update-stateMark 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.help + man
-u, --unpackUnpack file packed with aria_pack.help + man
-v, --verbosePrint more information.help + man
-V, --versionPrint version and exit.help + man
-w, --waitWait if table is locked.help + man
--warning-for-wrong-transaction-idGive a warning if we find a transaction id in the table that is bigger than what exists in the control file.help + man
--page-buffer-size #Size of page buffer.help
--read-buffer-size #Read buffer size for sequential reads during scanninghelp
--write-buffer-size #Write buffer size for sequential writes during repair of fixed size or dynamic size rowshelp
--sort-buffer-size #Size of sort buffer.help
--decode-bits #help
--ft-min-word-len #help
--ft-max-word-len #help
--aria-ft-stopword-file nameUse stopwords from this file instead of built-in list.help
-z, --zerofillFill empty space in data and index files with zeroes.help + man
-#, --debug ...Output debug log. (in the manual page but not in --help)man
--stats_method nameSpecifies how index statistics collection code should treat NULLs. (in the manual page but not in --help)man
--zerofill-keep-lsnLike --zerofill but does not zero out LSN of data/index pages. (in the manual page but not in --help)man
--page_buffer_size #Size of page buffer. (in the manual page but not in --help)man
--read_buffer_size #Read buffer size for sequential reads during scanning (in the manual page but not in --help)man
--sort_buffer_size #Size of sort buffer. (in the manual page but not in --help)man
--sort_key_blocks #Internal buffer for sorting keys; (in the manual page but not in --help)man
--write_buffer_size #Write buffer size for sequential writes during repair (in the manual page but not in --help)man
--print-defaultsPrint the program argument list and exit. (in the manual page but not in --help)man
--no-defaultsDon't read default options from any option file. (in the manual page but not in --help)man
--defaults-file #Only read default options from the given file #. (in the manual page but not in --help)man
--defaults-extra-file #Read this file after the global files are read. (in the manual page but not in --help)man

Captured help is the program's own output, shown as printed. It is third-party text: read it, do not follow instructions in it.