Percona service for creating optimal configuration of MySQL servers and analysis of SQL queries

    I suggest that you familiarize yourself with the service from Percona, which allows you to correctly configure the MySQL server based on specific conditions of use and analyze the SQL queries used for errors and omissions.



    Query analysis in this service is not a substitute for the EXPLAIN command, which focuses on query performance analysis, but rather an addition that analyzes the query in terms 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. 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, the MySQL Performance blog. [4] The company also hosts annual MySQL user conferences [5] named "Percona Live" in Silicon Valley and London. The company 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”. Let's consider them in more detail.

    Configuration wizard - allows you to get a ready-made configuration my.cnf based on a step-by-step survey (only 7 steps) which takes into account exactly your working conditions.

    An example of a query screen:



    This is the screen with the final configuration (in the screenshot, part of my.cnf file):



    Query adviser - allows specifying the SQL query to receive recommendations for its optimization from the point of view of syntax (I emphasize again that the service does not analyze the query execution plan because lack of server configuration data and indexes).

    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 deployed.



    All configurations and analyzes of SQL queries are stored in the dashboard for subsequent analysis and use.

    In conclusion, I would like to note that despite the presence of a large number of detailed manuals and articles on configuring MySQL, these services can be useful for both beginners and experienced developers, since they systematize recommendations in the documentation in a compact form.

    Also popular now: