Tag - indexes

MongoDB Explain – Using PMM-QAN for MongoDB Query Analytics

MongoDB 4.0 Features Webinar

In this blog post, we will walk through PMM-Query Analytics for MongoDB. We will see how to analyze MongoDB query performance; review the initial parameters that we need to check; and find out how to compare MongoDB query performance with and without indexes with the help of EXPLAIN plan.
The Percona Monitoring and Management QAN (PMM-QAN) dashboard […]

Read more

Four Ways MySQL Executes GROUP BY

MySQL 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. 
The […]

Read more

MySQL Query Performance: Not Just Indexes

Running MySQL in Kubernetes

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 is […]

Read more

Webinar Thursday, October 19, 2017: What You Need to Get the Most Out of Indexes – Part 2

Indexes

Join Percona’s Senior Architect, Matthew Boehm, as he presents What You Need to Get the Most Out of Indexes – Part 2 webinar on Thursday, October 19, 2017, at 11:00 am PDT / 2:00 pm EDT (UTC-7).
Register Now

Proper indexing is key to database performance. Finely tune your query writing and database performance with tips […]

Read more

Webinar Wednesday July 12, 2017: MongoDB Index Types – How, When and Where Should They Be Used?

MongoDB Index Types

Join Percona’s Senior Technical Services Engineer, Adamo Tonete as he presents MongoDB Index Types: How, When and Where Should They Be Used? on Wednesday, July 12, 2017 at 11:00 am PDT / 2:00 pm EDT (UTC-7).
Register Now

MongoDB has 12 index types. Do you know how each works, or when you should use each of […]

Read more