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.