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

              Assignee:
              serg Sergei Golubchik
              Reporter:
              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.