MySQL log file

MySQL can configure the generation of binary log files

Visible in/ETC/MY.CNF

Log-bin=mysql-bin

Files visible under the MySQL path:

to set the number of saved log files :

Modifying/etc/my.cnf in the configuration file requires the restart of MySQL to take effect:

Expire_logs_days=7 (keep data for 7 days)

Modify the configuration on line:

Show variables like '%expire_logs_days% '; View the current configuration

Set global expire_logs_days=5; modifying scenarios

Effective time: The deleted file is automatically checked the next time the log file is generated.

to delete an existing log file scenario:

Log in to MySQL

View Log list show binary logs;

Delete log: PURGE MASTER LOGS to ' mysql-bin.010′; Delete files before mysql-bin.010, not including 010

Delete all: Reset master; ( not used to confirm )

MySQL log file