Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-1452

Add Phoenix client-side logging and capture resource utilization metrics



    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 4.3.1, 4.4.0
    • None
    • None


      For performance testing and tuning of features that use Phoenix and for production monitoring it would be really helpful to easily be able to extract statistics about Phoenix's client-side Thread Pool and Queue Depth usage to help with tuning and being able to correlate the impact of tuning these 2 parameters to query performance.

      For global per JVM logging one of the following would meet my needs, with a preference for #2:
      1. A simple log line that that logs the data in ThreadPoolExecutor.toString() at a configurable interval
      2. Exposing the ThreadPoolExecutor metrics in PhoenixRuntime or other global client exposed class and allow client to do their own logging.

      In addition to this it would also be really valuable to have a single log line per query that provides statistics about the level of parallelism i.e. number of parallel scans being executed. I don't full explain plan level of data but a good heuristic to be able to track over time how queries are utilizing the thread pool as data size grows etc.


        1. wip.patch
          28 kB
          Samarth Jain
        2. PHOENIX-1452.patch
          44 kB
          Samarth Jain
        3. PHOENIX-1452_v4.patch
          57 kB
          Samarth Jain
        4. PHOENIX-1452_v3.patch
          45 kB
          Samarth Jain
        5. PHOENIX-1452_v2.patch
          47 kB
          Samarth Jain

        Issue Links



              samarthjain Samarth Jain
              jfernando_sfdc Jan Fernando
              1 Vote for this issue
              10 Start watching this issue