How We Simplified MySQL Slow Query Analysis

Over the past year, we've been diligently developing solutions to some of the most common database management challenges you shared with us. Questions like "How can I identify slow queries?", "Why is my database experiencing high latency?" and "How can I pinpoint which queries are consuming the most system resources?" have been at the forefront of our innovation efforts.

Since April 2023, we've built a waitlist for users interested in query optimization and analytics. We've had countless conversations with many of you and dug into the best software out there. Our goal was to create a solution that offered the simplest and most effective user experience possible to solve MySQL query issues.

Today, we are proud to announce the launch of the Query Analytics! This new feature helps you quickly identify slow queries and those that demand significant system resources.

To start using It, click Load Data in the Query Analytics block of the Releem Dashboard.

This new addition to Releem simplifies the process of query analysis by allowing you to:

• Identify Slow Queries

Find the Query Analytics Block on the dashboard. Click the 'Avg. Execution Time' column heading. This will sort your top 100 queries in order, with the slowest-executing queries listed at the top.

• Identify High-Impact Queries

Find the Query Analytics Block on the dashboard. Click the 'Load on Total Time' column heading. This will sort your top 100 queries in order, with the queries that are using the most resources overall listed at the top.

• Inspect Query Details

Click the "Inspect" button to view the query statement in full

With a simple click of “Load Data", Releem Cloud Platform initiates a task for Releem Agent to gather data from MySQL Performance Schema for analysis.

Every minute Releem Agent checks tasks from Releem Cloud Platform and after receiving task starts collecting information from MySQL Performance Schema.

Once collected, you can view the data on your top 100 queries directly within the dashboard. This reflects all activity since the last server restart.