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.