mysql disable binary logs
June 04, 2022
If need to temporarily disable binary logs because of a huge load/dump:
systemctl set-environment MYSQLD_OPTS="--skip-log-bin=1"
Then restart;
systemctl restart mariadb
Verify:
MariaDB> select @@log_bin;
+-----------+
| @@log_bin |
+-----------+
| 0 |
+-----------+
To remove the environment var:
systemctl unset-environment MYSQLD_OPTS