“binlog” is a file that records all changes made in the server.

It is an essential element for PIT (point-in-time recovery) and replication, and if you don’t use these two functions, you don’t have to activate it. Although the empty log itself is subtle, it adds to the IO burden.

How to turn off “binlog”

Step 1. Write in /etc/mysql/mysql.conf.d/mysqld.cnf as below.
—————————————————————————–

[mysqld] #
# * Basic Settings
#
skip-log-bin                           <—Add this line into the file
—————————————————————————–

How to check if “binlog” off
Whether or not the bean log is activated can be checked with “show” command in MySQL DB
—————————————————————————–
mysql> show variables like’log_bin’;
+—————+——-+
| Variable_name | Value |
+—————+——-+
| log_bin      | ON   |
+—————+——-+
1 row in set (0.00 sec)
—————————————————————————–