Purge MYSQL Binary Logs On TMG

This page shows how to manually erase MYSQL Binary Logs On TMG to save your hard disk space

You need to SSh to the TMG host for the following procedures:

Verify your hard disk space

example: [root@TB00xxxx mysql]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda5 3.9G 1.1G 2.7G 29% / /dev/sda7 21G 3.7G 17G 19% /mnt/.0 /dev/sda6 2.0G 36M 1.9G 2% /tmp /dev/sda2 4.9G 4.6G 5.3M 100% /var /dev/sda1 494M 16M 453M 4% /boot tmpfs 997M 0 997M 0% /dev/shm

Purge unnecessary binlogs

1. Access mysql database mysql -u user –ppassword e.g. mysql -u tbdb –ptbdbpw

2. Execute the Purge command: Examples: To erase all binlogs before a specific binlog file: PURGE BINARY LOGS TO 'mysql-bin.010'; To erase all binlogs before a specific Date/Time: PURGE BINARY LOGS BEFORE '2015-04-02 22:46:26';

Expire binary log files automatically

You can also set the expire_logs_days system variable to expire binary log files automatically after a given number of days. Simply add this to /etc/my.cnf

     [mysqld]
     expire-logs-days=60

Note: a 60 days rotation log is enabled by default in more recent TB products.

     Restart mysql

Then mysqld will delete them for you automatically