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

add last_used column to information_schema.index_statistics

Details

    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

        Issue Links

          Activity

            Transition Time In Source Status Execution Times
            Julien Fritsch made transition -
            Open Needs Feedback
            1350d 49m 2
            Richard Stracke made transition -
            Needs Feedback Open
            16d 18h 58m 2
            Ralf Gebhardt made transition -
            Open Closed
            27m 9s 1

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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