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