Skip to main content

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.

Expat 2.2.5 released

Expat 2.2.5 has recently been released. It fixes miscellaneous bugs. For more details, please check the changelog. If you maintain Expat packaging or a bundled version of Expat somewhere, please update to 2.2.5. Thanks! Sebastian Pipping

Expat 2.2.4 released

Expat 2.2.4 has recently been released. It features one major bugfix regarding files encoded as UTF-8, and improvements to the build system. If you are using a more ancient version of Visual Studio like 2012, please check the post-2.2.4 commits in Git for related fixes to compilation. Also, founding of Rhodri's work on Expat by the Core Infrastructure Initiative is coming to an end. If you can fund additional developers for work on Expat — including smooth integration of by-default protection against billion laughs denial-of-service attacks — please get in touch.

Sebastian Pipping