[MDEV-23255] add last_used column in information_schema.index_statistics Created: 2020-07-08  Updated: 2020-08-05

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

Type: Task Priority: Major
Reporter: Richard Stracke Assignee: Unassigned
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:21:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.