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

Add option for default local schema when I_S is queried

    XMLWordPrintable

Details

    • Task
    • Status: In Review (View Workflow)
    • Major
    • Resolution: Unresolved
    • 11.2
    • None
    • None

    Description

      If you have many thousands of databases, each with tables and an application you have no control over runs a query on I_S.COLUMNS or TABLES this can cause a significant amount of disk access which does not perform well.

      In many cases all that is really needed is the output for the current default schema. This is particularly true for hosting environments where it is typically a schema per application and you do not have control over the queries being executed by the application.

      The proposed solution is a new server variable with both a global and local option. When enabled I_S.COLUMNS and TABLES will only scan the current default schema if an explicit schema has not been provided in the WHERE condition.

      Attachments

        Issue Links

          Activity

            People

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