Tag: indexes

Performance

Four Ways MySQL Executes GROUP BY

In this blog post, I’ll look into four ways MySQL executes 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 execution time.  …

Performance

How to choose the best indexes for MySQL query and database optimization

Many of our users, developers and database administrators, keep asking our team about EverSQL’s indexing recommendations algorithm. So, we decided to write about it.   Tip: Do not click here if all your SQL queries are as fast as a lightning!   This tutorial won’t detail all the internals of the  algorithm, but rather try …

Performance

MySQL Query Performance: Not Just Indexes

  In this blog post, I’ll look at whether optimizing indexing is always the key to improving MySQL query performance (spoiler, it isn’t). As we look at MySQL query performance, our first concern is often whether a query is using the right indexes to retrieve the data. This is based on the assumption that finding the data …