[MDEV-24388] Implement schema_unused_indexes in performance_schema or sys schema Created: 2019-11-14  Updated: 2021-09-30  Resolved: 2020-12-10

Status: Closed
Project: MariaDB Server
Component/s: Performance Schema
Fix Version/s: N/A

Type: Task Priority: Critical
Reporter: Geoff Montee (Inactive) Assignee: Oleksandr Byelkin
Resolution: Duplicate Votes: 2
Labels: Compatibility

Issue Links:
PartOf
is part of MDEV-9077 bundle sys schema Closed
Relates
relates to MDEV-6114 merge new P_S instrumentation and tab... Closed
relates to MDEV-9067 performance_schema from 5.7 Closed

 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.

 Comments   
Comment by Oleksandr Byelkin [ 2020-09-02 ]

No, I can not add estimation, I know close to nothing about the task, probably will need 1 day to get the task so can give the estimation

Comment by Oleksandr Byelkin [ 2020-11-25 ]

it can be done in several hours in 10.5+ (question of adding one view). And Actually I'd prefer ot in CS 10.6.

In early versions it can involve back-porting 5.7 information schemy which a huge project.

Comment by Sergei Golubchik [ 2020-12-10 ]

This is part of MDEV-9077

Generated at Thu Feb 08 09:29:36 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.