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:38:05 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=14631957#comment-14631957 ]
Chun Chang commented on DRILL-2275:
-----------------------------------
{code}
0: jdbc:drill:schema=dfs.drillTestDirComplexJ> use sys;
+-------+----------------------------------+
| ok | summary |
+-------+----------------------------------+
| true | Default schema changed to [sys] |
+-------+----------------------------------+
1 row selected (0.123 seconds)
0: jdbc:drill:schema=dfs.drillTestDirComplexJ> show tables;
+---------------+-------------+
| TABLE_SCHEMA | TABLE_NAME |
+---------------+-------------+
| sys | boot |
| sys | drillbits |
| sys | memory |
| sys | options |
| sys | threads |
| sys | version |
+---------------+-------------+
6 rows selected (0.223 seconds)
0: jdbc:drill:schema=dfs.drillTestDirComplexJ> select * from memory;
+---------------+------------+---------------+-------------+-----------------+---------------------+-------------+
| hostname | user_port | heap_current | heap_max | direct_current | jvm_direct_current | direct_max |
+---------------+------------+---------------+-------------+-----------------+---------------------+-------------+
| 10.10.30.169 | 31010 | 2067120568 | 4294967296 | 11798941 | 1417670208 | 8589934592 |
| 10.10.30.167 | 31010 | 1558629904 | 4294967296 | 7750365 | 1391264033 | 8589934592 |
| 10.10.30.168 | 31010 | 3260027472 | 4294967296 | 7750365 | 1430581626 | 8589934592 |
| 10.10.30.166 | 31010 | 3613490912 | 4294967296 | 29560368 | 7257210806 | 8589934592 |
+---------------+------------+---------------+-------------+-----------------+---------------------+-------------+
4 rows selected (0.19 seconds)
0: jdbc:drill:schema=dfs.drillTestDirComplexJ> select * from threads;
+---------------+------------+----------------+---------------+
| hostname | user_port | total_threads | busy_threads |
+---------------+------------+----------------+---------------+
| 10.10.30.168 | 31010 | 230 | 57 |
| 10.10.30.169 | 31010 | 270 | 58 |
| 10.10.30.167 | 31010 | 250 | 56 |
| 10.10.30.166 | 31010 | 348 | 58 |
+---------------+------------+----------------+---------------+
4 rows selected (0.164 seconds)
{code}
> 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)