Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-17929

Optimizer trace support for different parts of the server

    XMLWordPrintable

Details

    Description

      This task is for checking how optimizer trace uses different parts of the server.

      Done:

      • Condition transformation (DONE)
      • KEYUSE objects (DONE)
      • Range access (DONE)

      Not yet handled:

      • EITS: condition selectivities computed for each table (TODO, see below)
      • "Late" ORDER BY optimization (less-defined TODO, see some notes below)
      • Join optimization tracing (TODO: how to do it?)
      • Derived table merging
      • Conversion of subqueries into semi-joins
      • Table elimination

      Attachments

        Issue Links

          Activity

            People

              varun Varun Gupta (Inactive)
              psergei Sergei Petrunia
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 1d 6.5h
                  1d 6.5h

                  Git Integration

                    Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.