[MDEV-23123] add last_used column to information_schema.index_statistics Created: 2020-07-08  Updated: 2023-11-30

Status: Open
Project: MariaDB Server
Component/s: Information Schema
Fix Version/s: None

Type: New Feature Priority: Major
Reporter: Richard Stracke Assignee: Ralf Gebhardt
Resolution: Unresolved Votes: 0
Labels: None


 Description   

Add last_used column in information_schema.index_statistics

To check, if an index will ever used , a column last_used would be helpful.

Alternatives like
https://mariadb.com/kb/en/performance-schema-table_io_waits_summary_by_index_usage-table/
is only temporary and not permanent.

Column should be of type date and only be updated, if different from current day to avoid too much load.


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