MySQL: Log Management: maintenance logs

In general, MySQL does not have any special mechanism to provide log backup, deletion, and other management operations, but relies heavily on OS-level operations.

For binary transaction logs, MySQL provides the expire_logs_days system variable.Indicates the number of days that have expired. If you use replication, set this value as appropriate.

 

Start a new log

• MySQL statement: flush logs;
• MySQLProgram: Mysqladmin flush-logs, mysqladmin refresh

The above operations will inspire:

1. General log query and slow log query: close first and re-open
2. Binary transaction log: Close current, open new files in sequence
3. Error Log: Close the current file and save it as a file with the suffix "-old" to open a new file.