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

Add optimizer_switch_disabled to show disabled optimizations

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Fix Version/s: 10.9
    • Component/s: Optimizer
    • Labels:
      None

      Description

      @@optimizer_switch has a lot (currently 36) flags. Most of them should be enabled most of the time (ideally we should have all optimizations enabled).

      Currently, it is not easy to check which optimizations are disabled. The idea is to add a @@optimizer_switch_disabled variable which is a view of @@optimizer_switch which lists only the disabled optimizations.

      The variable should be read-only. It should not be possible to specify it in my.cnf.

      The first user will be the crash reporter. Currently, it prints the value of @@optimizer_switch. It should print @@optimizer_switch_disabled instead.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            psergei Sergei Petrunia
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration

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