The Ultimate Guide to High Availability with MariaDB

Comments - How to disable logs aria and logs binary.

3 years, 6 months ago Lon Hammonds
Re: How to disable logs aria and logs binary.

You can temporarily disable the binary log such as doing a data import of a large .sql file and avoiding unnecessary logging:

mysql
SET sql_log_bin = 0;
source /tmp/mydb.sql
exit

To turn it off permanently, you could set the sql_log_bin option in the MariaDB configuration file.

 
2 years, 9 months ago Robert Eby
Re: How to disable logs aria and logs binary.

it's 2021-07-20.

I tried this a few weeks ago and it didn't seem to work. Especially not when specified in a configuration file like my.ini.

I had a 250 GB MyISAM dump (import engine changed to Aria). The system wanted to use up 500 GB in the active database files to import 250 GB of data...

Cheers,

 
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.