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

Optimizer trace should have selectivities collected via sampling

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.6
    • 12.3.2
    • Optimizer
    • None
    • Not for Release Notes
    • Q1/2026 Server Development, Q2/2026 Server Maintenance

    Description

      Encountered this in MDEV-35280.

      Optimizer trace doesn't print selectivities of conditions that were computed via sampling (optimizer_use_condition_selectivity=5).

      Make it be printed there.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35280 Performance Issue on TPC-H Q2 (Fixed with sampling)

          • Major - Major loss of function.
          • Confirmed

          Activity

            People

              psergei Sergei Petrunia
              psergei Sergei Petrunia
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 3h
                  3h
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 2.5h Time Not Required
                  2.5h

                  Git Integration

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