… options innodb_buffer_pool_size = 55G innodb_log_file_size = 1G innodb_log_files_in_group = 4 innodb_buffer_pool_instances = 4 innodb_adaptive_flushing = 1 innodb_adaptive_flushing_method = estimate innodb_flush_log_at_trx_commit…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… as microseconds in SHOW PROCESSLIST Group commit for the binary log makes the server much faster with the binary log enabled Faster queries through… to this list. For example, Percona Server has the same group commit fix, and MySQL 5.6 offers microsecond timestamp support, as…
Comment: Percona XtraDB Cluster Feature 2: Multi-Master replication
April 2, 2012 By 16 Comments
… group commit and xtradb. Even if they are faster. Galere performs awesome and you don’t have the data in the relay log…
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
…_home_dir = innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /usr/local/mysql/data innodb_buffer_pool_size…_mem_pool_size = 2M innodb_log_file_size = 65M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait…(1),field1 from Table where REQUEST_TIME >= ’2012-03-26′ group by field1; 14 rows in set (15 min 54.29…
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
… disabled), innodb_flush_log_at_trx_commit=1 and sync_binlog=1 or in tabular format: Threads Nofix Group Commit fix 1 21.51… Group Commit Fix in an upcoming Percona Server release. It is also interesting to see how Flash cards will handle innodb_flush_log… is also result to compare binary logs enabled and disabled. All results are for binaries with group commit fix. Results with disabled write…
Post: Pretending to fix broken group commit
February 2, 2009 By 11 Comments
… significantly. We wrote also 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 in binary logs and in transaction logs…-group-commit — as I said there is possibility that transactions in binary-logs will be in different order than in InnoDB transactional log…
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 keep different transactonal storage engines in sync, together with binary log. XA… issue is trigered by enabled binary log. if binary log is disabled, so is XA and old group commit code works just fine. Second…
Post: Group commit and XA
May 19, 2006 By 8 Comments
… post Group commit and real fsync I made several experiments: I ran sysbench update_key benchmarks without —log-bin, with —log-bin, and with —log… value is 1). Results (in transactions / sec) threads without —log-bin —log-bin —log-bin and —innodb_support-xa=0 1 1218.68… can see group commit is not only broken when XA is enabled but also if XA is disabled but binary log is enabled…
Post: MySQL Limitations Part 2: The Binary Log
October 23, 2010 By 11 Comments
… between InnoDB and the binary log. This adds more fsync calls, and causes mutex contention, and prevents group commit, and probably other things… understand. Kristian Nielsen has an extensive series of posts on group commit alone. I think that a full fix might require significant…’s worth noting that PBXT does replication through its transaction logs, so there’s even precedent for this among MySQL storage…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…, group commit being broken in 5.1 makes no difference. If you have a battery-backed disk controller cache, then the commit returns…€™ll get group commit again. HT: I do not think so. Sergei Golubchik serialized the MySQL binlog write and the InnoDB log flush… from 5.1, then InnoDB’s group commit works again. PZ: You can disable binary logging to get Group Commit back. Though this is often…
