… cache is disabled), innodb_flush_log_at_trx_commit=1 and sync_binlog=1 or in tabular format: Threads Nofix Group Commit fix 1 21… was done with a disabled sync_binlog=0 and without write-back cache: Threads Nofix Group Commit fix 1 38.19 33.11… with group commit fix. Results with disabled write cache thread trx=1, No binlog trx=0, No binlog trx=1, Binlog sync=0 trx=1, Binlog…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… you’ll get group commit again. HT: I do not think so. Sergei Golubchik serialized the MySQL binlog write and the InnoDB log flush… on MySQL’s binlog to work. Of course, if you remove that mutex from 5.1, then InnoDB‘s group commit works again. PZ: You can disable binary logging to get Group Commit back. Though this is…
Post: Percona Server 5.5.18-23.0: Now with Group Commit!
December 19, 2011 By 3 Comments
… group commit between XtraDB and the replication binlog. Percona has imported the group commit patch from MariaDB and is making the performance improvements that group commit… of the import operation. This allows queries accessing other InnoDB tables to proceed normally and not be blocked until …
Comment: FlashCache: tpcc workload with FusionIO card as cache
June 11, 2010 By 20 Comments
Ryan, what InnoDB config you use to get sustained 10K+ transactions/sec? Are … on FusionIO as well? Do you use binlog? Group commit is reportedly to be still broken when binlog is enabled (http://kristiannielsen.livejournal.com… it’s possible to get sustained 10K+ trans/sec if binlog is enabled.
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…innodb_change_bufferingblogpercona.commanual innodb_checksumsblogpercona.commanual innodb_commit_concurrencyblogpercona.commanual innodb_concurrency_ticketsblogpercona.commanual innodb_data_file_pathblogpercona.commanual Innodb_data_fsyncsblogpercona.commanual innodb…
Comment: Jeremy Cole on MySQL Replication
June 14, 2006 By 12 Comments
… you mentioned the issue of group commit being broken (see http://www.mysqlperformanceblog.com/2006/05/19/group-commit-and-xa), I read that… with the –innodb-safe-binlog option, which adds consistency between the content of InnoDB tables and the binary log. (Note: –innodb-safe-binlog is unneeded…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…:259 ‘Aborted_clients’, ’267108′ ‘Aborted_connects’, ’25997′ ‘Binlog_cache_disk_use’, ’145′ ‘Binlog_cache_use’, ’9638599′ ‘Bytes_received’, ’2671219831′ ‘Bytes_…innodb_file_io_threads=4 innodb_lock_wait_timeout=15 # CHANGED from 50 innodb_log_files_in_group=3 innodb_flush_log_at_trx_commit=0 #innodb…
Post: Jeremy Cole on MySQL Replication
May 27, 2006 By 12 Comments
… guess Jeremy speaks about enabling binary log and setting sync_binlog option which is good for safe replication. But it is… Binary log with MySQL 5.0 you loose group commit which can dramatically increase commit rate for multiple user load. See this post… to single stream so group commit can’t work. Furthermore even if you run with innodb_flush_logs_at_trx_commit=2 you still…
Comment: MySQL Limitations Part 2: The Binary Log
October 23, 2010 By 11 Comments
Agree with your points here. My group commit work will provide a partial solution to this (it is … fsync() per group commit is needed (on the binary log). This will make the binlog only slightly more expensive than using InnoDB durably without… to one fsync() per group commit, we are in pretty good shape already, able to do 1000-10000 commits per second on typical…
Post: XtraDB storage engine release 1.0.2-3 (Spring edition) codename Sapporo
March 2, 2009 By 10 Comments
… results. Fix broken group commit in InnoDB As you know, the group commit of InnoDB doesn’t work after MySQL 5.0 with binlog. We pretend to fix this and added “innodb_enable_unsafe_group_commit=[0…
