Uploaded image for project: 'Jackrabbit Oak'
  1. Jackrabbit Oak
  2. OAK-6187

Index usage analysis (which index was used when and how)

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: query
    • Labels:
      None

      Description

      In order to reduce space usage, unused indexes should be removed or trimmed. Trimmed, because an index definition might contain "too much" (specially Lucene indexes, which index multiple properties and can be very large).

      One solution is to

      • log each query (avoiding duplicates),
      • include which indexes were used,
      • from that generate the minimum index definitions,
      • compared with existing indexes, get the list of unused indexes and index features since day X.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                thomasm Thomas Mueller
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: