…bellow how to perform this action [root@percona1... [ OK ] Starting dlm_controld… [ OK ] Tuning DLM kernel config… [ OK ] …MySQL [p_mysql] (unmanaged) p_mysql:0 (ocf::percona:mysql): Master percona1 (unmanaged) p_mysql:1 (ocf::percona:mysql): Slave percona2 (unmanaged) p_mysql:2 (ocf::percona:mysql…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
One major problem in terms of MySQL performance that still stands in the way of InnoDB scalability is … transaction. Why is that a major problem for MySQL scalability? The scan is performed under kernel_mutex (or trx_sys->mutex in… the alpha stage. We are going to blog about other MySQL performance improvements introduced in our latest Percona Server release, stay tuned.
Post: Learn About MySQL 5.6 at the Percona Live MySQL Conference
April 3, 2013 By Leave a Comment
… sessions on MySQL 5.6 at the Percona Live MySQL Conference: “MySQL 5.6: Performance Benchmarks, Tuning, and ‘Best’ Practices” by Dmitri Kravtchuk, MySQL Performance Architect “MySQL 5.6: What’s New in InnoDB” by Sunny Bains, Senior Principal Software Engineer “MySQL 5.6: Redefining…
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
…, Oracle Topic: “MySQL 5.6: What’s New in InnoDB” Dmitri Kravtchuk, MySQL Performance Architect, Oracle Topic: “MySQL 5.6: Performance Benchmarks, Tuning, and ‘Best’ Practices” Luís Soares, Senior Software Engineer, Oracle Topic: “MySQL 5.6…
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… soon as possible. An example configuration tuning flow control in a master/slave cluster might be: mysql> set global wsrep_provider_options… 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… you can update much faster. I see this tuning very frequently for “performance” reasons when data durability isn’t as crucial. This…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…both InnoDB and TokuDB performs if PK is (`id`,`hid`,`mid`). This also will affect select performance, so we …10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-related …settings out-of-box, but I am ready to tune something if there are …
Post: Read Buffers, mmap, malloc and MySQL Performance
September 12, 2007 By 8 Comments
… together with strace) are great tools for MySQL Performance analyses. Too many people end tuning on plans and indexes while there well could… done to speed things up here ? Of course you can tune you malloc settings so more buffers are allocated from the… you could just grab one having allocation very quick. Also MySQL should get smarter in terms of which buffer size should…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
… was selecting from MySQL table. Query vas very simple – lookup by primary cache, so this is kind of peak performance MySQL can provide… results and how we can use them for MySQL Performance tuning ? Not surpising associative array cache performs the best, almost 4 times faster than… performs faster than Query Cache if TCP/IP socket is used, but if Unix Socket is used to connect to MySQL MySQL Query…
Post: Announcing Percona Server for MySQL 5.1.68 -14.5
March 15, 2013 By Leave a Comment
…performance and reliability from their MySQL database server. Compare Percona Server to MySQL. Performance Percona Server’s performance…
