patternMinor
Disable redo logs on MariaDB
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?
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
You can shut down the MariaDB server and disable InnoDB - use these settings in your .cnf file:
Then delete the InnoDB redo log files (by default:
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=AriaThen 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=AriaContext
StackExchange Database Administrators Q#251982, answer score: 4
Revisions (0)
No revisions yet.