… two versions tested: Percona Server 5.1.57 – released and Percona Server 5.1.57 with the Group Commit Fix applied. The first graph shows the results… batteries periodically 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 Percona…
Post: Percona Server 5.5.18-23.0: Now with Group Commit!
December 19, 2011 By 3 Comments
… imported the group commit patch from MariaDB and is making 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…
Post: Pretending to fix broken group commit
February 2, 2009 By 11 Comments
The problem with broken group commit was discusses many times, bug report was reported 3.5Â years ago and still not fixed in MySQLÂ… about it before, see “Group commit and real fsync” and “Group commit and XA”. The problem is the InnoDB tries to keep the same order of transactions… soon, you can take current version for testing from Launchpad) we introduce –innodb-unsafe-group-commit mode. There are results with this options…
Post: Group commit and real fsync
May 3, 2006 By 9 Comments
… did not work with former group commit code. The new code for group commit however was never implemented. XA…test=fileio –file-fsync-freq=1 –file-num=1 –file-total-size=16384 –file-test-mode=rndwr. This will write and fsync the… if this bug is going to be fixed ? I’m not authority in this question…
Post: Great work Innodb Team
November 30, 2009 By 8 Comments
… issues of large full table scan wiping off the cache. The Group Commit bug is also finally fixed now. Innodb plugin documentation now seems to… wider community testing. Number of patches suggested by community such as Google and Percona were reworked and included in the plugin during…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…any plans to fix Innodb so it unlocks (or never locks) the rows if …tests by Peter Zaitsev, O_DIRECT works well to remove double buffering. In distant future, I would like to have the…group commit works again. PZ: You can disable binary logging to get Group Commit back. Though this is often not the…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…the benchmarks to get the numbers right. 2. I was running vmstat during one of the tests and my eye caught the… the effects of this were marginal. Alexey Kopytov fixed this in the… innodb_flush_log_at_trx_commit = 2 innodb_flush_method = … = 64M innodb_log_files_in_group = 2 innodb_read_io_threads …
Post: Another scalability fix in XtraDB
January 23, 2009 By 13 Comments
…’s and your SMP fixes almost made InnoDB results acceptable in primary…after 8 connections, si I decided to test MySQL-5.1.30 with standard …-write lock. The new results you can see on graph. The patch for page…log_files_in_group=2 \ –innodb_log_buffer_size=8M \ –innodb_flush_log_at_trx_commit=2 \…
Post: Innodb plugin 1.0.4 released - great job Innobase
August 11, 2009 By 3 Comments
… different implementations. Among other changes I’m especially pleased with fixed Group Commit Bug which I reported about 4 years ago and which… semi-fix for this problem earlier this year but it is great to see solution with even less mutex code. Now the fun part starts – we need to evaluate/benchmark/stress test Innodb Plugin 1.0.4 to…
Post: Fix of InnoDB/XtraDB scalability of rollback segment
January 18, 2009 By 9 Comments
… emulates intensive insert/delete queries). By our results the problem is in concurrency on rollback segment, …log_at_trx_commit=2 innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log…-size 32K –init-rng on –validate off –test oltp –oltp-test-mode complex –oltp-sp-name –oltp-read…
