Post Profile






Four Ways to Execute MySQL GROUP BY

In this blog post, I’ll look into four ways to execute MySQL GROUP BY.  In my previous blog post, we learned that indexes or other means of finding data might not be the most expensive part of query execution. For example, MySQL GROUP BY could potentially be responsible for 90% or more of the query […]
read more

share

Related Posts


Asynchronous Query Execution with MySQL 5.7 X Plugin

Programming / Database Development : MySQL Performance Blog

In this blog, we will discuss MySQL 5.7 asynchronous query execution using the X Plugin. Overview MySQL 5.7 supports X Plugin / X Protocol, which allows (if the library supports it) asynchronous query execution. In 2014, I published...

Indexing 101: Optimizing MySQL queries on a single table

Programming / Database Development : MySQL Performance Blog

I have recently seen several cases when performance for MySQL queries on a single table was terrible. The reason was simple: the wrong indexes were added and so the execution plan was poor. Here are guidelines to help you optimize v...

Easy query metrics with MySQL Performance Schema

Programming / Database Development : MySQL Performance Blog

The MySQL Performance Schema exposes so much data that it’s not trivial to learn, configure, and use. With recently released Percona Agent 1.0.11 you can get query metrics – like min, max, and average query execution time – with a f...

Pipelining versus Parallel Query Execution with MySQL 5.7 X Plugin

Programming / Database Development : MySQL Performance Blog

In this blog post, we’ll look at pipelining versus parallel query execution when using X Plugin for MySQL 5.7. In my previous blog post, I showed how to useX Plugin for MySQL 5.7 for parallel query execution. The tricks I used to ma...

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...

Comments


Copyright © 2016 Regator, LLC