False impression one: InnoDB storage engine for write-intensive applications, MyISAM for read-intensive applications
By the time MySQL 5.6 was present, the InnoDB storage engine had been myisam and could not see the need for any other application to use MyISAM. Of course, the MyISAM storage engine itself has completely stopped developing.
False impression two: Sync_binlog need to be set to 0 or 2
Answer: There is a problem with the group commit failure before MySQL version 5.6, so you need to set this parameter to 0 or both to improve performance. But this means that there are a lot of hidden problems with the magic box open. MySQL 5.6,innosql 5.5,mariadb version 5.5 has resolved the group submission invalidation issue. So,sync_binlog must be set to 1
This article is from the DBA Sky blog, so be sure to keep this source http://9425473.blog.51cto.com/9415473/1669373
MySQL Error impressions