MySQL how to turn off binary logging

First, clear the binary log file

Method one: Reset master;

Method two: Purge binary logs to ' *.bin ' or purge binary logs before ' date '

or set global expire_logs_days=3;

Note: Log_bin is a static parameter, cannot be modified online, expire_logs_days is a global parameter

Second, modify the/etc/my.cnf file, find the following two lines and comment

#log-bin=mysql-bin

#binlog_format =mixed

Third, find the right time to restart the database

This article from "Small Fish Blog" blog, declined reprint!

MySQL how to turn off binary logging