You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Chris Westin (JIRA)" <ji...@apache.org> on 2015/03/04 20:31:38 UTC
[jira] [Updated] (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 ]
Chris Westin updated DRILL-2275:
--------------------------------
Assignee: Sudheesh Katkam (was: Chris Westin)
> 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: Functions - Drill
> 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)