Revision of Binary Logs from Wed, 06/10/2009 - 16:06

Revisions allow you to track differences between multiple versions of your content, and revert back to older versions.

The MySQL binary log contains all statements that update data along with statements that potentially could have updated it. They are used to recover a database, and required if you want to replicate it. However, when the database changes frequently, they build up and can consume a lot of disk space.

Don't just delete the binary log files in /usr/local/mysql/var! Doing so really screws up MySQL!
Automatically purging binary logs
Edit /etc/my.cnf and add/edit a expire_logs_days variable. For example, to purge logs older than 30 days:

expire_logs_days=30

Recent Updates

  • 1 year 1 month ago
    1.27.2 update
  • 1 year 2 months ago
    Drupal 10/11 config
  • 1 year 2 months ago
  • PHP
    1 year 2 months ago
    PHP 8.3.11 and AlmaLinux
  • 1 year 2 months ago
    New version of Pound
Error | Production Monkeys

Error

The website encountered an unexpected error. Please try again later.