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

New defaults for eq_range_index_dive_limit

Details

    Description

      As discussed in MDEV-17484, the value for eq_range_index_dive_limit needs to be raised to 200.

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-15253 Default optimizer setting changes for MariaDB 10.4

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

          Activity

            Ascending order - Click to sort in descending order
            varun Varun Gupta (Inactive) created issue -
            varun Varun Gupta (Inactive) made changes -
            Field Original Value New Value
            Fix Version/s 10.4 [ 22408 ]
            varun Varun Gupta (Inactive) made changes -
            Description As discussed in [MDEV-17484|https://jira.mariadb.org/browse/MDEV-17484], the value for eq_range_index_dive needs to be raised to 200.
            varun Varun Gupta (Inactive) made changes -
            Description As discussed in [MDEV-17484|https://jira.mariadb.org/browse/MDEV-17484], the value for eq_range_index_dive needs to be raised to 200.
            		As discussed in [|https://jira.mariadb.org/browse/MDEV-17484], the value for eq_range_index_dive needs to be raised to 200.
            varun Varun Gupta (Inactive) made changes -
            Description As discussed in [|https://jira.mariadb.org/browse/MDEV-17484], the value for eq_range_index_dive needs to be raised to 200.
            		As discussed in [MDEV-17484|https://jira.mariadb.org/browse/MDEV-17484], the value for eq_range_index_dive_limit needs to be raised to 200.
            varun Varun Gupta (Inactive) made changes -
            Summary New defaults for eq_range_index_dive_limit in 10.4 New defaults for eq_range_index_dive_limit
            varun Varun Gupta (Inactive) made changes -
            Assignee Varun Gupta [ varun ]
            psergei Sergei Petrunia added a comment -

            Hi varun,

            Please add --echo # comments before the ANALYZE statements in the testcase. The comments should explain what exactly the test is expecting to see in the ANALYZE output (type=range, rows about ... this many values, because ... ).

            Ok to push after this is addressed.

            psergei Sergei Petrunia added a comment - Hi varun , Please add --echo # comments before the ANALYZE statements in the testcase. The comments should explain what exactly the test is expecting to see in the ANALYZE output (type=range, rows about ... this many values, because ... ). Ok to push after this is addressed.
            psergei Sergei Petrunia made changes -
            varun Varun Gupta (Inactive) made changes -
            Fix Version/s 10.4.3 [ 23230 ]
            Fix Version/s 10.4 [ 22408 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 92456 ] MariaDB v4 [ 133858 ]

            People

              varun Varun Gupta (Inactive)
              varun Varun Gupta (Inactive)
              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.