[ https://issues.apache.org/jira/browse/DRILL-2275?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sudheesh Katkam updated DRILL-2275: ----------------------------------- Attachment: DRILL-2275.4.patch.txt > 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 > > Attachments: DRILL-2275.1.patch.txt, DRILL-2275.2.patch.txt, > DRILL-2275.3.patch.txt, DRILL-2275.4.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: > +------------+------------+--------------+------------+------------+ > | 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)