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

add last_used column in information_schema.index_statistics

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • 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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            Richard Richard Stracke
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.