… (we are adding one in 5.5.31), looking for optimizations with HAProxy to account for high connection rates, and using…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… SQL can produce an infinite variety of queries. The query optimizer analyzes queries for common patterns the MySQL designers know can… amount of engineer-years spent developing and testing the query optimizer. The developers have to make a decision about which query… to refactor manually. There could also be some cases where optimizing a query automatically would be more costly than just running…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… nothing wrong with a virtual-machine approach, but for the optimal production deployment you want two identical physical boxes with at…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… performance schema, online DDL and several other InnoDB and query optimizer improvements. However, I plan to focus on a series of… of this redundancies could be necessary, depending on the query optimizer and the MySQL version, we always recommend to check manually the optimizations proposed by Percona Toolkit. The MySQL server, of course, cannot…
Comment: ZFS on Linux and MySQL
May 29, 2013 By 17 Comments
… that the ZFS on Linux implementation has not yet been optimized for performance. As the project matures we can expect performance…
Comment: ZFS on Linux and MySQL
May 27, 2013 By 17 Comments
… performance penalities associated with CoW. Now, they have their own optimizations for this (like larger btrfs metadata block size etc.). b…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…. The SSB The SSB tests a database’s ability to optimize queries for a star schema. A star schema presents some unique challenge to the database optimizer. The SSB benchmark consists of four sets of queries. Each…
Post: Webinar: SQL Query Patterns, Optimized
May 20, 2013 By Leave a Comment
…, I’ll present Percona’s next webinar, “SQL Query Patterns, Optimized.” Based on my experiences solving tough SQL problems for Percona… built-in methods to analyze them for optimal query efficiency. The discussion will cover optimizer reports, query profiling, and session status to…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… list when creating read views. However, the more general descriptors optimization in Percona Server showed fairly close results in our tests… to cause much confusion. Even though the read-only transactions optimization in MySQL 5.6 virtually eliminates contention on the mutex… on our tests setup and clarifies the scope of descriptors optimization. Server Configuration: [mysqld] user=root port=3306 innodb_status_file…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… it were using SSD storage or to just use an optimized HDD storage configuration? After creating a vCache device with the… this configuration B. The next one contained four SSD-specific optimizations based partially on some earlier work that I’d done…’d determined that configuration C appeared to produce the most optimal results, I moved on to reviewing FlashCache performance versus that…
