Log in

Try out our automatic query analyzer

You can now submit slow queries directly to our optimization engine for instant analysis

We’ve created an online tool to assist you with query performance tuning. Based on the SQL text, the execution plan and schema details, the engine will provide:

  • Costly operations observed
  • Recommendations to mitigate them

It follows the 5 tuning points framework. You can read more about it here

Supported versions are MySQL / Percona Server >= 5.7 and MariaDB >=10.5.

How to use it?

There are two ways to submit your queries for optimization:
Tuning Wizard web tool

(Manual and simpler. Most suitable for standard users)

Python module

(Talk directly to our API. Recommended for advanced users)

Make sure no sensitive data appears on the query you submit for optimization!
Even though a valid query is needed for the optimization engine to work properly, only submit cases where non-sensitive / test values are passed

Using the Tuning Wizard web tool

Submit your slow queries for optimization in 3 simple steps. Our web tool will guide you through the process.

When performance issues are detected, it will ask you to provide an email address to send the report generated.

You will need:
  • A MySQL client to run queries (phpMyAdmin, MySQL Workbench, mysql command line, etc)
  • A database user with enough privileges to execute the query to optimize (don’t worry, we don’t need to actually run the query!)
Show me how!
  • I use phpMyAdmin

  • I use MySQL Workbench

  • I use MySQL command line (mysql)
Using a different database client?

No worries! You can still submit your queries for as long as you have a tool to submit queries to your database server.

Open the Tuning Wizard web tool and follow the instructions carefully. The web tool will give you the queries you need to execute. Once you have the result, paste it on the box below and go to the next step. If you have any doubts, don’t hesitate to reach out! Our contact info is at the bottom of the page.

What is my database name?

The database name (also referred to “schema”) is a container where all your application tables and objects live.

When using a SQL editor or on the command line, you switch between databases using the USE command

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| airportdb          |
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
5 rows in set (0.00 sec)

mysql> use airportdb
Database changed
mysql>

On most database client applications, you select a database by clicking on the different database icons on the left panel.

In this case, the database name is “airportdb”

Using the Tuning Wizard python module

If you are looking to send a batch of queries or just looking to automate query submission, using the python module is a better option. It provides a simple interface to interact directly with the TuningWizard REST API.

In this case, when performance issues are detected, it will return a JSON document similar to this.

Based on the SQL text of the query, the module will connect to your database server to retrieve the execution plan, together with table information and stats.

We do not retrieve or sample data inside tables.

You will need:

A computer that:

  • Runs python 3.7 (it’ll probably work with higher versions but we didn’t test it yet)
  • Has the required Python modules installed
  • Has access to the database server where the slow queries were found
  • An access token
Show me how!

Detailed instructions can be found in the collector module repository but in a nutshell, these are the steps:

  1. Download the python collection module from our repository
  2. Install the required python modules
  3. Create an account and retrieve your token
  4. Create and execute the optimization job
  5. Profit!