Sample Header Ad - 728x90

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