How to disable MySQL binary logging
I "know someone" who took way to long to find an answer to the question how to disable binary logging with MySQL so that it would no longer fills up all disk space putting a certain instance of WordPress offline every now and then. I find this solution rather unexpected: Putting
[mysqld] skip-log-bin
into /etc/mysql/my.cnf
is a weird mix of ini-file syntax [mysqld]
with
non-ini file syntax skip-log-bin
— without any "= value
" assignment. To
be sure that binary logging is turned off after a restart of the service,
here's a way to check:
mysql> SHOW VARIABLES LIKE 'log_bin'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | log_bin | OFF | +---------------+-------+ 1 row in set (0.00 sec)
Finally! If this post turns wrong in the future, it did work for MySQL 5.6.39.