…/1000, $K) ON DUPLICATE KEY UPDATE k=VALUES(k)+k; COMMIT; So this workload produces SEQUENTIAL inserts into Primary Key, that…_log_at_trx_commit = 1 innodb_buffer_pool_size = 36G innodb_log_file_size = 4G innodb_log_files_in_group = 2 innodb…_capacity = 4000 innodb_use_native_aio=0 #not innodb options (fixed) port = 3306 back_log = 50 max_connections = 2000 max_prepared…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…=off run The base MySQL configuration (configuration A) appears below: #####fixed innodb options innodb_file_format = barracuda innodb_buffer_pool_size… innodb_flush_log_at_trx_commit = 1 innodb_log_file_size = 1G innodb_log_files_in_group = 2 innodb_purge_threads = 1 innodb_fast_shutdown = 1 #not innodb options (fixed) back_log = 50 wait…
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…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… 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…
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…
