… time-based types, as well as microseconds in SHOW PROCESSLIST Group commit for the binary log makes the server much faster with… to this list. For example, Percona Server has the same group commit fix, and MySQL 5.6 offers microsecond timestamp support, as well…. I remember that a couple years back I told Monty, “fix subqueries and you will change the world for a lot…
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
…_flush_log_at_trx_commit=1 and sync_binlog=1 or in tabular format: Threads Nofix Group Commit fix 1 21.51 21.99… die, and the fix provides a way to handle traffic until the battery is fixed. We will include the Group Commit Fix in an upcoming… logs enabled and disabled. All results are for binaries with group commit fix. Results with disabled write cache thread trx=1, No binlog…
Post: Percona Server 5.5.18-23.0: Now with Group Commit!
December 19, 2011 By 3 Comments
… the performance improvements that group commit brings available to users of Percona Server 5.5. See the Testing the Group Commit Fix blog post for the kind of performance improments that can be expected. Bug Fixes Several crashes were reported…
Post: Pretending to fix broken group commit
February 2, 2009 By 11 Comments
… problem with broken group commit was discusses many times, bug report was reported 3.5Â years ago and still not fixed in MySQLÂ… significantly. We wrote also about it before, see “Group commit and real fsync” and “Group commit and XA”. The problem is the InnoDB tries… current version for testing from Launchpad) we introduce –innodb-unsafe-group-commit mode. There are results with this options vs without (results…
Post: Group commit and real fsync
May 3, 2006 By 9 Comments
… 5.0 which did not work with former group commit code. The new code for group commit however was never implemented. XA allows to…. if binary log is disabled, so is XA and old group commit code works just fine. Second one is interesting. Actually we… want to know if this bug is going to be fixed ? I’m not authority in this question but as Heikki…
Comment: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
…://www.mysqlperformanceblog.com/2009/02/02/pretending-to-fix-broken-group-commit/ Before the latest group commit fix turning on bin-log resulted in over 95… much performance drop does bin-log cause now with the group commit fix. 2) In your results did you use innodb_support-xa…
Comment: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
Thanks Vadim. With 128 threads, even with the latest group commit fix turning on binlog still results in a 70% performance drop (from 3000tps to 1000tps) when there is no BBU. So I guess it’s probably still not a good idea to run MySQL in a cloud?
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… you also have to have plenty of concurrent transactions so group commit would trigger in MySQL 4.0 and large number of… to get group commit back but obviously you loose point in time recovery and replication. Use innodb_flush_log_at_trx_commit=2… workarounds. Also it is worth to mention BBU does not fix the problem but dramatically raises number of update transactions per…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… to try it out. Q14: Are there any plans to fix Innodb so it unlocks (or never locks) the rows if…, group commit being broken in 5.1 makes no difference. If you have a battery-backed disk controller cache, then the commit returns… 5.1, then InnoDB’s group commit works again. PZ: You can disable binary logging to get Group Commit back. Though this is often…
Comment: How many fsync / sec FusionIO can handle
March 4, 2010 By 13 Comments
Group commit is fixed when the binlog is off. Otherwise, prepare_commit_mutex is locked in innobase_xa_prepare and unlocked in innobase_commit. The… the plugin release notes that state that group commit is fixed might confuse people. Not having group commit can be a huge deal depending on…
