Post Profile

MySQL 8.0: Descending Indexes Can Speed Up Your Queries

In this blog, we’ll discuss descending indexes in MySQL 8.0. Summary The future MySQL 8.0 will (probably) have a great new feature: support for index sort order on disk (i.e., indexes can be physically sorted in descending order). In the MySQL 8.0 Labs release (new optimizer preview), when you create an index you can specify the […]
read more


Related Posts

used_columns: EXPLAIN FORMAT=JSON tells when you should use covered indexes

Programming / Database Development : MySQL Performance Blog

In the “MySQL Query tuning 101” video, Alexander Rubin provides an excellent example of when to use a covered index. On slide 25, he takes the query [crayon-566f4b8a45b16830193099-i/] and adds the index [crayon-566f4b8a45b2754532375...

3 ways MySQL uses indexes

Programming / Database Development : MySQL Performance Blog

I often see people confuse different ways MySQL can use indexing, getting wrong ideas on what query performance they should expect. There are 3 main ways how MySQL can use the indexes for query execution, which are not mutually excl...

MySQL indexing 101: a challenging single-table query

Programming / Database Development : MySQL Performance Blog

We discussed in an earlier post how to design indexes for many types of queries using a single table. Here is a real-world example of the challenges you will face when trying to optimize queries: two similar queries, but one is perf...

Building Indexes by Sorting In Innodb (AKA Fast Index Creation)

Programming / Database Development : MySQL Performance Blog

Innodb can indexes built by sort since Innodb Plugin for MySQL 5.1 which is a lot faster than building them through insertion, especially for tables much larger than memory and large uncorrelated indexes you might be looking at 10x ...

How to pick indexes for order by and group by queries

Programming / Database Development : mySQL DBA

First some of the things that you need to use and understand Explain Syntax Order by Optimization Group by OptimizationUpdate: Updated errors.Now some details that are usually missed. GROUP BY does sorting unless you tell mysql not ...


Copyright © 2016 Regator, LLC