Categories
Products
Technologies
Top Rated docs

December 14, 2020

What is a Query Outlier and How to Fix It

The MySQL database workload is determined by the number of queries that it processes. There are several situations in which MySQL slowness can originate. The first possibility is if there are any queries that are...

May 14, 2020

pt-query-digest Alternatives – MySQL Query Management & Monitoring with ClusterControl

When your database workload is over stressed, you first want to look at what queries are running in an attempt to see the pattern of the query. Is it write heavy? Read heavy? Where is...

February 25, 2020

How to Identify PostgreSQL Performance Issues with Slow Queries

When working with OLTP (OnLine Transaction Processing) databases, query performance is paramount as it directly impacts the user experience. Slow queries mean that the application feels unresponsive and slow and this results in bad conversion...

February 7, 2020

How to Identify MySQL Performance Issues with Slow Queries

Performance issues are common problems when administering MySQL databases. Sometimes these problems are, in fact, due to slow queries. In this blog, we'll deal with slow queries and how to identify these. Checking Your Slow...

December 20, 2019

Maximizing Database Query Efficiency for MySQL – Part Two

This is the second part of a two-part series blog for Maximizing Database Query Efficiency In MySQL. You can read part one here. Using Single-Column, Composite, Prefix, and Covering Index Tables that are frequently receiving...

December 19, 2019

Maximizing Database Query Efficiency for MySQL – Part One

Slow queries, inefficient queries, or long running queries are problems that regularly plague DBA's. They are always ubiquitous, yet are an inevitable part of life for anyone responsible for managing a database.  Poor database design...

October 27, 2016

Webinar Replay: Completing the MySQL Query Tuning Trilogy: Working With Optimizer & SQL tuning

Thanks to everyone who participated in this week’s webinar on working with optimizer and SQL tuning. In this session, Krzysztof Książek, Senior Support Engineer at Severalnines, discussed how execution plans are calculated. He also took...

September 29, 2016

Webinar Replay: MySQL Query Tuning Part 2 – Indexing and EXPLAIN

We’ve just completed Part 2 of our webinar trilogy on MySQL Query Tuning this week and if you didn’t get the chance to join us for the live sessions (or would like to watch them...

September 1, 2016

Webinar Replay: MySQL Query Tuning – Process & Tools

Many thanks to everyone who participated in this week’s first part of our webinar trilogy on MySQL Query Tuning. This time we looked at the process and tools to consider when tuning MySQL queries. It...

October 22, 2015

Optimizer Hints for Faster MySQL Query Execution

MySQL uses a cost-based optimizer to determine the best way to execute a query. It usually does a great job, but not all the time. There are different reasons for that. In some cases, it...

October 19, 2015

Using Explain to Improve SQL Query Performance

When it comes to the query tuning, EXPLAIN is one the most important tool in the DBA’s arsenal. Why is a given query slow, what does the execution plan look like, how will JOINs be...

August 26, 2015

Analyzing Your SQL Workload Using pt-query-digest

In our previous post, we discussed the different ways to collect data about slow queries - MySQL offers slow log, general log and binary log. Using tcpdump, you can grab network traffic data - a...

Subscribe below to be notified of fresh posts