… compare the use of subqueries/multiple joins vs. multiple queries (e.g. temp tables)? For performance, it’s hard to make a… subqueries) and we saw in my presentation that sometimes these perform worse and sometimes better than another equivalent solution. If you… solution for randomly choosing rows involves some compromise, either of performance, or of accuracy of randomness. The ORDER BY RAND() solution…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
… in maintenance mode before the update, see bellow how to perform this action [root@percona1 percona]# yum update -y [root@percona1...kernel config... [ OK ] Starting gfs_controld… [ OK ] Unfencing self… [ OK ] Joining fence domain… [ OK ] Starting Pacemaker Cluster Manager: [ OK ] [root@percona2…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… little data. It seems that InnoDB performs better when a larger number of rows must be joined together (Q4.1, Q4.2… using MyISAM for everything!. MyISAM may be good for raw performance, but there are limitations which MyISAM imposes that are difficult… operations and is not ACID compliant. MyISAM and InnoDB may perform differently under concurrency, which this benchmark does not cover. I…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
… CTO, will talk about Percona XtraDB Cluster, Percona Xtrabackup and Performance and Improvements and new Features in MySQL 5.6 Garrick… can’t afford to miss… 
So register now! Please also join the Portland MySQL Meetup group for more MySQL-focused events…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… does NOT set an lower bound on performance, only a upper bound. The best performance you can expect is modifying a given…_groups table to define the relationship between them. When someone joins a group, you run a transaction that adds the relationship… update much faster. I see this tuning very frequently for “performance” reasons when data durability isn’t as crucial. This is…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… – SSD config) which shows the most consistent performance. The others all have assorted performance drops scattered throughout the graph. We see the… time-based flushing enabled actually produces better and more consistent performance than vCache without time-based flushing, but even at its… = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size…
Post: Webinar: SQL Query Patterns, Optimized
May 20, 2013 By Leave a Comment
…, query profiling, and session status to measure performance. The query patterns will include: Exclusion Join Random Selection Greatest-Per-Group Dynamic Pivot Relational Division Please register for this webinar and join me next Friday…
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… = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size…
Post: Learn About MySQL 5.6 at the Percona Live MySQL Conference
April 3, 2013 By Leave a Comment
5.6 has redefined MySQL performance and usability. Some great talks at the Percona Live MySQL … MySQL Conference: “MySQL 5.6: Performance Benchmarks, Tuning, and ‘Best’ Practices” by Dmitri Kravtchuk, MySQL Performance Architect “MySQL 5.6: What’s… be the liveliest, most engaging Percona Live event yet. Please join us in Santa Clara, April 22-25 for the Percona…
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
…’s New in InnoDB” Dmitri Kravtchuk, MySQL Performance Architect, Oracle Topic: “MySQL 5.6: Performance Benchmarks, Tuning, and ‘Best’ Practices” Luís Soares… order of the cloud and big data. If you can join us in Santa Clara for the Percona Live MySQL Conference…
