List:General Discussion« Previous MessageNext Message »
From:Elim Qiu Date:August 2 2012 10:21pm
Subject:Re: manage mysql-bin.xxxxxx files on mac
View as plain text  
Thanks a lot to all helped me out. Really appreciated.

Rik Wasmus,
Thanks for the Binary Log Documentation
http://dev.mysql.com/doc/refman/5.0/en/replication-options-binary-log.html#sysvar_max_binlog_size

Rick James,
I'll try this: expire_logs_days=7

Vikas Shukla,
My server-id is 1 (thought that's the default). I'll try reset master

============= Here are some finding that I got ===============
(1) What server fail to start, it always says that missing  mysql.sock

(2) If I comment both 'log-bin=…' and 'binlog_format=…'  setting lines in
my.cnf, I can actually stop the logging

(3) mysql commands
PURGE BINARY LOGS TO 'mysql-bin.010';
PURGE BINARY LOGS BEFORE '2008-04-02 22:46:26';
Worked very well

(4) Got to learn how to use those log files and turn the logging on with
some sort of controls. Weekly rotate and/or size limit are good ideas

Thank you all again

Thread
manage mysql-bin.xxxxxx files on macElim Qiu2 Aug
  • Re: manage mysql-bin.xxxxxx files on macRik Wasmus2 Aug
    • Re: manage mysql-bin.xxxxxx files on macRik Wasmus2 Aug
      • Re: manage mysql-bin.xxxxxx files on macVikas Shukla2 Aug
        • Re: manage mysql-bin.xxxxxx files on macElim Qiu2 Aug
          • Re: manage mysql-bin.xxxxxx files on macRik Wasmus3 Aug
  • RE: manage mysql-bin.xxxxxx files on macRick James2 Aug