mysqlbinlog --start-datetime="2008-05-22 00:00:00" --stop-datetime="2008-05-29 00:00:00" localhost-bin.000004
mysql -e 'select @@expire_logs_days'
*** see what’s inside bin log
mysqlbinlog localhost-bin.000004
*** show all active bin logs
mysql -e 'show binary logs'
*** purge bin logs
purge binary logs before now() - interval 2 day;
*** FREE UP SPACE TAKEN BY MYSQL BIN LOGS ***
set global expire_logs_days=1; flush logs;