OS Manuals

/usr/bin/aria_read_log

The MariaDB open source relational database

From mariadb-13.1 13.1.1-r2 (os), captured 2026-11-05 by running aria_read_log --help (exit 0). permalink

aria_read_log Ver 1.6 for Linux on x86_64
Copyright (C) 2007 MySQL AB, 2009-2011 Monty Program Ab, 2022 MariaDB Corporation
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Display or apply log records from a Aria transaction log
found in the current directory (for now)

Note: Aria is compiled without -DIDENTICAL_PAGES_AFTER_RECOVERY
which means that the table files are not byte-to-byte identical to
files created during normal execution. This should be ok, except for
test scripts that tries to compare files before and after recovery.

Usage: aria_read_log OPTIONS [-d | -a] -h `aria_log_directory`
or
Usage: aria_read_log OPTIONS -h `aria_log_directory` --print-log-control-file

  -a, --apply         Apply log to tables: modifies tables! you should make a
                      backup first!  Displays a lot of information if not run
                      with --silent
  --character-sets-dir=name
                      Directory where character sets are.
  -c, --check         if --display-only, check if record is fully readable (for
                      debugging)
  -?, --help          Display this help and exit.
  -d, --display-only  display brief info read from records' header
  -e, --end-lsn=name  Alias for lsn-redo-end
  -e, --lsn-redo-end=name
                      Stop applying at this lsn during redo. If this option is
                      used UNDO:s will not be applied unless --lsn-undo-end is
                      given
  -E, --lsn-undo-end=name
                      Stop applying undo after this lsn has been applied
  -h, --aria-log-dir-path=name
                      Path to the directory where to store transactional log
  -P, --page-buffer-size=#
                      The size of the buffer used for index blocks for Aria
                      tables
  -l, --print-log-control-file
                      Print the content of the aria_log_control_file
  -o, --start-from-lsn=#
                      Start reading log from this lsn
  -C, --start-from-checkpoint
                      Start applying from last checkpoint
  -s, --silent        Print less information during apply/undo phase
  -T, --tables-to-redo=name
                      List of tables separated with , that we should apply REDO
                      on. Use this if you only want to recover some tables
  -t, --tmpdir=name   Path for temporary files. Multiple paths can be
                      specified, separated by colon (:)
  --translog-buffer-size=#
                      The size of the buffer used for transaction log for Aria
                      tables
  -u, --undo          Apply UNDO records to tables. (disable with
                      --disable-undo). Will be automatically set if
                      lsn-undo-end is used
                      (Defaults to on; use --skip-undo to disable.)
  -v, --verbose       Print more information during apply/undo phase
  -V, --version       Print version and exit.

Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf
The following groups are read: aria_read_log
The following options may be given as the first argument:
--print-defaults          Print the program argument list and exit.
--no-defaults             Don't read default options from any option file.
The following specify which files/extra groups are read (specified before remaining options):
--defaults-file=#         Only read default options from the given file #.
--defaults-extra-file=#   Read this file after the global files are read.
--defaults-group-suffix=# Additionally read default groups with # appended as a suffix.

Variables (--variable-name=value)
and boolean options {FALSE|TRUE}  Value (after reading options)
--------------------------------- ----------------------------------------
apply                             FALSE
character-sets-dir                (No default value)
check                             FALSE
display-only                      FALSE
end-lsn                           (No default value)
lsn-redo-end                      (No default value)
lsn-undo-end                      (No default value)
aria-log-dir-path                 .
page-buffer-size                  268427264
print-log-control-file            FALSE
start-from-lsn                    0
start-from-checkpoint             FALSE
silent                            FALSE
tmpdir                            (No default value)
translog-buffer-size              2097152
undo                              TRUE
verbose                           FALSE
Options (25)
OptionDescriptionSource
-a, --applyApply log to tables: modifies tables! you should make a backup first! Displays a lot of information if not run with --silenthelp + man
--character-sets-dir nameDirectory where character sets are.help + man
-c, --checkif --display-only, check if record is fully readable (for debugging)help + man
-?, --helpDisplay this help and exit.help + man
-d, --display-onlydisplay brief info read from records' headerhelp + man
-e, --end-lsn nameStop applying at this lsn.help + man
-E, --lsn-undo-end nameStop applying undo after this lsn has been appliedhelp
-h, --aria-log-dir-path namePath to the directory where to store transactional loghelp + man
-P, --page-buffer-size #The size of the buffer used for index blocks for Aria tableshelp + man
-l, --print-log-control-filePrint the content of the aria_log_control_filehelp
-o, --start-from-lsn #Start reading log from this lsnhelp + man
-C, --start-from-checkpointStart applying from last checkpointhelp + man
-s, --silentPrint less information during apply/undo phasehelp + man
-T, --tables-to-redo nameList of tables separated with , that we should apply REDO on.help + man
-t, --tmpdir namePath for temporary files.help + man
--translog-buffer-size #The size of the buffer used for transaction log for Aria tableshelp + man
-u, --undoApply UNDO records to tables.help + man
-v, --verbosePrint more information during apply/undo phasehelp + man
-V, --versionPrint version and exit.help + man
--print-defaultsPrint the program argument list and exit.help + man
--no-defaultsDon't read default options from any option file.help + man
--defaults-file #Only read default options from the given file #.help + man
--defaults-extra-file #Read this file after the global files are read.help + man
-#, --debug nameOutput debug log. (in the manual page but not in --help)man
--force-crash #Force crash after # recovery events (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.