You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Chun Chang (JIRA)" <ji...@apache.org> on 2015/07/17 23:36:04 UTC
[jira] [Reopened] (DRILL-2275) need implementations of sys tables
for drill memory and threads profiles
[ https://issues.apache.org/jira/browse/DRILL-2275?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chun Chang reopened DRILL-2275:
-------------------------------
Assignee: Chun Chang (was: Sudheesh Katkam)
reopen to verify fix.
> 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)