2013/3/15 Kristian Nielsen <span dir="ltr">&lt;<a href="mailto:knielsen@knielsen-hq.org" target="_blank">knielsen@knielsen-hq.org</a>&gt;</span><br><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="im">How many transactions do you have running in parallel? Binlog group commit</div>
only helps if you have more than 2 transactions writing concurrently (and the<br>
more, the better).<br></blockquote><div><br></div><div>I didn&#39;t add write queries to this master, so I only have the 4 sources (I removed 2 sources since I enable sync_binlog), so I mean 4 transactions in parallel at max ...</div>
<div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Of course, it could also be that the fdatasync() at commit is not a<br>
bottlenect, which would also result in Binlog_commits =~<br>
Binlog_group_commits. How many commits per second do you do?<br></blockquote><div><br></div><div>~120/s (live now :) )</div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">

<div class="im">In MariaDB 10.0, I implemented MDEV-181</div><span class="HOEnZb"><font color="#888888"><br></font></span></blockquote><div><br></div><div>I&#39;m already using 10.0.1. If interested I found last commit for WL#4925 by Yoshinori here : <a href="http://lists.mysql.com/commits/113309">http://lists.mysql.com/commits/113309</a></div>
</div><br>I&#39;m looking for adding a SSD drive to those servers for binlogs.<br>-- <br>Greg