LNMP One-click Install package installed MySQL by default, the log file is turned on,
A large number of logs are generated if the data is operated more frequently.
Produce similar mysql-bin.0000* files under/usr/local/mysql/var/,
and generally dozens of MB to several GB, but also eat the entire hard disk space,
Never cause MySQL to start or error, such as VPS Forum user feedback.
How to turn off the MySQL log feature: delete log: Execute:/usr/local/mysql/bin/mysql-u root-p
Enter password login and then execute: RESET master;
Re-enter: Quit the mysql command mode.
Completely disable MySQL log: Modify the/etc/my.cnf file,
Find Log-bin Search =mysql-binbinlog_format=mixed the two lines before adding #,
Comment it out, and then execute/etc/init.d/mysql restart.
Or go directly to the directory/usr/local/mysql/var/delete log files to normal use!
How to turn off MySQL log and delete mysql log
