Tosska SQL Tuning Expert (TSEM™) for MySQL®

It is not just another SQL tuning tool

There are not many SQL tuning tools for MySQL database, but most of them are focused on plan visualization or query plan analysis, it is not helpful if you don’t have in-depth SQL tuning knowledge and are not willing to spend extra effort to tune a SQL apart from your daily duties. If you are eager for getting one-button-solution tool that can tune a SQL statement automatically without the need of your intervention, then Tosska SQL Tuning Expert for MySQL may be your only choice.

Expensive SQL tuning effort by human expert
It may be up to days or weeks for a DBA or experienced SQL developer to tune a problematic SQL statement. SQL tuning is a very skillful job that not many developers are able to carry out in an enterprise. Should such expensive and valuable time be saved and used for other even more productive tasks inside a company?

World’s Leading A.I. SQL Rewrite technology for MySQL database
Manually rewriting SQL syntax to tune a SQL statement is commonly adopted by experienced developers and DBAs, but the effort and cost to rewrite a SQL statement is quite expanse. It requires an in-depth SQL tuning knowledge developer to spend hours or even days to rewrite and test a problematic SQL statement, and the tuning result might not be the best among most of potential SQL rewrites due the limitation of manual effort.

Tosska A.I. SQL Rewrite Engine is the world’s leading machine SQL Rewrite technology for MySQL database. It not only saves developer’s time to rewrite a problematic SQL statement to make it faster, but it also explores the potential best SQL syntax that even an experienced developer cannot discover. Moreover, Tosska A.I. rewritten SQL syntax can work with our Hints-injection algorithm to further explore more potential query plans that even most experienced developers cannot achieve.

A 100 times faster SQL rewrite is generated on the right hand side.

On-the-job SQL training for in-house SQL developers
An SQL Query is used to retrieve data from your database. However, there may be multiple SQL queries that generate the same results but with different levels of efficiency. An inefficient query can drain the database resources, reduce the database speed or even result in a loss of service for other users. So it is very important to improve the in-house SQL developers with solid SQL writing skills. A short term SQL training course may be helpful, but it is not sustainable to resolve all daily SQL writing challenges. Tosska SQL Tuning Expert inbuilt SQL Rewrite Engine can help developers to correct minor mistakes and generate many semantically-equivalent SQL rewrites for user to compare with their original SQL syntax. Users can observe the SQL syntax, query plans, data distribution and SQL performance of those semantically-equivalent SQL to select the best SQL syntax to replace their original SQL statement. With the on-the-job SQL training process, it not only guarantees the good SQL quality produced during development cycle, but it also improves the in-house developers’ SQL writing skills through the process.

Generate semantically equivalent SQL alternatives with "Rewrite Only” Tuning Method

Tosska proprietary Tree Plan format for your easy understanding
Traditional MySQL tabular explain plan and visual explain plan are the standard tools for developer to understand how MySQL SQL optimizer is processing the input SQL statement, while the tabular explain plan lacking in hierarchical operation steps, visual explain plan is too focused on hierarchical structure without enough information displaying on screen. There is another fatal problem that a complex visual explain plan is normally too big to fit in a window, it is very difficult for the user to comprehend the overall structure of the query plan without scrolling around the window.

Traditional Tabular Plan

Visual Plan

Tosska proprietary tree plan has a market-leading Explain Plan function for MySQL, it not only has rich statistical information like what is provided by Tubular Explain from MySQL, but it also has a heirachical structure like what is displaying in the visual plan. The beauty is that all such informmation can be displayed in a small window for easy reading.

Tosska Tree Plan

What is machine tuning for SQL statements?
Tosska SQL Tuning Expert is a SQL tuning tool that optimizes your SQL statements without the need of user’s involvement. The product will give you the ultimate SQL performance solution by just point and click. What you have to do is to input your problematic SQL statement into the product and press a button. You don’t have to do analysis, guessing or manual testing during the entire SQL tuning process. The improved SQL statement will be benchmarked with your original SQL statement side by side without doubt.

SQL Tuning Summary

The machine tuning for SQL statements is a proprietary technology invented by Tosska to mimic a human expert SQL tuning process, in which the engine tries every possible effective SQL rewrite and MySQL Hints combinations for a SQL statement to improve the execution speed within the given quota. As the permutation of SQL rewrites and Hints combinations to a SQL statement is so huge, it is impossible for a human expert to accomplish it for complex SQL statements within a short time. Furthermore, there is also no way for a DBA or developer to guarantee that the best solution is found after a lot of manual trials and errors.

Best solution without trial and error
With Tosska SQL Tuning Expert for MySQL, you no longer need to rewrite or try every possible Hints combination manually for a problematic SQL statement to explore potential better performance execution plans, since all those hard tasks are released by our embedded AI engine. Our intelligent engine will help you to find every possible rewrite and Hints combination to improve your SQL speed without the need of your intervention. You just sit back, relax, and wait for the best SQL alternative to come up on your screen.

Best alternative found after automatic SQL tuning

Provide even better than a human expert’s solution
Tuning SQL is a time-consuming job that requires in-depth knowledge on SQL tuning skill and most SQL developers are not trained to accomplish this job apart from their daily development tasks. Furthermore, there is no way for a DBA to explore all alternative execution plans within a short time. The following screenshot shows that Tosska SQL Tuning Expert can explore thousands of SQL alternatives in just a few minutes that may require a human expert months’ effort to do so.

Automatic SQL tuning in process

After benchmarking partial or all SQL alternative execution plans, the best SQL alternative will be displayed with Original SQL statement side by side on the screen. The process is fully automatic without the need of user’s involvement and the result is the best out of thousands of potential execution plans that MySQL can generate for the SQL statement. This exhaustive search and test process is impossible to be accomplished even by a human expert.

Best syntax rewrite with hints injected is found after benchmarking

Uncompromised SQL tuning solution within manageable time
It is known that the longer you spend on the SQL tuning process, the more chance you may get a better SQL alternative. It is also true in Tosska SQL Tuning Expert that the user can adjust the Intelligent Level to control the time spent on a specific SQL statement according to the complexity of your SQL statement. For complex SQL statements with huge potential execution plans, users can allocate more resources and time to explore the ultimate performance solution for the SQL.

The predefined intelligent level is 5 sets of “Maximum number of SQL to investigate” setting to control the size of search space. The larger the search space, the more chance the engine can find a better SQL solution for a problematic SQL statement.
Furthermore, individual user-defined “Max no. of SQL Rewrites to investigate” and “Max no. of SQL Hints applications to investigate” options are also available for experienced users to tackle complicated SQL performance.
Intelligent Level option

Free Download | Buy License

Before installing Tosska SQL Tuning Expert (TSEM™) for MySQL®, please make sure your system meets the following minimum hardware and software requirements:

CPU 1.8 GHz Processor
Memory 2 GB of RAM minimum, 4 GB of RAM recommended
Hard Disk Space 200 MB of disk space for 32-bit installation
400 MB of disk space for 64-bit installation
Operating System Microsoft Windows® 7 32-bit and 64-bit
Microsoft Windows® 10 32-bit and 64-bit
.NET Framework Microsoft .NET Framework 4.5.2
Database Server MySQL database 5.6 or higher

Click to view Tosska SQL Tuning Expert (TSEM™) for MySQL 2.0.0 Release Notes

Click to view Tosska SQL Tuning Expert (TSEM™) for MySQL 1.1.0 Release Notes