… software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for…_group = 4 innodb_buffer_pool_instances = 4 innodb_adaptive_flushing = 1 innodb_adaptive_flushing_method = estimate innodb_flush_log_at_trx_commit… was all about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… as a first-class member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition mentions MariaDB in many places… time-based types, as well as microseconds in SHOW PROCESSLIST Group commit for the binary log makes the server much faster with… same group commit fix, and MySQL 5.6 offers microsecond timestamp support, as well as a lot of optimizer improvements. Even the standard MySQL…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
…MySQL. My talk on PL MySQL Conference Percona XtraDB Cluster: New HA solution. Percona XtraDB Cluster provides: Synchronous replication. Transaction either commited…/Percona-XtraDB-Cluster/ Documentation Codership Wiki General Discussion group Launchpad project Bug reports Previous posts on this …
Comment: Percona XtraDB Cluster Feature 2: Multi-Master replication
April 2, 2012 By 16 Comments
… graphs count. You see galera faster than MySQL 5.5.21 semisync (blue line). MySQL was getting out of semisync after a concurrency of 64. The green line ist MariaDB 5.5.20 with group commit and…
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
…_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /usr/local/mysql/data innodb_buffer_pool_size = 2000M innodb_additional… 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: 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: Percona Server 5.5.18-23.0: Now with Group Commit!
December 19, 2011 By 3 Comments
… available here and from the Percona Software Repositories). Based on MySQL 5.5.18, including all the bug fixes in it… 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…
Post: Group commit and real fsync
May 3, 2006 By 9 Comments
… at two issues here which interleave such funny way Group commit is broken in MySQL 5.0 if binary loging is enabled (as… was implemented in MySQL 5.0 which did not work with former group commit code. The new code for group commit however was never implemented…. if binary log is disabled, so is XA and old group commit code works just fine. Second one is interesting. Actually we…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… was MySQL 5.0 broken group commit bug. First I should note I am extremely unhappy how MySQL handled this problem. While working for MySQL… transactions so group commit would trigger in MySQL 4.0 and large number of transactions in total so serializing them would make MySQL unable… not get same performance as with MySQL 4.1 Disable Binary Logging This allows to get group commit back but obviously you loose…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… amazing MySQL manual, especially the option and …commanual defaults_fileblogpercona.commanual defaults_group_suffixblogpercona.commanual delay_key_writeblogpercona…commanual innodb_checksumsblogpercona.commanual innodb_commit_concurrencyblogpercona.commanual innodb_concurrency_ticketsblogpercona…
