…_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
… 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…
Comment: Percona XtraDB Cluster Feature 2: Multi-Master replication
April 2, 2012 By 16 Comments
… 64. The green line ist MariaDB 5.5.20 with group commit and xtradb. Even if they are faster. Galere performs awesome…
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
…_dir = innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /usr/local/mysql/data innodb_buffer_pool_size… innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 A count command with…(1),field1 from Table where REQUEST_TIME >= ’2012-03-26′ group by field1; 14 rows in set (15 min 54.29…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
…HA solution. Percona XtraDB Cluster provides: Synchronous replication. Transaction either commited on all nodes or none. Multi-master replication. You …/downloads/Percona-XtraDB-Cluster/ Documentation Codership Wiki General Discussion group Launchpad project Bug reports Previous posts on this topic: …
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… traffic until the battery is fixed. We will include the Group Commit Fix in an upcoming Percona Server release. It is also… logs enabled and disabled. All results are for binaries with group commit fix. Results with disabled write cache thread trx=1, No…
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… current version for testing from Launchpad) we introduce –innodb-unsafe-group-commit mode. There are results with this options vs without (results…. So what can be wrong if you run –innodb-unsafe-group-commit — as I said there is possibility that transactions in…
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 brings available to users of Percona Server 5.5. See the Testing the Group Commit Fix blog post…
Post: Group commit and real fsync
May 3, 2006 By 9 Comments
… looking at two issues here which interleave such funny way Group commit is broken in MySQL 5.0 if binary loging is… 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…
Post: Group commit and XA
May 19, 2006 By 8 Comments
Returning to post Group commit and real fsync I made several experiments: I ran sysbench … 3630.55 665.18 1151.36 So we can see group commit is not only broken when XA is enabled but also…
