Following my previous blog post focusing
talks at MySQL Connect, let us review today the sessions focusing on the
The goal of MySQL optimizer is to take a SQL
query as input and produce an optimal execution plan for the query. This
session presents an overview of the main phases of the MySQL optimizer and the
primary optimizations done to the query. These optimizations are based on a
combination of logical transformations and cost-based decisions. Examples of
optimization strategies the presentation covers are the main query
transformations, the join optimizer, the data access selection strategies, and
the range optimizer. For the cost-based optimizations, an overview of the cost
model and the data used for doing the cost estimations is included.
Many optimizer features have been added into
MySQL 5.6. This session provides an introduction to these great features.
Multirange read, index condition pushdown, and batched key access will yield
huge performance improvements on large data volumes. Structured explain,
explain for update/delete/insert, and optimizer tracing will help users analyze
and speed up queries. And last but not least, the session covers subquery
optimizations in Release 5.6.
This BoF presents common techniques for query
optimization, covers what is new in MySQL 5.6, and provides a discussion forum in
which attendees can tell the MySQL optimizer team which optimizations they
would like to see in the future.
MySQL Release 5.6 contains several
improvements in the query optimizer that create improved performance for
complex queries. This presentation looks at how MySQL 5.6 improves the
performance of many of the queries in the DBT-3 benchmark. Based on the
observed improvements, the presentation discusses what makes the specific
queries perform better in Release 5.6. It describes the relevant new
optimization techniques and gives examples of the types of queries that will
benefit from these techniques.
The EXPLAIN command of MySQL has long been a
very useful tool for understanding how MySQL will execute a query. Release 5.6
of the MySQL database offers several new additions that give more-detailed
information about the query plan and make it easier to understand at the same
time. This presentation gives an overview of new EXPLAIN features: structured
EXPLAIN in JSON format, EXPLAIN for INSERT/UPDATE/DELETE, and optimizer tracing.
Examples in the session give insights into how you can take advantage of the
new features. They show how these features supplement and relate to each other
and to classical EXPLAIN and how and why the MySQL server chooses a particular
registered yet? You can still save US$ 300 over the on-site fee – Register