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

Feature Request: Allow for indexes to be created on the information_schema tables

    XMLWordPrintable

Details

    Description

      Hello,
      I have a customer who has run into an issue when they have data they want to query in information_schema tables but the tables have 100,000's+ records in them. The more records that get added the worse their query performs.
      Could it be possible to set up a way to allow indexes be created against tables in the information_schema? Whether it be allowing

      alter table add index...

      or some way to specify it in the MariaDB config file.
      These indexes should not be created by default, and only by users who feel they need them.

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              kyle.hutchinson Kyle Hutchinson
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.