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 > > ========================================
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
