View source for Purge MYSQL Binary Logs On TMG

#REDIRECT [[FN13763]]
This page shows how to manually erase MYSQL Binary Logs On TMG to save your hard disk space
<br> 

You need to SSh to the TMG host for the following procedures: 
== Verify your hard disk space  ==
 [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

== MYSQL binlogs location  ==
The directory of MYSQL binlogs is defined at /etc/my.cnf

[mysqld]

datadir=/var/lib/mysql

== Purge unnecessary binlogs   ==

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

2. Execute the Purge command:
 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
      service mysqld restart

Then mysqld will delete them for you automatically