HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Disable redo logs on MariaDB

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
disablelogsmariadbredo

Problem

The title is pretty explicit, I just want to disable completely redo logs on MariaDB 5.5. This is more of a testing database that might eventually be used for a small web forum, but I don't care about being able to recover from crashes, all I care about is saving disk space.

Is there a way to completely disable redo logs? What if I set the max size to 0?

Solution

The redo logs are required by the InnoDB storage engine. The redo logs provide the 'D' in ACID - durability. You can't set the innodb_log_file_size to 0 as the smallest allowed value is 1MB. Also, the smallest value for innodb_log_files_in_group is 1, so you can't use that either.

You can shut down the MariaDB server and disable InnoDB - use these settings in your .cnf file:

[mysqld]
skip_innodb
default_storage_engine=Aria


Then delete the InnoDB redo log files (by default: ib_logfile0 and ib_logfile1 in your datadir - by default /var/lib/mysql/) and start the MariaDB server again.

Code Snippets

[mysqld]
skip_innodb
default_storage_engine=Aria

Context

StackExchange Database Administrators Q#251982, answer score: 4

Revisions (0)

No revisions yet.