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

Allow for immutable session variables

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      In MariaDB server, the session variables typically obtain their values from the global ones; also typically, the session user has the right to change the values of the session variables.

      In certain cases, such a change may be highly undesired; a good example would be a regression when a previously working value for a performance-related variable now leads to a server crash; in this case, a user, often unknowingly, may bring down the whole server by merely repeating a known stanza for speeding up its queries. A real-life case is MDEV-21554.

      This ticket request the implementation of a system variable (which the should be immutable at session level) and which should contain a list of other system variables which are not allowed to be modified at session level (either by any user or, at least, by users without a SUPER or similar "powerful" privilege). Such a variable will allow the MariaDB DBA to configure certain "dangerous" variables with suitable values which the regular session user will not be allowed to change.

      Attachments

        Activity

          People

            Unassigned Unassigned
            assen.totin Assen Totin (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.