You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Sudheesh Katkam (JIRA)" <ji...@apache.org> on 2015/03/11 18:06:38 UTC

[jira] [Commented] (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:comment-tabpanel&focusedCommentId=14357211#comment-14357211 ] 

Sudheesh Katkam commented on DRILL-2275:
----------------------------------------

On review board: https://reviews.apache.org/r/31938/

> 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: Sudheesh Katkam
>            Priority: Critical
>             Fix For: 0.9.0
>
>
> 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   |
> +------------+------------+--------------+------------+------------+



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)