Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-4397

Log table scans.

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Logging, Querying
    • Labels:
      None

      Description

      If a query or a command (such as count) is doing a table scan, we should note that in the logs explicitly.

      In addition, we should add a table scans counter for both queries and commands to the server status results. That way, we can graphs table scans in MMS. This would help us diagnose these kinds of problems without having to look at the logs.

      If it's difficult to determine exactly what qualifies as a table scan, I'd recommend a simple heuristic. For instance, we could log whenever nscanned > 10n and when nscanned > 1000.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              david.storch David Storch
              Reporter:
              kbanker Kyle Banker
              Participants:
              Votes:
              2 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: