Developers Club geek daily blog

1 year, 2 months ago
I suggest to examine service from the Percona company which allows to configure correctly a server MySQL configuration on the basis of specific conditions of use and to analyze the used SQL queries on existence of errors and defects.

Service from the Percona company for creation of an optimum configuration of MySQL of servers and the analysis of SQL queries

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.



Information on the Percona company
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. The company launched a MySQL Backup Service in June 2014 as part of its Managed Services. [3] The company contributes to the MySQL community through its blog site, MySQL Performance blog. [4] The company also hosts annual MySQL user conferences [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 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:

Service from the Percona company for creation of an optimum configuration of MySQL of servers and the analysis of SQL queries

So the screen with a final configuration looks (on a screenshot part of my.cnf of the file):

Service from the Percona company for creation of an optimum configuration of MySQL of servers and the analysis of SQL queries

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:

Service from the Percona company for creation of an optimum configuration of MySQL of servers and the analysis of SQL queries

and more in detail

Service from the Percona company for creation of an optimum configuration of MySQL of servers and the analysis of SQL queries

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: sysmagazine.com@gmail.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.
Best wishes.

comments powered by Disqus