advanced code snippet search

Posted By

mushookies on 08/21/09


Tagged

mysql delete log binary flush transaction purge


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

kubaitis


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.

Expand | Embed | Plain Text 
  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.