Binary Logs

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

  • 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.