Thanks for the advices. When the server could not started, no error was reported in the
log. The error log says:
-----------------------------------------------
110301 7:51:44 [Note] /usr/sbin/mysqld: Normal shutdown
110301 7:51:46 [Note] /usr/sbin/mysqld: Shutdown complete
-----------------------------------------------
After I un-comment the line log-bin ... restarted the server, only warning was in the
error log:
---------------------------------------------------
110228 10:21:25 [Warning] Neither --relay-log nor --relay-log-index were used; s
o replication may break when this MySQL server acts as a slave and has his hostn
ame changed!! Please use '--relay-log=mysqld-relay-bin' to avoid this problem.
110228 10:21:25 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.51a-24+lenny4-log' socket: '/var/run/mysqld/mysqld.sock' port: 3
306 (Debian)
--------------------------------------------------
The reason I commented out the line for relay-log, because it constantly creates relay log
files even if no data in it, we don't need relay log files.
--- On Mon, 2/28/11, pickup.lichun <pickup112@stripped> wrote:
> From: pickup.lichun <pickup112@stripped>
> Subject: Re: Cannot disable binlog
> To: "Walter Heck - OlinData.com" <lists@stripped>
> Cc: database100@stripped, "Replication" <replication@stripped>,
> "martín arrieta" <necrite@stripped>
> Date: Monday, February 28, 2011, 9:21 PM
> you may have relay-log-info-file or
> relay-log or log-bin-index in the
> my.cnf.
> delete the items in my.cnf.
> to find which items need to delete you need refer to you
> error log.
> the default error log is /var/lib/mysql/hostname.err
> (hostname means the
> host name of you manchine)
> or the file you specified as log-error=... in your my.cnf
>
>
> 于 2011年03月01日 06:46, Walter Heck - OlinData.com
> 写道:
> > Look in your error log, on debian that's in syslog, in
> other distro's it's
> > most likely in /var/log/mysql or some such, unless you
> customised it.
> >
> > Walter
> >
> > On Mon, Feb 28, 2011 at 23:33, Database
> System<database100@stripped>wrote:
> >
> >> When I tried to start, it just say Failed. The
> line is log-bin = /directory
> >> name/binlog
> >>
> >> --- On Mon, 2/28/11, martín arrieta<necrite@stripped>
> wrote:
> >>
> >>> From: martín arrieta<necrite@stripped>
> >>> Subject: Re: Cannot disable binlog
> >>> To: "Replication"<replication@stripped>
> >>> Date: Monday, February 28, 2011, 4:19 PM
> >>> Can you paste the error that you get
> >>> when you try to start the server
> >>> without the log-bin line? also the my.cnf conf
> (replication
> >>> related lines..)
> >>> and mysql version.
> >>>
> >>> Martin.
> >>>
> >>> On 28 February 2011 20:11, Database
> System<database100@stripped>
> >>> wrote:
> >>>
> >>>> Hi,
> >>>>
> >>>> I have a Linux running MySQL. It has been
> running fine
> >>> for a couple of
> >>>> years. In my.cnf there is a line:
> log-bin=/path/file.
> >>> And the server creates
> >>>> binary log files as supposed to. Now I
> want to disable
> >>> binary log
> >>>> generation. I commented out that line in
> my.cnf file.
> >>> But each time I did
> >>>> that, and stop, start mysql, the MySQL
> server cannot
> >>> start. After I
> >>>> un-comment that line, the server was able
> to start. I
> >>> don't know why.
> >>>> Any idea?
> >>>>
> >>>> Thanks,
> >>>> Lisa
> >>>>
> >>>>
> >>>>
> >>>>
> >>>> --
> >>>> MySQL Replication Mailing List
> >>>> For list archives: http://lists.mysql.com/replication
> >>>> To unsubscribe:
> >>>> http://lists.mysql.com/replication?unsub=1
> >>>>
> >>>>
> >>
> >>
> >>
> >> --
> >> MySQL Replication Mailing List
> >> For list archives: http://lists.mysql.com/replication
> >> To unsubscribe:
> >> http://lists.mysql.com/replication?unsub=1
> >>
> >>
> >
>
>
> --
> Dear all
>
> Thanks.
>
> Sincerely yours
> Pickup.lichun
>
> 建立业界mysql运维标准
> Pickup.lichun DBA-OPS-Alibaba
> --------------------------------------------------------------
> http://china.alibaba.com/
> department: B2B - OPS - MySQL DBA
> mail: pickup.lichun@stripped
>
> pickup112@stripped
> Trade Manager: pickup112
> phone:
> 86-0571-85022088-34953
> mobile:
> (86)13588746229
>
>
