Posted By

mushookies on 08/21/09


Tagged

mysql delete log binary flush transaction purge


Versions (?)

Who likes this?

2 people have marked this snippet as a favorite

kubaitis
mushookies


Purge MySQL Binary Logs


 / Published in: MySQL
 

URL: http://dev.mysql.com/doc/refman/5.0/en/purge-binary-logs.html

Used to make sure the server log dose not fill up the hd.

  1. PURGE BINARY LOGS BEFORE 'yyyy-mm-dd';

Report this snippet  

Comments

RSS Icon Subscribe to comments
Posted By: mushookies on August 24, 2009

SET GLOBAL expirelogsdays = 10;

+++++++++++++++++++++++++++++++

vi /etc/my.cnf

expirelogsdays = 10

Posted By: mushookies on August 24, 2009
SET GLOBAL expire_logs_days = 10;

+++++++++++++++++++++++++++++++

vi /etc/my.cnf

expire_logs_days = 10

You need to login to post a comment.