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

Implement schema_unused_indexes in performance_schema or sys schema

    XMLWordPrintable

    Details

      Description

      The sys schema in MySQL 5.7 and later has the schema_unused_indexes view:

      These views display indexes for which there are no events, which indicates that they are not being used. By default, rows are sorted by schema and table.

      This view is most useful when the server has been up and processing long enough that its workload is representative. Otherwise, presence of an index in this view may not be meaningful.

      The schema_unused_indexes view has these columns:

      • object_schema

      The schema name.

      • object_name

      The table name.

      • index_name

      The unused index name.

      https://dev.mysql.com/doc/refman/5.7/en/sys-schema-unused-indexes.html

      Some users would like this functionality in MariaDB as well.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sanja Oleksandr Byelkin
              Reporter:
              GeoffMontee Geoff Montee
              Votes:
              2 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration