Web lists-archives.com

Re: MySQL 5.7 Innodb performans issue




Hi Jørn,

> Found this after I found out what caused it:
> 
> https://www.percona.com/blog/2009/01/21/beware-ext3-and-sync-binlog-do-not-play-well-together/
> 
> I suspect that this also apply to ext4, or?

I would go more specific and say that sync_binlog=1 does not play well with single-threaded workloads.

MySQL 5.6 and above can group commit to the binary log (reducing a lot of IO if transactions arrive at the same time).  I have an explanation on how it works here:
http://www.tocker.ca/2014/12/30/an-easy-way-to-describe-mysqls-binary-log-group-commit.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql