… while providing unique features for MySQL backup. The new 2.1.1 GA version offers improved performance, enterprise-grade security, and lower… removed from Percona XtraBackup. After being deprecated in previous version, option –remote-host has been completely removed in Percona XtraBackup 2…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… other magic that helps single node writing in PXC to perform better. gcs.fc_factor If fc_limit controls when flow… control in a master/slave cluster might be: mysql> set global wsrep_provider_options=”gcs.fc_limit=500; gcs.fc_master_slave… large receive queue might be the result of some brief performance issue on a given node, or perhaps the effect of…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually… for “performance” reasons when data durability isn’t as crucial. This is fine as long as you weigh both options carefully. But…
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
… all about performance. Suppose I have a 2TB database, but maybe my working set is only 500GB. What are my options for achieving the best performance? I could by a ton of RAM, but… card, not Virident, but there’s a comparison in TPCC-MySQL performance between that card and a traditional SSD – the PCIe card…
Post: Percona Monitoring Plugins 1.0.3 for MySQL now available
April 23, 2013 By 4 Comments
…. Changelog: * MySQL 5.6 compatibility for InnoDB graphs (bug 1124292) * Added performance data to Nagios plugins (bugs 1090145, 1102687) * Added UTC option to pmp-check-mysql-replication-delay to be…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
Swapping has always been something bad for MySQL performance but it is even more important for HA systems. It …, you need to interleave the allocation of memory for the MySQL process using the numactl utility, drop the file cache and… the innodb buffer pool with the innodb_buffer_pool_populate option. That solves most of the swapping issues but… I recently…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… Server with TokuDB, of course I wanted to compare InnoDB performance vs TokuDB. I have a particular workload I’m interested… how both InnoDB and TokuDB performs if PK is (`id`,`hid`,`mid`). This also will affect select performance, so we will need… = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-related options are all defaults, as I understand…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets of MySQL…
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… to waste time and lose performance because of this. I am one of those people. When MySQL 5.6 spends a lot…_and_free_block you are not going to have good performance results. Prior to 5.6 foreground threads were responsible for… option to fix the stalls and that change makes 5.1 competitive with 5.6 (http://mysqlha.blogspot.com/2013/02/mysql…
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… to waste time and lose performance because of this. I am one of those people. When MySQL 5.6 spends a lot…_and_free_block you are not going to have good performance results. Prior to 5.6 foreground threads were responsible for… option to fix the stalls and that change makes 5.1 competitive with 5.6 (http://mysqlha.blogspot.com/2013/02/mysql…
