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

Move some global variables to SQL_CATALOG

    XMLWordPrintable

Details

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

    Description

      This task should be enhanced to list all global variables that makes sense to be made
      catalog specific.

      The current list is:

      • query_cache status (on/off)
      • Log_to_csv_event_handler
      • opt_userstat_running
      • event_scheduler

      Like with STATUS VARIABLES, https://mariadb.com/kb/en/catalog-status-variables/, the GLOBAL and SESSION variables will be extended with CATALOG and SERVER variables.

      When using catalogs you have:

      • SERVER - Server-wide variables
      • CATALOG & GLOBAL - Catalog specific variables (which some can be server-wide and not changeable by the tenant/catalog user)
      • SESSION - Session specific variables.

      When not using catalogs you have:

      • SERVER, CATALOG and GLOBAL - Server-wide variables
      • SESSION - Session specific variables.

      Attachments

        Issue Links

          is part of

          Task - A task that needs to be done. MDEV-31542 Add multi-tenancy catalogs to MariaDB

          • Major - Major loss of function.
          • Stalled

          Activity

            People

              Unassigned Unassigned
              monty Michael Widenius
              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.