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

          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-11655 Transactional data dictionary

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. MDEV-17581 Data dictionary

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-20609 Full table scan in INFORMATION_SCHEMA.PARAMETERS/ROUTINES

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          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.