DEV Community

Cover image for December 2024: How Releem Is Making MySQL Monitoring & Performance Tuning Easier
Roman Agabekov
Roman Agabekov

Posted on • Originally published at releem.com

December 2024: How Releem Is Making MySQL Monitoring & Performance Tuning Easier

We’re back with another product update! This month brings significant improvements spanning the Agent, Dashboard, and Platform. We’ve added Schema Checks, released the first version of Releem Agent for Windows, fixed Latency calculations, and improved index recommendations and execution plan analysis.

Image description

Community Contributions

We're always collecting issues and feature requests on our GitHub. Here's where you can contribute:

  • Issues – If you encounter any problems or bugs, report them here.
  • Feature Requests – Have an idea to make Releem even better? Share your suggestions here.

Updates to Releem Portal

Added Schema Checks

Releem can now analyze Primary keys, Table Engines, Collation, Character Sets, Duplicate Indexes, and Unused Indexes. These automated checks can identify critical schema issues. Learn more here.

Releem Schema Checks

Improved SQL Query Optimization Reports

Your SQL query optimization reports will now include Schema Checks, giving you a more complete picture of performance and schema-related issues in one place.

Releem SQL Query Optimization Report

Added Security Check for Database End-Of-Life (EOL)

Releem now automatically alerts you when your database version is approaching its End of Life. This helps you stay secure and up-to-date.

Releem Security Checks

More Accurate Latency Metrics

Previously, latency was calculated from the server’s start time, which could make real-time trends hard to follow on long-running servers. Now, latency is recalculated every minute based on the latest queries, making the metrics more responsive and accurate. You might notice a drop in Latency values in your graphs because the data now reflects real-time workloads much more precisely (Issue #266).

The latency graph of Releem's production database

Updates to Releem Platform

Automatic Index Detection and Impact Tracking

After applying a SQL query recommendation, Releem now automatically detects the newly created index and measures its impact on performance. You’ll get an email with the results, and the query will appear in the Query Optimization tab as Optimized.

Releem SQL Query Optimization

Enhanced Query Optimization**

The new update introduces smarter index recommendations and execution plan analysis. It addresses complex OR conditions, better index merging, and smarter column ordering.

Image description

Updates to Releem Agent

Releem Agent for Windows

It’s finally here! If you manage databases on Windows, you can now use Releem to optimize your MySQL performance. If you want to get started just sign up at https://releem.com.

Database-Specific Query Optimization for SaaS

Added a new option to optimize queries for specific databases. SaaS teams managing many customer databases can now test improvements on a subset of databases before rolling them out to all customers (Issue #376).

One-Click Configuration Updates for AWS RDS

Now users on AWS RDS can update Parameter Groups directly from the Releem Dashboard. No server restart required. Check out the updated AWS RDS setup guide here.

Top comments (0)