phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rahulsIOT <...@git.apache.org>
Subject [GitHub] phoenix issue #242: PQS metrics - https://issues.apache.org/jira/browse/PHOE...
Date Mon, 15 May 2017 23:58:44 GMT
Github user rahulsIOT commented on the issue:

    https://github.com/apache/phoenix/pull/242
  
    Metrics Snippet
    **Statement Level -** 
    {"Statement-OverAllReadRequestMetrics":{"RESULT_SET_TIME_MS":22,"QUERY_FAILED_COUNTER":0,"QUERY_TIMEOUT_COUNTER":0,"WALL_CLOCK_TIME_MS":52,"CACHE_REFRESH_SPLITS_COUNTER":0,"NUM_PARALLEL_SCANS":1}}
    
    {"Statement-RequestReadMetrics":{"QUERYSERVERBASICSIT1494892379503":{"TASK_QUEUE_WAIT_TIME":0,"SCAN_BYTES":208,"TASK_END_TO_END_TIME":10,"TASK_EXECUTED_COUNTER":1,"TASK_EXECUTION_TIME":10,"TASK_REJECTED_COUNTER":0}}}
    
    **Global Metrics -**
    
    {"global":[{"numberOfSamples":0,"description":"Batch sizes of mutations","currentMetricState":"MUTATION_BATCH_SIZE:
0, Number of samples: 0","totalSum":0,"name":"MUTATION_BATCH_SIZE","value":0},{"numberOfSamples":0,"description":"Size
of mutations in bytes","currentMetricState":"MUTATION_BYTES: 0, Number of samples: 0","totalSum":0,"name":"MUTATION_BYTES","value":0},{"numberOfSamples":0,"description":"Time
it took to commit mutations","currentMetricState":"MUTATION_COMMIT_TIME: 0, Number of samples:
0","totalSum":0,"name":"MUTATION_COMMIT_TIME","value":0},{"numberOfSamples":7,"description":"Query
times","currentMetricState":"QUERY_TIME: 52, Number of samples: 7","totalSum":52,"name":"QUERY_TIME","value":52},{"numberOfSamples":11,"description":"Number
of scans that were executed in parallel","currentMetricState":"NUM_PARALLEL_SCANS: 11, Number
of samples: 11","totalSum":11,"name":"NUM_PARALLEL_SCANS","value":11},{"numberOfSamples":2,"description":"Number
of bytes read by scans","c
 urrentMetricState":"SCAN_BYTES: 192, Number of samples: 2","totalSum":192,"name":"SCAN_BYTES","value":192},{"numberOfSamples":0,"description":"Size
of spool files created in bytes","currentMetricState":"SPOOL_FILE_SIZE: 0, Number of samples:
0","totalSum":0,"name":"SPOOL_FILE_SIZE","value":0},{"numberOfSamples":0,"description":"Number
of bytes allocated by the memory manager","currentMetricState":"MEMORY_CHUNK_BYTES: 0, Number
of samples: 0","totalSum":0,"name":"MEMORY_CHUNK_BYTES","value":0},{"numberOfSamples":0,"description":"Number
of milliseconds threads needed to wait for memory to be allocated through memory manager","currentMetricState":"MEMORY_WAIT_TIME:
0, Number of samples: 0","totalSum":0,"name":"MEMORY_WAIT_TIME","value":0},{"numberOfSamples":11,"description":"Time
in milliseconds tasks had to wait in the queue of the thread pool executor","currentMetricState":"TASK_QUEUE_WAIT_TIME:
5, Number of samples: 11","totalSum":5,"name":"TASK_QUEUE_WAIT_TIME","value":5},{"numberO
 fSamples":11,"description":"Time in milliseconds spent by tasks from creation to completion","currentMetricState":"TASK_END_TO_END_TIME:
139, Number of samples: 11","totalSum":139,"name":"TASK_END_TO_END_TIME","value":139},{"numberOfSamples":11,"description":"Time
in milliseconds tasks took to execute","currentMetricState":"TASK_EXECUTION_TIME: 134, Number
of samples: 11","totalSum":134,"name":"TASK_EXECUTION_TIME","value":134},{"numberOfSamples":99,"description":"Counter
for number of mutation sql statements","currentMetricState":"MUTATION_SQL_COUNTER: 99, Number
of samples: 99","totalSum":99,"name":"MUTATION_SQL_COUNTER","value":99},{"numberOfSamples":7,"description":"Counter
for number of sql queries","currentMetricState":"SELECT_SQL_COUNTER: 7, Number of samples:
7","totalSum":7,"name":"SELECT_SQL_COUNTER","value":7},{"numberOfSamples":11,"description":"Counter
for number of tasks submitted to the thread pool executor","currentMetricState":"TASK_EXECUTED_COUNTER:
11, Number of s
 amples: 11","totalSum":11,"name":"TASK_EXECUTED_COUNTER","value":11},{"numberOfSamples":0,"description":"Counter
for number of tasks that were rejected by the thread pool executor","currentMetricState":"TASK_REJECTED_COUNTER:
0, Number of samples: 0","totalSum":0,"name":"TASK_REJECTED_COUNTER","value":0},{"numberOfSamples":0,"description":"Number
of times query timed out","currentMetricState":"QUERY_TIMEOUT_COUNTER: 0, Number of samples:
0","totalSum":0,"name":"QUERY_TIMEOUT_COUNTER","value":0},{"numberOfSamples":0,"description":"Number
of times query failed","currentMetricState":"QUERY_FAILED_COUNTER: 0, Number of samples: 0","totalSum":0,"name":"QUERY_FAILED_COUNTER","value":0},{"numberOfSamples":0,"description":"Number
of spool files created","currentMetricState":"SPOOL_FILE_COUNTER: 0, Number of samples: 0","totalSum":0,"name":"SPOOL_FILE_COUNTER","value":0},{"numberOfSamples":14,"description":"Number
of open phoenix connections","currentMetricState":"OPEN_PHOENIX_CONNECTIONS_CO
 UNTER: 0, Number of samples: 14","totalSum":0,"name":"OPEN_PHOENIX_CONNECTIONS_COUNTER","value":0},{"numberOfSamples":1,"description":"Number
of ConnectionQueryServicesImpl instantiated","currentMetricState":"QUERY_SERVICES_COUNTER:
1, Number of samples: 1","totalSum":1,"name":"QUERY_SERVICES_COUNTER","value":1},{"numberOfSamples":1,"description":"Number
of HConnections created by phoenix driver","currentMetricState":"HCONNECTIONS_COUNTER: 1,
Number of samples: 1","totalSum":1,"name":"HCONNECTIONS_COUNTER","value":1}]}
    
    
    Global Metrics is also exposed via JMX. ( screen shot attached)
    ![global_metrics](https://cloud.githubusercontent.com/assets/22037123/26084258/bc60c16a-398f-11e7-9607-a9d8d50a6aa1.png)
    
    



---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

Mime
View raw message