1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

A new MySQL SQL tuning tool

Discussion in 'MySQL' started by Richard To, Apr 14, 2020.

  1. Richard To

    Richard To New Member

    Joined:
    Sep 18, 2017
    Messages:
    17
    Likes Received:
    3
    Trophy Points:
    3
    Gender:
    Male
    Tosska SQL Tuning Expert 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 their 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. Tosska SQL Tuning Expert for MySQL may be your only choice.

    https://tosska.com/tosska-sql-tuning-expert-for-mysql-tsem-free-download/

    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?


    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 is leaking of hierarchical operation steps, visual explain plan is too focused on hierarchical structure without enough information is 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 to the user apprehend the overall structure of the query plan without scrolling around the window.
    More .......
     

    Attached Files:

Share This Page