After four years of relentless development, Releem has grown into more than just a database tuning tool – it’s the fulfillment of our vision to simplify and automate the database management process which used to be a maze of complex metrics, query analyzis and time-intensive manual work. Our goal has always been to make database management intuitive, automate, and – most importantly – actionable.

We started with automated variable tuning, helping you, fine-tune configurations with ease. But we didn’t stop there.

We’re excited to announce that Automatic SQL Query Optimization and Index Recommendations are now live for Releem Premium users running MySQL, MariaDB and Percona.

With our new feature, Releem's Query Optimization feature streamlines the process of identifying and improving inefficient queries in your MySQL database. Here's how it works:

Releem analyzes your top 100 queries and the top 100 slowest queries each week. When an inefficient query is detected by Releem, it will be automatically added to the Query Optimization tab under the Queries and Schema block. The query will have a status of New, indicating that it requires optimization. You can see an example of this process in the provided screenshot.

Once a new inefficient query is identified, you will receive a detailed email summarizing the inefficient queries along with actionable index recommendations.. This ensures that you are always informed about the performance of your database, even when you’re not logged into the Releem platform. Please refer to the screenshot for an example of the email notification.

To access the recommendations for optimizing the inefficient query, navigate to the Query Optimization tab in the Queries and Schema section. Click on the query, and Releem will display a set of tailored recommendations to help improve its performance. See the screenshot for a visual guide on how to access these recommendations.

To implement recommendations just copy CREATE INDEX statement, connect to the database server and execute CREATE INDEX statement.

Once you’ve implemented the recommended changes, Releem will monitor the impact of the optimization. After the changes have been applied, Releem will send a follow-up report via email detailing the results of the optimization, including any improvements in query performance.

If you'd like to optimize other queries from the Query Analytics tab, simply click on the query you wish to optimize. In the Query Inspection popup that appears, click the "Get Recommendations" button to receive optimization suggestions for that query.

1. Sign Up: Create your Releem account if you haven't already.
2. Install Releem Agent: Follow our guide to install the Releem Agent with enabled SQL Query Optimization.
3. Upgrade to Premium: Move to a Premium plan to access the Automatic SQL Query Optimization feature.

Releem will analyze your queries once a week, so you can see continuous improvements.