Disabling Aria INSERT log in MariaDB
0
votes
2
answers
541
views
When I bulk
INSERT
into an Aria
table, it creates a copy of the INSERT
in a series of log files (aria_log.%). It can lead to full disk and crash of MySQL.
As I understand, Aria keeps a redo log for TRANSACTIONAL=1
only, and the default behaviour is TRANSACTIONAL=0
. I also created a table specifically with TRANSACTIONAL=0
, but the same behaviour.
I use Aria for a sort of backup, as it is faster than InnoDB on HDD, and do not need transactional/crash-safe behaviour.
How can I disable Aria logging and only writing into the table?
Asked by Googlebot
(4551 rep)
Nov 14, 2021, 11:45 AM
Last activity: Nov 19, 2021, 06:09 PM
Last activity: Nov 19, 2021, 06:09 PM