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

optimizer trace

Details

    Description

      In MySQL, Optimizer trace is a JSON object recording the execution path through the optimizer, decisions that were made and the reasons for them. See https://dev.mysql.com/doc/internals/en/optimizer-tracing.html

      Users were asking for MariaDB to have a similar feature.

      Attachments

        Issue Links

          blocks

          Task - A task that needs to be done. MDEV-7239 explain index choice

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          includes

          Task - A task that needs to be done. MDEV-17929 Optimizer trace support for different parts of the server

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-17930 Optimizer trace: what's on the execution path when trace=off?

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18117 Crash with Explain extended when using limit rows examined

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-18172 Benchmarking 10.4 for optimizer trace

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18306 Optimizer_trace has invalid JSON near rows_estimation

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-18489 Limit the memory used by the optimizer trace

          • Major - Major loss of function.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-12980 Index hints for loose scan

          • Major - Major loss of function.
          • Confirmed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18670 Document optimizer trace

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-20440 Optimizer trace: print more details about semi-join optimization

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18527 Optimizer trace for DELETE query shows table:null

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18528 Optimizer trace support for multi-table UPDATE and DELETE

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18741 Optimizer trace: multi-part key ranges are printed incorrectly.

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-18822 investigate performance regressions in 10.4

          • Major - Major loss of function.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19160 JSON_DETAILED output unnecessarily verbose (Part Time project)

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-20444 More information regarding access of a table to be printed inside the optimizer_trace

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            serg Sergei Golubchik created issue -
            serg Sergei Golubchik made changes -
            Field Original Value New Value
            Priority Major [ 3 ] Critical [ 2 ]
            serg Sergei Golubchik made changes -
            Labels optimizer
            serg Sergei Golubchik made changes -
            Fix Version/s 10.2.0 [ 14601 ]
            Fix Version/s 10.1.0 [ 12200 ]
            serg Sergei Golubchik made changes -
            Workflow defaullt [ 38927 ] MariaDB v2 [ 42476 ]
            rspadim roberto spadim made changes -
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 42476 ] MariaDB v3 [ 61431 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.2 [ 14601 ]
            jmuchemb Julien Muchembled made changes -
            Alex/AT Alex/AT made changes -
            Comment [ Alas, optimizer w/TokuDB seems to be tremendously broken after 10.1.23.
            The only recommendation I've got is to create a ticket on Percona for that, still not done though.
            Stay on 10.1.23 for now if you want it stable. ]
            julien.fritsch Julien Fritsch made changes -
            julien.fritsch Julien Fritsch made changes -
            cvicentiu Vicențiu Ciorbaru made changes -
            Labels optimizer gsoc18 optimizer
            cvicentiu Vicențiu Ciorbaru made changes -
            Assignee Sergei Petrunia [ psergey ]
            serg Sergei Golubchik made changes -
            Description port optimizer trace from 5.6 In MySQL, Optimizer trace is a JSON object recording the execution path through the optimizer, decisions that were made and the reasons for them. See https://dev.mysql.com/doc/internals/en/optimizer-tracing.html

            Users were asking for MariaDB to have a similar feature.
            varun Varun Gupta (Inactive) made changes -
            Assignee Sergei Petrunia [ psergey ] Varun Gupta [ varun ]
            varun Varun Gupta (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            psergei Sergei Petrunia made changes -
            Attachment screenshot-1.png [ 46685 ]
            psergei Sergei Petrunia made changes -
            Attachment mdev6111-example-trace-from-mysql8.txt [ 46686 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Epic Link PT-76 [ 68557 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Team Server DEV
            psergei Sergei Petrunia made changes -
            psergei Sergei Petrunia made changes -
            varun Varun Gupta (Inactive) made changes -
            Fix Version/s 10.4 [ 22408 ]
            varun Varun Gupta (Inactive) made changes -
            varun Varun Gupta (Inactive) made changes -
            Assignee Varun Gupta [ varun ] Sergei Petrunia [ psergey ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            psergei Sergei Petrunia made changes -
            psergei Sergei Petrunia made changes -
            varun Varun Gupta (Inactive) made changes -
            psergei Sergei Petrunia made changes -
            psergei Sergei Petrunia made changes -
            psergei Sergei Petrunia made changes -
            Assignee Sergei Petrunia [ psergey ] Varun Gupta [ varun ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            varun Varun Gupta (Inactive) made changes -
            Component/s Optimizer [ 10200 ]
            Fix Version/s 10.4.3 [ 23230 ]
            Fix Version/s 10.4 [ 22408 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            greenman Ian Gilfillan made changes -
            psergei Sergei Petrunia made changes -
            psergei Sergei Petrunia made changes -
            psergei Sergei Petrunia made changes -
            psergei Sergei Petrunia made changes -
            varun Varun Gupta (Inactive) made changes -
            marko Marko Mäkelä made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 61431 ] MariaDB v4 [ 132320 ]

            People

              varun Varun Gupta (Inactive)
              serg Sergei Golubchik
              Votes:
              10 Vote for this issue
              Watchers:
              17 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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