First page Back Continue Last page Image

Methods to keep Log files from becoming too big

Log Rotation

With log rotation you will occasionally rename the current log file and allow mysql to create a new one. You can then either archive or delete the files once they are old enough

Expiration by Age

Binary logs can use the expire_log_days system variable to automatically delete the log after the specified number of days