[jira] [Updated] (OAK-4026) Index and query analysis tool

["Thomas Mueller (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/OAK-4026?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Thomas Mueller updated OAK-4026:
--------------------------------
    Description: 
Defining the right indexes is quite tricky. We should have a tool that lists duplicate indexes, large indexes, indexes with incorrect or questionable configuration.

The tool should also be able to analyze query log files and suggest (best case) which indexes to create or at least which queries are slow and need indexes.

The tool could be part of oak-run, so that it can be run against an existing repository. The output should be plain text or JSON (to be consumed by a GUI tool).

  was:
Defining the right indexes is quite tricky. We should have a tool that lists duplicate indexes, large indexes, indexes with incorrect or questionable configuration.

The tool should also be able to analyze query log files and suggest (best case) which indexes to create or at least which queries are slow and need indexes.


> Index and query analysis tool
> -----------------------------
>
>                 Key: OAK-4026
>                 URL: https://issues.apache.org/jira/browse/OAK-4026
>             Project: Jackrabbit Oak
>          Issue Type: Bug
>          Components: query
>            Reporter: Thomas Mueller
>
> Defining the right indexes is quite tricky. We should have a tool that lists duplicate indexes, large indexes, indexes with incorrect or questionable configuration.
> The tool should also be able to analyze query log files and suggest (best case) which indexes to create or at least which queries are slow and need indexes.
> The tool could be part of oak-run, so that it can be run against an existing repository. The output should be plain text or JSON (to be consumed by a GUI tool).



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)