Here at the MySQL Performance Blog, we’ve been discussing the several new features that MySQL 5.6 brought: GTID-based replication, InnoDB… on the query optimizer and the MySQL version, we always recommend to check manually the optimizations proposed by Percona Toolkit. The MySQL server, of…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… the Star Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default… Peter blogged about the importance of performance at low concurrency. The SSB The SSB tests a database’s ability to optimize queries…. A star schema presents some unique challenge to the database optimizer. The SSB benchmark consists of four sets of queries. Each…
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
…on Oracle MySQL, Percona Server, and MariaDB during the Percona Live MySQL Conference. Percona Live MySQL …What’s New With the Project” Sergei Petrunia, Optimizer Developer, and Colin Charles, Chief Evangelist, MariaDB… cannot make it this year, watch this blog following the conference and we’ll …
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… TRANSACTION READ ONLY MySQL transactions created by a non-locking SELECT statement in the autocommit mode. The relevant optimization in MySQL 5.6… the perfect case for read-only optimization in MySQL 5.6 and as you can see MySQL 5.6 shines in this benchmark… currently in the alpha stage. We are going to blog about other MySQL performance improvements introduced in our latest Percona Server release…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option and variable reference table. But just as frequently, I want to look up blog… Opened_tablesblogpercona.commanual optimizer_prune_levelblogpercona.commanual optimizer_search_depthblogpercona.commanual optimizer_switchblogpercona.commanual partitionblogpercona….
Post: MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown
March 14, 2013 By 2 Comments
… the webinar: “Learn How MySQL 5.6 Makes Query Optimization Easier” for more tips on the 5.6 optimizer[/caption] While preparing the… features of the newer MySQL optimizer: the Index Condition Pushdown Optimization, or ICP, which we have previously discussed on our blog. It was the… technique is available, this is always preferred over the ICP optimization: mysql> EXPLAIN SELECT role_id FROM cast_info WHERE role_id…
Post: MySQL optimizer: ANALYZE TABLE and Waiting for table flush
February 27, 2013 By 3 Comments
The MySQL optimizer makes the decision of what execution plan to use based …. In InnoDB these statistics are calculated automatically, check the following blog post for more information: http://www.mysqlperformanceblog.com/2011/10… better execution plan for another query we run ANALYZE TABLE: mysql> analyze table t; +——–+———+———-+———-+ | Table | Op | Msg_type | Msg_text | +——–+———+———-+———-+ | test…
Post: Percona Welcomes MySQL 5.6!
February 25, 2013 By Leave a Comment
… many optimizer and replication features. We’re happy to congratulate MySQL development team at Oracle with making this release happen. In this blog… release which will contain all MySQL 5.6 features, as well as Percona’s additions and optimizations. MySQL 5.6 rolls many improvements… and optimizations. Learn More About MySQL 5.6 If you’re interested in learning more about MySQL 5.6, the Percona Live MySQL Conference…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6…
Post: Looking for High Performance MySQL Interns
September 2, 2007 By 1 Comment
…opening at MySQL Performance Blog. We’re looking for Intern position (with limited compensation) to work on project of MySQL …MySQL Architecture, Unix/Linux Operating Systems and Hardware Performance Optimization, Performance Analysis, benchmarking and load testing plus get your name known in MySQL…
