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

Add information about packed addon fields in ANALYZE FORMAT=JSON

Details

    Description

      For filesort, the mode used for sorting needs to be mentioned in ANALYZE format=json

      The modes are:
      1) sort_key, rowid
      2) sort_key, addon_fields
      3) sort_key, packed_addon_fields

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-6915 Allow packed keys and packed values of non-sorted fields in the sort buffer

          • 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
            varun Varun Gupta (Inactive) made changes -
            Description For filesort, the mode used for sorting needs to be mentioned in ANALYZE format=json

            The modes are:
            1) sort_key, rowid
            2) sort_key, addon_fields
            3) sort_key, packed_addon_fields

            varun Varun Gupta (Inactive) made changes -
            Fix Version/s 10.5.2 [ 24030 ]
            Fix Version/s 10.5 [ 23123 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 104402 ] MariaDB v4 [ 134195 ]

            People

              varun Varun Gupta (Inactive)
              varun Varun Gupta (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.