A tutorial on how to close and delete MySQL logs under Linux

LNMP One-click installation of the install package MySQL default is to open the log file,

If the data operation is more frequent, it will produce a lot of logs.

A mysql-bin.0000* similar file is generated below the/usr/local/mysql/var/,

And generally in dozens of MB to a few GB, more will 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 function: Delete log: execution:/usr/local/mysql/bin/mysql-u root-p

Enter password login and then execute: RESET master;

Re-enter: Quit exit MySQL command mode.

Completely disable MySQL log: Modify/etc/my.cnf file,

Find Log-bin Search =mysql-binbinlog_format=mixed and then add the # in front of these two lines,

Comment it out, and then execute/etc/init.d/mysql restart.

or directly to the directory/usr/local/mysql/var/delete log files can be used normally!

After the above methods, you have to close and delete the MySQL log, but I still suggest you open, so if there is a problem can be traced to the log quickly resolved.