Re: MySQL 5.7 Innodb performans issue
- Date: Thu, 21 May 2015 10:39:36 -0400
- From: Morgan Tocker <morgan.tocker@xxxxxxxxxx>
- Subject: Re: MySQL 5.7 Innodb performans issue
> Found this after I found out what caused it:
> 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