ARIA_READ_LOG(1)

💖 ARIA_READ_LOG(1) 💖

okay bestie, welcome to the User Commands section of the manual, and today's main character is aria_read_log — she displays Aria log file contents and she is, frankly, iconic for it ✨

🌸 NAME 🌸

aria_read_log — display Aria log file contents 💅

✨ SYNOPSIS ✨

aria_read_log OPTIONS

🦋 DESCRIPTION 🦋

So basically: this girl displays and applies log records from an Aria transaction log that she finds in the current directory (for now — yes, that "for now" is doing a lot of heavy lifting, we love an honest queen 🫶).

note note note: Aria is compiled without -DIDENTICAL_PAGES_AFTER_RECOVERY, which means the table files are not byte-to-byte identical to files created during normal execution. That's fine, should be okay — except for test scripts that try to compare files before and after recovery. those scripts are lowkey gonna have a bad time 😭

Also, you literally need to use one of -d or -a. no cap. one of them. periodt.

• -a, --apply — Apply log to tables: modifies tables! you should make a backup first! seriously bestie, back it up 🙈 She also displays a lot of information if you don't run her with --silent.
• --character-sets-dir=name — Directory where character sets are. that's it, that's the whole vibe 💜
• -c, --check — if --display-only is on, check if the record is fully readable (this one's for debugging, she's a little nosy and we respect it)
• -#, --debug[=name] — Output debug log. Often the argument is 'd:t:o,filename'. slay, very specific, very demure ✨
• --force-crash=# — Force crash after # recovery events. yes. she will simply pass away on purpose. on schedule. as requested 💀
• -?, --help — Display this help and exit. the classic. the beloved. 🎀
• -d, --display-only — display brief info read from records' header. just a lil peek, no touching 👀
• -e, --end-lsn=# — Stop applying at this lsn. and heads up: if end-lsn is used, UNDO:s will not be applied. she said no more, we stop, we don't undo 💅
• -h, --aria-log-dir-path=name — Path to the directory where to store transactional log. the log's little home 🏠
• -P, --page-buffer-size=# — The size of the buffer used for index blocks for Aria tables. buffers gotta buffer 💖
• -o, --start-from-lsn=# — Start reading log from this lsn. pick your starting point, main character energy ✨
• -C, --start-from-checkpoint — Start applying from last checkpoint. we love a checkpoint. it's giving "save your game" 🎮
• -s, --silent — Print less information during apply/undo phase. she's quiet, she's mysterious, she's working 🧚
• -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. picky eater behaviour and honestly? valid 🍓
• -t, --tmpdir=name — Path for temporary files. Multiple paths can be specified, separated by colon (:). the more the merrier, she'll take them all 🌈
• --translog-buffer-size=# — The size of the buffer used for transaction log for Aria tables. another buffer, another slay 💜
• -u, --undo — Apply UNDO records to tables. (disable with --disable-undo) (Defaults to on; use --skip-undo to disable.) so she's on by default, bestie, she woke up and chose UNDO 🔥
• -v, --verbose — Print more information during apply/undo phase. the opposite of silent. she will yap and you WILL listen 👑
• -V, --version — Print version and exit. quick lil flex, then she's gone 💅

🎀 Default options, bestie 🎀

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 "put me first" options ⭐

The following options may be given as the first argument:

• --print-defaults — Print the program argument list and exit. show me the receipts 📜
• --no-defaults — Don't read default options from any option file. absolutely not, we're going rogue 🦋
• --defaults-file=# — Only read default options from the given file #. one file and one file only, she's monogamous 💖
• --defaults-extra-file=# — Read this file after the global files are read. the little bonus round at the end ✨

💫 SEE ALSO 💫

myisamlog(1) — her cousin, also iconic, also doing the most 🫶

For more information, please refer to the MariaDB Documentation, available online at https://mariadb.com/docs/

k bye bestie, this was aria_read_log Ver 1.3, from May 2014 — an elder, but she ATE and left no crumbs 👑💅