Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-2275

need implementations of sys tables for drill memory and threads profiles

    XMLWordPrintableJSON

    Details

    • Type: Task
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.9.0
    • Component/s: Metadata
    • Labels:
      None

      Description

      In order to check drill state information, the following tables are to be implemented:

      1. Memory: a query such as

      select * from sys.drillmemory;

      should return a result set like the following:

      +------------+------------+--------------+------------+------------+
      |    drillbit    | total_sys_memory   |heap_size | direct_alloc_memory |
      +------------+------------+--------------+------------+------------+
      | node1:port1       | 24596676k         | 15200420k         | 1012372k   |
      +------------+------------+--------------+------------+------------+
      | node2:port2       | 24596676k         | 15200420k         | 2012372k   |
      +------------+------------+--------------+------------+------------+
      

      2. Threads:
      For each node in a cluster, we need counts of threads of the drillbits. A query like this:

      select * from sys.drillbitthreads;

      should return a result set like the following:

      +------------+------------+--------------+------------+------------+
      |    drillbit    | pool_name   | total_threads | busy_threads |
      +------------+------------+--------------+------------+------------+
      | node1:port1       | pool1         | 8         | 2   |
      +------------+------------+--------------+------------+------------+
      | node2:port2       | pool2         | 10         | 5   |
      +------------+------------+--------------+------------+------------+
      

        Attachments

        1. DRILL-2275.1.patch.txt
          47 kB
          Sudheesh Katkam
        2. DRILL-2275.2.patch.txt
          54 kB
          Sudheesh Katkam
        3. DRILL-2275.3.patch.txt
          54 kB
          Sudheesh Katkam
        4. DRILL-2275.4.patch.txt
          55 kB
          Sudheesh Katkam
        5. DRILL-2275.5.patch.txt
          56 kB
          Sudheesh Katkam
        6. DRILL-2275.6.patch.txt
          58 kB
          Sudheesh Katkam
        7. DRILL-2275.7.patch.txt
          58 kB
          Sudheesh Katkam

          Issue Links

            Activity

              People

              • Assignee:
                cchang@maprtech.com Chun Chang
                Reporter:
                zhiyongliu Zhiyong Liu
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: