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