The analysis of requests in this service — is not replacement to the EXPLAIN command which is oriented to performance review of request, and is rather an addition which analyzes request from the point of view of its syntax.
After registration on the website to the address https://tools.percona.com, you there are available two services:
"Configuration wizard" and "Query adviser". Let's consider them in more detail
Configuration wizard — allows to receive a ready configuration of my.cnf in which your working conditions are considered on the basis of step-by-step poll (only 7 steps).
Example of the screen with request:
So the screen with a final configuration looks (on a screenshot part of my.cnf of the file):
Query adviser — allows having specified to SQL to receive request of the recommendation about its optimization from the point of view of syntax (once again I will emphasize that service does not analyze the execution plan of request in view of lack of data on a configuration of the server and existence of indexes).
Example of request:
SELECT p.shopId, p.typeId, MIN(p.price) AS price FROM modelPrice p, modelItem i WHERE p.modelItemId = i.id AND i.modelId = '5250' AND p.price > 0 GROUP BY p.shopId, p.typeId
Recommendations of service:
and more in detail
All configurations and analyses of SQL queries remain in dashboard for the subsequent analysis and use.
In conclusion it would be desirable to note that despite existence of a large number of the detailed guides and articles to the MySQL setup, these services can are useful as to beginners, and experienced developers as systematize in a compact form of the recommendation data in documentation.
This article is a translation of the original post at habrahabr.ru/post/204522/
If you have any questions regarding the material covered in the article above, please, contact the original author of the post.
If you have any complaints about this article or you want this article to be deleted, please, drop an email here: email@example.com.
We believe that the knowledge, which is available at the most popular Russian IT blog habrahabr.ru, should be accessed by everyone, even though it is poorly translated.
Shared knowledge makes the world better.