Patterns

So your binary logs have grown to an ugly size eating up most of your servers disk size? The easiest way to truncate the logs in a proper way is to run the following command:

reset master;

Please note: This command works for MySQL >=5, for older versions use flush master;.

Update: There exists a system variable that would automatically purge binary logs older than a given interval. Excerpt from MySQL documentation:

For the binary log, you can set the expire_logs_days system variable to expire binary log files automatically after a given number of days (see Section 5.1.3, “System Variables”).