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

Slow queries: ability to track them via JMX

    XMLWordPrintableJSON

Details

    Description

      Slow queries (that traverse many nodes, load many nodes in memory, and those that don't use an index) are currently logged. It would be better if there is a way to retrieve at least the number of slow queries (for example from the last seconds / minutes / hours / days), if there were any. Plus maybe the queries themselves, and the type of problem / how severe the problem was.

      Attachments

        Issue Links

          is duplicated by

          Improvement - An improvement or enhancement to an existing feature or task. OAK-6076 Ensure tracking of slow queries includes the full execution time including getting result nodes

          • Major - Major loss of function.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. OAK-6783 Slow queries JMX bean: sort by rows, not time

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          relates to

          Improvement - An improvement or enhancement to an existing feature or task. OAK-6807 Query Recorder

          • Major - Major loss of function.
          • Closed

          Activity

            People

              thomasm Thomas Mueller
              thomasm Thomas Mueller
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: