From: Dehua Yang Date: November 29 2012 2:29am Subject: =?UTF-8?Q?sync=5Fbinlog=3D0_affects_MySQL_performance=EF=BC=8Cbut_sync=5Fb?= =?UTF-8?Q?inlog=3D1_works_well?= List-Archive: http://lists.mysql.com/mysql/228738 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=20cf3011dd75d053f204cf990b3d --20cf3011dd75d053f204cf990b3d Content-Type: text/plain; charset=ISO-8859-1 Hello , right now I found some strange things in one MySQL instance . backgroup we use SSD to store datafile , but the binlog files are stored in the SAS disk sync_binlog=0 TPS 4000 insert+update per second max_binlog_size[500M] when MySQL creates new binlog file , we found that some transcations commit statement would be written into slow.log and when I set sync_binlog 0->2000->1000->200->100 . Finally , when the sync_binlog=0 , the commit statement disappear in the slow.log . Hope for you help . I am really appreciated. -- Gtalk : meflyingfish@stripped Skype name : meflyingfish Twitter: http://twitter.com/whitepoplar --20cf3011dd75d053f204cf990b3d--