[
https://issues.apache.org/jira/browse/DRILL-2275?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Chun Chang resolved DRILL-2275.
-------------------------------
Resolution: Fixed
> need implementations of sys tables for drill memory and threads profiles
> ------------------------------------------------------------------------
>
> Key: DRILL-2275
> URL: https://issues.apache.org/jira/browse/DRILL-2275
> Project: Apache Drill
> Issue Type: Task
> Components: Metadata
> Reporter: Zhiyong Liu
> Assignee: Chun Chang
> Priority: Critical
> Fix For: 0.9.0
>
> Attachments: DRILL-2275.1.patch.txt, DRILL-2275.2.patch.txt,
> DRILL-2275.3.patch.txt, DRILL-2275.4.patch.txt, DRILL-2275.5.patch.txt,
> DRILL-2275.6.patch.txt, DRILL-2275.7.patch.txt
>
>
> 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:
> {code}
> +------------+------------+--------------+------------+------------+
> | drillbit | total_sys_memory |heap_size | direct_alloc_memory |
> +------------+------------+--------------+------------+------------+
> | node1:port1 | 24596676k | 15200420k | 1012372k |
> +------------+------------+--------------+------------+------------+
> | node2:port2 | 24596676k | 15200420k | 2012372k |
> +------------+------------+--------------+------------+------------+
> {code}
> 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:
> {code}
> +------------+------------+--------------+------------+------------+
> | drillbit | pool_name | total_threads | busy_threads |
> +------------+------------+--------------+------------+------------+
> | node1:port1 | pool1 | 8 | 2 |
> +------------+------------+--------------+------------+------------+
> | node2:port2 | pool2 | 10 | 5 |
> +------------+------------+--------------+------------+------------+
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
