From: Elim Qiu
Date: August 2 2012 10:21pm
Subject: Re: manage mysql-bin.xxxxxx files on mac
List-Archive: http://lists.mysql.com/mysql/227943
Message-Id: <CAKxJ458ovutQKcamtbBbarskmF7=weFSDkDtDD9_3hcQawrsXw@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=f46d0434beec2e323404c64fd4d5

--f46d0434beec2e323404c64fd4d5
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable

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=3D7

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

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

(2) If I comment both 'log-bin=3D=85' and 'binlog_format=3D=85'  setting li=
nes 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

--f46d0434beec2e323404c64fd4d5--