XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.14.0, 5.0.0
    • Component/s: None
    • Labels:
      None

      Description

      One useful feature of other database systems is the query log. It allows the DBA to review the queries run, who's run them, time taken, &c. This serves both as an audit and also as a source of "ground truth" for performance optimization. For instance, which columns should be indexed. It may also serve as the foundation for automated performance recommendations/actions.

      What queries are being run is the first piece. Have this data tied into tracing results and perhaps client-side metrics (PHOENIX-1819) becomes very useful.

      This might take the form of clients writing data to a new system table, but other implementation suggestions are welcome.

        Attachments

        1. PHOENIX-2715.patch
          99 kB
          Ankit Singhal
        2. PHOENIX-2715_master.patch
          100 kB
          Ankit Singhal
        3. PHOENIX-2715_master_V2.patch
          110 kB
          Ankit Singhal
        4. PHOENIX-2715_master_V1.patch
          103 kB
          Ankit Singhal

          Issue Links

            Activity

              People

              • Assignee:
                ankit@apache.org Ankit Singhal
                Reporter:
                ndimiduk Nick Dimiduk
              • Votes:
                0 Vote for this issue
                Watchers:
                14 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: