Thanks Ravi
On Tue, 2006-04-11 at 11:41 +0530, Ravi Prasad LR wrote:
> yes, that is the reason for slowness .
>
> Thanks,
> Ravi
> On Tuesday 11 April 2006 10:51, Mohammed Abdul Azeem wrote:
> > Hi Ravi,
> >
> > Since the sync'ing is done to disk with sync_binlog=1, the update
> > queries to server are slower compared to the server having sync_binlog=0
> > rite ?
> >
> > Thanks,
> > Abdul.
> >
> > On Tue, 2006-04-11 at 10:51 +0530, Ravi Prasad LR wrote:
> > > Hi Abdul,
> > > When sync_binlog is set to 1, innodb fsyncs the binary
> > > log to disk after every single write to binary log, but not in the case
> > > of sync_binlog=0.
> > >
> > > >From MySQL manual:
> > >
> > > <snip>
> > > If the value of this variable is positive, the MySQL server synchronizes
> > > its binary log to disk (fdatasync()) after every sync_binlog writes to
> > > this binary log. Note that there is one write to the binary log per
> > > statement if in autocommit mode, and otherwise one write per transaction.
> > > The default value is 0 which does no sync'ing to disk. A value of 1 is
> > > the safest choice, because in case of crash you lose at most one
> > > statement/transaction from the binary log; but it is also the slowest
> > > choice (unless the disk has a battery-backed cache, which makes sync'ing
> > > very fast). This variable was added in MySQL 4.1.3.
> > > </snip>
> > >
> > > --Ravi
> > >
> > > On Tuesday 11 April 2006 10:22, Mohammed Abdul Azeem wrote:
> > > > Hi,
> > > >
> > > > I have a master/slave setup ( replication enabled ) for mysql in two
> > > > different geographic locations ( one master/slave set up in each
> > > > location). In one location i have configured the sync_binlog=1 . And
> > > > the other location does not have the same.
> > > >
> > > > My problem is, when i run similar update processes on both the master
> > > > servers, the server with sync_binlog=1 is very slower in terms of
> > > > completing the update query as compared to the machine having
> > > > sync_binlog=0.
> > > >
> > > > Is that a cause for slow performance ?
> > > >
> > > > Thanks in advance,
> > > > Abdul.
> > > >
> > > > ________________________________________
> > > > This email has been Scanned for Viruses!
> > > > www.newbreak.com
> > > >
> > > > ========================================
> >
> > ________________________________________
> > This email has been Scanned for Viruses!
> > www.newbreak.com
> >
> > ========================================
> ========================================
> ________________________________________
> This email has been Scanned for Viruses!
> www.newbreak.com
________________________________________
This email has been Scanned for Viruses!
www.newbreak.com
========================================
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
