… 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: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… optimizer enhancements in MySQL 5.6 and MariaDB 5.5. This blog post is targeted at the join related optimizations introduced in the optimizer. These optimizations are available in both MySQL 5.6 and…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… is the second blog post in the series of blog posts leading up to the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. This blog post is aimed at the optimizer enhancement Multi Range…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… meeting last week, so we are a little slow to blog about this and acknowledge the great work that has gone… and MySQL 5.6 optimizer improvements, and both of them look very good indeed. Peter will present the results in an “optimizer standoff… fix, and MySQL 5.6 offers microsecond timestamp support, as well as a lot of optimizer improvements. Even the standard MySQL 5.5…
Comment: Joining many tables in MySQL - optimizer_search_depth
April 23, 2012 By 6 Comments
… ago, when I was just hired at MySQL. The assumptions about what are typical MySQL may have been true then in 2004…”. Is this what your blog boils down to? At the time when I implemented the so-called “greedy optimizer“, I did some…! = 5040, while 8! = 40320. The worst-case complexity of MySQL‘s join optimizer is N!. The goal of this choice was to…
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….
Page: About This Blog
May 3, 2006 By 48 Comments
… MySQL I took part in many performance optimization projects, including DVD Store Benchmark for CT competition, where I’ve implemented most of optimizations… our company team page. We have published biographies of other MySQL Performance Blog contributers at Percona Team Page
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…
Post: An update on Percona Live MySQL Conference & Expo 2012
November 30, 2011 By 2 Comments
… a cadre of the core MySQL developers to submit talks about what is new in MySQL, the MySQL roadmap for the future, and… such as how replication works, new features in the query optimizer, the storage engine architecture, and so on. The point is… with MySQL — don’t try too hard, just be yourself and try to be helpful to your audience. And please blog, tweet…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
… enough database related forums, mailing lists or blogs you probably heard complains about MySQL being unable to handle more than 1.000… selectivity might show benefit from using indexes. In fact even MySQL optimizer currently does not take it into account. For In memory… large data sets. In MySQL single query runs as single thread (with exeption of MySQL Cluster) and MySQL issues IO requests one by…
