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

    • Task
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • None
    • 0.9.0
    • Metadata
    • 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.7.patch.txt
          58 kB
          Sudheesh Katkam
        2. DRILL-2275.6.patch.txt
          58 kB
          Sudheesh Katkam
        3. DRILL-2275.5.patch.txt
          56 kB
          Sudheesh Katkam
        4. DRILL-2275.4.patch.txt
          55 kB
          Sudheesh Katkam
        5. DRILL-2275.3.patch.txt
          54 kB
          Sudheesh Katkam
        6. DRILL-2275.2.patch.txt
          54 kB
          Sudheesh Katkam
        7. DRILL-2275.1.patch.txt
          47 kB
          Sudheesh Katkam

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: