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

Optimizer trace: print more details about semi-join optimization

    XMLWordPrintable

Details

    Description

      This is to track this improvement
      http://lists.askmonty.org/pipermail/commits/2019-August/013945.html

      revision-id: 31815d37666d3ca9fae2df45b99138e1c4507bab (mariadb-10.4.7-33-g31815d37666)
      		 
      parent(s): efb8485d85b19a2a729310adc6779ca649198f29
      		 
      author: Sergei Petrunia
      		 
      committer: Sergei Petrunia
      		 
      timestamp: 2019-08-25 11:03:19 +0300
      		 
      message:
      		 
       
      		 
      MDEV-6111: Optimizer Trace: add tracing for semi-join optimizations
      		 
       
      		 
      Added:
      		 
      - "semijoin_strategy_choice" element (actions in advance_sj_state(), name
      		 
        matches the name in MySQL)
      		 
       
      		 
      - semijoin_table_pullout element.

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-6111 optimizer trace

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              psergei Sergei Petrunia
              psergei Sergei Petrunia
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.