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

add last_used column to information_schema.index_statistics

    XMLWordPrintable

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

          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-33152 Add QUERIES to INDEX_STATISTICS

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            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.