Percona service for creating optimal configuration of MySQL servers and analyzing SQL queries
I suggest to get acquainted with the service from the company Percona, which allows you to properly configure the MySQL server based on specific conditions of use and analyze the used SQL queries for errors and shortcomings.
Analysis of requests in this service is not a substitute for the EXPLAIN command, which is focused on analyzing the performance of the request, but rather an addition that analyzes the request from the point of view of its syntax.
')
After registering on the website at https://tools.percona.com , two services become available to you:
"Configuration wizard" and "Query adviser". Consider them in more detail.
Configuration wizard - allows, based on a step-by-step survey (only 7 steps), to get a ready-made my.cnf configuration in which exactly your working conditions are taken into account.
An example of a screen with a request:
This is the screen with the final configuration (in the screenshot part of the my.cnf file):
Query adviser - allows specifying a SQL query to get recommendations for its optimization in terms of syntax (I emphasize again that the service does not analyze the query execution plan due to the lack of server configuration data and the presence of indices).
Request example:
Service recommendations:
and more fully
All SQL query configurations and analyzes are saved in the dashboard for later analysis and use.
In conclusion, I would like to note that despite the presence of a large number of detailed guides and articles on configuring MySQL, these services can be useful for both beginners and experienced developers, since they systematize the data in the documentation in a compact form of recommendations.
Analysis of requests in this service is not a substitute for the EXPLAIN command, which is focused on analyzing the performance of the request, but rather an addition that analyzes the request from the point of view of its syntax.
')
Percona Company Information
Percona is an open source software company specializing in MySQL Support, Consulting, Managed Services, and Training. The company was founded in 2006 by Peter Zaitsev and Vadim Tkachenko [1] [2] and is headquartered in Durham, North Carolina. MySQL Backup Service in June 2014 as part of its Managed Services. [3] MySQL Performance blog. [4] MySQL at [5] named "Percona Live" in Silicon Valley and London. The company's founders have also published the O'Reilly book "High Performance MySQL". [6]
After registering on the website at https://tools.percona.com , two services become available to you:
"Configuration wizard" and "Query adviser". Consider them in more detail.
Configuration wizard - allows, based on a step-by-step survey (only 7 steps), to get a ready-made my.cnf configuration in which exactly your working conditions are taken into account.
An example of a screen with a request:
This is the screen with the final configuration (in the screenshot part of the my.cnf file):
Query adviser - allows specifying a SQL query to get recommendations for its optimization in terms of syntax (I emphasize again that the service does not analyze the query execution plan due to the lack of server configuration data and the presence of indices).
Request example:
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 Service recommendations:
and more fully
All SQL query configurations and analyzes are saved in the dashboard for later analysis and use.
In conclusion, I would like to note that despite the presence of a large number of detailed guides and articles on configuring MySQL, these services can be useful for both beginners and experienced developers, since they systematize the data in the documentation in a compact form of recommendations.
Source: https://habr.com/ru/post/204522/
All Articles