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

show sysvar's help in I_S tables

Details

    • Task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.1.1
    • OTHER
    • None

    Description

      Every sysvar has an associated help text, but it's only accessible as mysqld --help which is kind of a waste. It would be helpful to show it as a third column in INFORMATION_SCHEMA.GLOBAL_VARIABLES and INFORMATION_SCHEMA.SESSION_VARIABLES. For backward compatibility we'll hide this column if @@old_mode=NO_SYSVAR_HELP.

      Alternatively, we could introduce a new table, say, INFORMATION_SCHEMA.SYSTEM_VARIABLES with all (global and session) variables, without their current values, but with the help, type, valid value range, etc.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-8579 Some sysvars in I_S are missing any meaningful help (comment) text

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            serg Sergei Golubchik created issue -
            serg Sergei Golubchik made changes -
            Field Original Value New Value
            Description Every sysvar has an associated help text, but it's only accessible as {{mysqld --help}} which is kind of a waste. It would be helpful to show it as a third column in {{INFORMATION_SCHEMA.GLOBAL_VARIABLES}} and {{INFORMATION_SCHEMA.SESSION_VARIABLES}}. For backward compatibility we'll hide this column if {{@@old_mode=NO_SYSVAR_HELP}}. Every sysvar has an associated help text, but it's only accessible as {{mysqld --help}} which is kind of a waste. It would be helpful to show it as a third column in {{INFORMATION_SCHEMA.GLOBAL_VARIABLES}} and {{INFORMATION_SCHEMA.SESSION_VARIABLES}}. For backward compatibility we'll hide this column if {{@@old_mode=NO_SYSVAR_HELP}}.

            Alternatively, we could introduce a new table, say, {{INFORMATION_SCHEMA.SYSTEM_VARIABLES}} with all (global and session) variables, without their current values, but with the help, type, valid value range, etc.
            serg Sergei Golubchik made changes -
            Priority Major [ 3 ] Minor [ 4 ]
            serg Sergei Golubchik made changes -
            Assignee Sergei Golubchik [ serg ]
            serg Sergei Golubchik made changes -
            Workflow defaullt [ 39102 ] MariaDB v2 [ 43410 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.1 [ 16100 ]
            Fix Version/s 10.1.0 [ 12200 ]
            serg Sergei Golubchik made changes -
            Priority Minor [ 4 ] Major [ 3 ]
            serg Sergei Golubchik made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            serg Sergei Golubchik made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            serg Sergei Golubchik made changes -
            Component/s OTHER [ 10125 ]
            Fix Version/s 10.1.1 [ 16801 ]
            Fix Version/s 10.1 [ 16100 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 43410 ] MariaDB v3 [ 61886 ]
            elenst Elena Stepanova made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 61886 ] MariaDB v4 [ 132327 ]

            People

              serg Sergei Golubchik
              serg Sergei Golubchik
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.