… no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually… users_groups (user_id, group_id) VALUES (100, 1); UPDATE groups SET last_joined=NOW(), last_user_id=100 WHERE id=1; COMMIT; How often might multiple users join the same group…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…, unlike anything you find in standard async MySQL replication. It is my belief that the …This prevents any node in the synchronous replication group from getting too far behind the others …by keeping the window between new transactions being committed and the oldest unapplied transaction small. The …
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…. Percona Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate notable drops… we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still has performance issues around mutexes and…_file_size = 2000M innodb_log_files_in_group = 2 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size=128M innodb…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…100M:autoextend innodb_flush_log_at_trx_commit = 2 innodb_flush_method = O_DIRECT innodb…log_file_size = 2000M innodb_log_files_in_group = 2 innodb_file_per_table = true … –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…/1000, $K) ON DUPLICATE KEY UPDATE k=VALUES(k)+k; COMMIT; So this workload produces SEQUENTIAL inserts into Primary Key, that…_log_at_trx_commit = 1 innodb_buffer_pool_size = 36G innodb_log_file_size = 4G innodb_log_files_in_group = 2 innodb… = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-related options are…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…-time=7200 –max-requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration (configuration A) appears below: #####fixed… innodb_flush_log_at_trx_commit = 1 innodb_log_file_size = 1G innodb_log_files_in_group = 2 innodb_purge_threads = 1…
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…
