This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

FLUSH LOGS doesn't work for Aria logs as intended?!?

I tried a lot to get incremental backups with Aria logs to work. In the progress I noticed FLUSH LOGS doesn't seem to work as intended. Steps:

cd <datadir>
mysql
-> USE demo
-> CREATE TABLE demo (id CHAR(17), c1 TINYINT UNSIGNED, c2 TINYINT UNSIGNED, c3 INT, c4 INT, PRIMARY KEY(id)) ENGINE=aria;
-> FLUSH LOGS; exit;
systemctl stop mariadb
aria_read_log -a

Result is a lot of output which signifies the log still holds the step(s) before FLUSH LOGS; Instead use:

cd <datadir>
mysql
-> USE demo
-> CREATE TABLE demo (id CHAR(17), c1 TINYINT UNSIGNED, c2 TINYINT UNSIGNED, c3 INT, c4 INT, PRIMARY KEY(id)) ENGINE=aria; exit;
rm aria_log*
systemctl restart mariadb
systemctl stop mariadb
aria_read_log -a

Result is a short output, amounting to "nothing happened". Do I misunderstand the meaning of FLUSH LOGS; ?

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.