aria_read_log is a tool for displaying and applying log records from an Aria transaction log.
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 try to compare files before and after recovery.
Usage:
aria_read_log OPTIONS
You need to use one of -d or -a.
The following variables can be set while passed as commandline options to aria_read_log, or set in the [aria_read_log] section in your my.cnf file.
| Option | Description |
|---|---|
| -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 help and exit. |
| -d, --display-only | Display brief info read from records' header. |
| -e, --end-lsn=# | Stop applying at this lsn. If end-lsn is used, UNDO:s will not be 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. |
| -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 comma-separated tables 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) (Defaults to on; use --skip-undo to disable.) |
| -v, --verbose | Print more information during apply/undo phase. |
| -V, --version | Print version and exit. |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/aria_read_log/