Binary Logs

Primary tabs

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

Purge existing binary logs
Look in /usr/local/mysql/var and to check the name of the oldest binary log file you want to keep

/usr/local/mysql/bin/mysql -u root -p
purge master logs to 'mysql-bin.010';

Completely disable binary logging
Edit /etc/my.cnf

#log-bin=mysql-bin
#binlog_format=mixed

Recent Updates

  • nginx
    8 months 3 weeks ago
    1.27.2 update
  • lighttpd
    9 months 3 days ago
    Drupal 10/11 config
  • Drupal 11
    9 months 5 days ago
  • PHP
    9 months 5 days ago
    PHP 8.3.11 and AlmaLinux
  • Pound SSL Proxy
    9 months 5 days ago
    New version of Pound