Buy Percona ServicesBuy Now!

MongoDB Explain – Using PMM-QAN for MongoDB Query Analytics

 | June 26, 2018 |  Posted In: .PMM QAN, EXPLAIN, MongoDB, Percona Monitoring and Management, PMM

MongoDB explain plan with PMM-QAN

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

Webinar Thu 6/21: How to Analyze and Tune MySQL Queries for Better Performance

 | June 20, 2018 |  Posted In: EXPLAIN, Insight for DBAs, Insight for Developers, MySQL, MySQL 101, Technical Webinars

database query tuning

Please join Percona’s MySQL Database Administrator, Brad Mickel as he presents How to Analyze and Tune MySQL Queries for Better Performance on Thursday, June 21st, 2018, at 10:00 AM PDT (UTC-7) / 1:00 PM EDT (UTC-4). Register Now   Query performance is essential in making any application successful. In order to finely tune your queries […]

Read More

This Week in Data with Colin Charles 18: Percona Live Call For Papers and a MongoDB 3.6 Overview

 | December 8, 2017 |  Posted In: Events and Announcements, EXPLAIN, MongoDB, MySQL, Percona Live, PostgreSQL

Colin Charles

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. I highly recommend submitting to the CFP for Percona Live Santa Clara 2018 even though it only closes December 22 2017. By the 3rd week of December, i.e. before the CfP closes, it is very […]

Read More

Introduction to Troubleshooting Performance – Troubleshooting Slow Queries webinar: Q & A

 | May 20, 2016 |  Posted In: EXPLAIN, MySQL, Technical Webinars

InnoDB Troubleshooting

In this blog, I will provide answers to the Q & A for the Troubleshooting Slow Queries webinar. First, I want to thank you for attending the April 28 webinar. The recording and slides for the webinar are available here. Below is the list of your questions that I wasn’t able to answer during the webinar, with […]

Read More

EXPLAIN FORMAT=JSON wrap-up

 | April 6, 2016 |  Posted In: EXPLAIN, EXPLAIN FORMAT=JSON is cool!, JSON, MySQL

EXPLAIN FORMAT=JSON

This blog is an EXPLAIN FORMAT=JSON wrap-up for the series of posts I’ve done in the last few months. In this series, we’ve discussed everything unique to EXPLAIN FORMAT=JSON. I intentionally skipped a description of members such as table_name, access_type  or select_id, which are not unique. In this series, I only mentioned in passing members that […]

Read More

EXPLAIN FORMAT=JSON: nested_loop makes JOIN hierarchy transparent

 | February 29, 2016 |  Posted In: EXPLAIN, EXPLAIN FORMAT=JSON is cool!, JSON, MySQL

EXPLAIN FORMAT=JSON

Once again it’s time for another EXPLAIN FORMAT=JSON is cool! post. This post will discuss how EXPLAIN FORMAT=JSON allows the nested_loop command to make the JOIN operation hierarchy transparent. The regular EXPLAIN  command lists each table that participates in a  JOIN  operation on a single row. This works perfectly for simple queries:

You can see […]

Read More

EXPLAIN FORMAT=JSON: cost_info knows why optimizer prefers one index to another

 | February 22, 2016 |  Posted In: EXPLAIN, EXPLAIN FORMAT=JSON is cool!, JSON, MySQL

Percona Server 5.7 performance improvements

Time for another entry in the EXPLAIN FORMAT=JSON is cool! series of blog posts. This time we’ll discuss how using EXPLAIN FORMAT=JSON allows you to see that cost_info  knows why the optimizer prefers one index to another. Tables often have more than one index. Any of these indexes can be used to resolve query. The optimizer has […]

Read More

EXPLAIN FORMAT=JSON: buffer_result is not hidden!

 | February 9, 2016 |  Posted In: EXPLAIN, EXPLAIN FORMAT=JSON is cool!, JSON, MySQL

MongoDB System Tuning

Time for another entry in the EXPLAIN FORMAT=JSON is cool! series. Today we’re going to look at how you can view the buffer result using JSON (instead of the regular EXPLAIN command. Regular EXPLAIN does not identify if SQL_BUFFER_RESULT was used at all. To demonstrate, let’s run this query:

Now, let’s compare it to this query:

Notice there […]

Read More

EXPLAIN FORMAT=JSON knows everything about UNIONs: union_result and query_specifications

 | January 29, 2016 |  Posted In: EXPLAIN, EXPLAIN FORMAT=JSON is cool!, JSON, MySQL

Ready for another post in the EXPLAIN FORMAT=JSON is Cool series! Great! This post will discuss how to see all the information that is contained in optimized queries with UNION using the union_result and query_specifications commands.   When optimizing complicated queries with UNION, it is easy to get lost in the regular EXPLAIN  output trying to identify which part […]

Read More