You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@kylin.apache.org by li...@apache.org on 2016/09/12 06:02:22 UTC

svn commit: r1760296 - in /kylin/site: blog/2016/08/27/ blog/2016/08/27/query-metrics-in-kylin/ blog/2016/08/27/query-metrics-in-kylin/index.html blog/index.html feed.xml

Author: lidong
Date: Mon Sep 12 06:02:21 2016
New Revision: 1760296

URL: http://svn.apache.org/viewvc?rev=1760296&view=rev
Log:
KYLIN-1908 Add a document of query metrics

Added:
    kylin/site/blog/2016/08/27/
    kylin/site/blog/2016/08/27/query-metrics-in-kylin/
    kylin/site/blog/2016/08/27/query-metrics-in-kylin/index.html
Modified:
    kylin/site/blog/index.html
    kylin/site/feed.xml

Added: kylin/site/blog/2016/08/27/query-metrics-in-kylin/index.html
URL: http://svn.apache.org/viewvc/kylin/site/blog/2016/08/27/query-metrics-in-kylin/index.html?rev=1760296&view=auto
==============================================================================
--- kylin/site/blog/2016/08/27/query-metrics-in-kylin/index.html (added)
+++ kylin/site/blog/2016/08/27/query-metrics-in-kylin/index.html Mon Sep 12 06:02:21 2016
@@ -0,0 +1,290 @@
+<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+<!doctype html>
+<html>
+	<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<head>
+  <meta charset="utf-8">
+  <meta http-equiv="X-UA-Compatible" content="IE=edge">
+  <meta name="viewport" content="width=device-width, initial-scale=1">
+
+  <title>Apache Kylin | Query Metrics in Apache Kylin</title>
+  <meta name="description" content="Apache Kylin support query metrics since 1.5.4. This blog will introduce why Kylin need query metrics, the concrete contents and meaning of query metrics, th...">
+  <meta name="author"      content="Apache Kylin">
+  <link rel="shortcut icon" href="fav.png" type="image/png">
+
+
+
+<link rel="stylesheet" href="/assets/css/animate.css">
+<!-- Bootstrap -->
+<link rel="stylesheet" href="/assets/css/bootstrap.min.css">
+
+<!-- Fonts -->
+<!-- <link rel="stylesheet" href="http://fonts.googleapis.com/css?family=Alice|Open+Sans:400,300,700"> -->
+
+<!-- Icons -->
+<link rel="stylesheet" href="/assets/css/font-awesome.min.css">
+
+  <!-- Custom styles -->
+  <link rel="stylesheet" href="/assets/css/styles.css">
+  <link rel="stylesheet" href="/assets/css/docs.css">
+  <link rel="stylesheet" href="/assets/css/pygments.css">
+
+  <link rel="canonical" href="http://kylin.apache.org/blog/2016/08/27/query-metrics-in-kylin/">
+  <link rel="alternate" type="application/rss+xml" title="Apache Kylin" href="http://kylin.apache.org/feed.xml" />
+
+<!--[if lt IE 9]> <script src="assets/js/html5shiv.js"></script> <![endif]-->
+<script>
+  (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
+  (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
+  m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
+  })(window,document,'script','//www.google-analytics.com/analytics.js','ga');
+
+  //oringal tracker for kylin.io
+  ga('create', 'UA-55534813-1', 'auto');
+  //new tracker for kylin.apache.org
+  ga('create', 'UA-55534813-2', 'auto', {'name':'toplevel'});
+
+  ga('send', 'pageview');
+  ga('toplevel.send', 'pageview');
+
+
+</script>
+<script type="text/javascript" src="/assets/js/jquery-1.9.1.min.js"></script>
+<script type="text/javascript" src="/assets/js/nside.js"></script> </script>
+<script type="text/javascript" src="/assets/js/nnav.js"></script> </script>
+</head>
+
+	<body>
+		<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<header id="header" >
+  
+  <div id="head" class="parallax" parallax-speed="3" >
+    <div id="logo" class="text-center"> <img class="img-circle" id="circlelogo" src="/assets/images/kylin_logo.jpg"> <span class="title" >Apache Kylin™</span> <span class="tagline">Extreme OLAP Engine for Big Data</span> 
+    </div>
+  </div>
+  
+
+  <!-- Main Menu -->
+  <nav class="navbar navbar-default" role="navigation" id="nav-wrapper">
+  <div class="container-fluid" id="nav">
+    <!--
+    <img class="img-circle" width="40px" height="40px" id="circlelogo" src="/assets/images/kylin_logo.jpg">
+    -->
+    <!-- Brand and toggle get grouped for better mobile display -->
+    <div class="navbar-header">
+      <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
+        <span class="sr-only">Toggle navigation</span>
+        <span class="icon-bar"></span>
+        <span class="icon-bar"></span>
+        <span class="icon-bar"></span>
+      </button>
+     
+    </div>
+
+    <!-- Collect the nav links, forms, and other content for toggling -->
+    <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
+      <ul class="nav navbar-nav">
+     <li><a href="/">Home</a></li>
+          <li><a href="/docs15" >Docs</a></li>
+          <li><a href="/download">Download</li>
+          <li><a href="/community" >Community</a></li>
+          <li><a href="/development" >Development</a></li>
+          <li><a href="/blog">Blog</li>
+          <li><a href="/cn" >中文版</a></li>  
+          <li><a href="https://twitter.com/apachekylin" target="_blank" class="fa fa-twitter fa-lg" title="Twitter: @ApacheKylin" ></a></li>
+          <li><a href="https://github.com/apache/kylin" target="_blank" class="fa fa-github-alt fa-lg" title="Github: apache/kylin" ></a></li>          
+          <li><a href="https://www.facebook.com/kylinio" target="_blank" class="fa fa-facebook fa-lg" title="Facebook: kylin.io" ></a></li>   
+      </ul>      
+    </div><!-- /.navbar-collapse -->
+  </div><!-- /.container-fluid -->
+</nav>
+ </header>
+
+		<div class="page-content">
+			<header style=" padding:2em 0 0 0">
+			<div class="container" >
+				<h4 class="section-title"><span>Apache Kylin™ Technical Blog</span></h4>
+			</div>
+		</div>
+
+		<div class="container">
+			<div>
+				<article class="post-content" >	
+				<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<div class="post" style=" padding:2em 4em 4em 4em">
+
+  <header class="post-header">
+    <h1 class="post-title">Query Metrics in Apache Kylin</h1>
+    <p class="post-meta" >Aug 27, 2016 • Kaisen Kang</p>
+  </header>
+
+  <article class="post-content" >
+    <p>Apache Kylin support query metrics since 1.5.4. This blog will introduce why Kylin need query metrics, the concrete contents and meaning of query metrics, the daily function of query metrics and how to collect query metrics.</p>
+
+<h2 id="background">Background</h2>
+<p>When Kylin become an enterprise application, you must ensure Kylin query service is high availability and high performance, besides, you need to provide commitment of the SLA of query service to users, Which need Kylin to support query metrics.</p>
+
+<h2 id="introduction">Introduction</h2>
+<p>The query metrics have Server, Project, Cube three levels.</p>
+
+<p>For example, <code class="highlighter-rouge">QueryCount</code> will have three kinds of metrics:<br />
+```<br />
+Hadoop:name=Server_Total,service=Kylin.QueryCount<br />
+Hadoop:name=learn_kylin,service=Kylin.QueryCount<br />
+Hadoop:name=learn_kylin,service=Kylin,sub=kylin_sales_cube.QueryCount</p>
+
+<p>Server_Total is represent for a query server node,<br />
+learn_kylin is a project name,<br />
+kylin_sales_cube is a cube name.<br />
+```<br />
+### The Key Query Metrics</p>
+
+<ul>
+  <li><code class="highlighter-rouge">QueryCount</code>: the total of query count.</li>
+  <li><code class="highlighter-rouge">QueryFailCount</code>: the total of failed query count.</li>
+  <li><code class="highlighter-rouge">QuerySuccessCount</code>: the total of successful query count.</li>
+  <li><code class="highlighter-rouge">CacheHitCount</code>: the total of query cache hit count.</li>
+  <li><code class="highlighter-rouge">QueryLatency60s99thPercentile</code>: the 99th percentile of query latency in the 60s.(there are 99th, 95th, 90th, 75th, 50th five percentiles and 60s, 360s, 3600s three time intervals in Kylin query metrics. the time intervals could set by <code class="highlighter-rouge">kylin.query.metrics.percentiles.intervals</code>, which default value is <code class="highlighter-rouge">60, 360, 3600</code>)</li>
+  <li><code class="highlighter-rouge">QueryLatencyAvgTime</code>,<code class="highlighter-rouge">QueryLatencyIMaxTime</code>,<code class="highlighter-rouge">QueryLatencyIMinTime</code>: the average, max, min of query latency.</li>
+  <li><code class="highlighter-rouge">ScanRowCount</code>: the rows count of scan HBase, it’s like <code class="highlighter-rouge">QueryLatency</code>.</li>
+  <li><code class="highlighter-rouge">ResultRowCount</code>: the result count of query, it’s like <code class="highlighter-rouge">QueryLatency</code>.</li>
+</ul>
+
+<h2 id="daily-function">Daily Function</h2>
+<p>Besides providing SLA of query service to users, in the daily operation and maintenance, you could make Kylin query daily and Kylin query dashboard by query metrics. Which will help you know the rules, performance of Kylin query and analyze the Kylin query accident case.</p>
+
+<h2 id="how-to-use">How To Use</h2>
+<p>Firstly, you should set config <code class="highlighter-rouge">kylin.query.metrics.enabled</code> as true to collect query metrics to JMX.</p>
+
+<p>Secondly, you could use arbitrary JMX collection tool to collect the query metrics to your monitor system. Notice that, The query metrics have Server, Project, Cube three levels,  which was implemented by dynamic <code class="highlighter-rouge">ObjectName</code>, so you should get <code class="highlighter-rouge">ObjectName</code> by regular expression.</p>
+
+  </article>
+
+</div>
+
+
+
+
+
+				</article>
+			</div>
+		</div>		
+		<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<footer id="underfooter">
+    <div class="container">
+        <div class="row">
+            <div class="col-md-12 widget">
+                <div class="widget-body" style="text-align:center">
+                    <a href="http://www.apache.org">
+                        <img id="asf-logo" alt="Apache Software Foundation" src="/assets/images/feather-small.gif">
+                    </a>
+
+                    <div>
+                        The contents of this website are © 2015 Apache Software Foundation under the terms of the <a
+                            href="http://www.apache.org/licenses/LICENSE-2.0"> Apache License v2 </a>. Apache Kylin and
+                        its logo are trademarks of the Apache Software Foundation.
+                    </div>
+
+                </div>
+            </div>
+        </div>
+        <!-- /row of widgets -->
+
+    </div>
+    <div></div>
+
+</footer>
+
+	<script src="/assets/js/jquery-1.9.1.min.js"></script> 
+	<script src="/assets/js/bootstrap.min.js"></script> 
+	<script src="/assets/js/main.js"></script>
+	</body>
+</html>
+
+
+
+

Modified: kylin/site/blog/index.html
URL: http://svn.apache.org/viewvc/kylin/site/blog/index.html?rev=1760296&r1=1760295&r2=1760296&view=diff
==============================================================================
--- kylin/site/blog/index.html (original)
+++ kylin/site/blog/index.html Mon Sep 12 06:02:21 2016
@@ -174,6 +174,12 @@
             
             <li>
         <h2 align="left" style="margin:0px">
+          <a class="post-link" href="/blog/2016/08/27/query-metrics-in-kylin/">Query Metrics in Apache Kylin</a></h2><div align="left" class="post-meta">posted: Aug 27, 2016</div>
+        
+      </li>
+    
+            <li>
+        <h2 align="left" style="margin:0px">
           <a class="post-link" href="/blog/2016/08/01/count-distinct-in-kylin/">Use Count Distinct in Apache Kylin</a></h2><div align="left" class="post-meta">posted: Aug 1, 2016</div>
         
       </li>
@@ -222,13 +228,13 @@
     
             <li>
         <h2 align="left" style="margin:0px">
-          <a class="post-link" href="/cn/blog/2016/04/12/release-v1.5.1/">Apache Kylin v1.5.1 正式发布</a></h2><div align="left" class="post-meta">posted: Apr 12, 2016</div>
+          <a class="post-link" href="/blog/2016/04/12/release-v1.5.1/">Apache Kylin v1.5.1 Release Announcement</a></h2><div align="left" class="post-meta">posted: Apr 12, 2016</div>
         
       </li>
     
             <li>
         <h2 align="left" style="margin:0px">
-          <a class="post-link" href="/blog/2016/04/12/release-v1.5.1/">Apache Kylin v1.5.1 Release Announcement</a></h2><div align="left" class="post-meta">posted: Apr 12, 2016</div>
+          <a class="post-link" href="/cn/blog/2016/04/12/release-v1.5.1/">Apache Kylin v1.5.1 正式发布</a></h2><div align="left" class="post-meta">posted: Apr 12, 2016</div>
         
       </li>
     
@@ -276,25 +282,25 @@
     
             <li>
         <h2 align="left" style="margin:0px">
-          <a class="post-link" href="/cn/blog/2015/12/25/support-powerbi-tableau9/">Apache Kylin增加对Tableau 9及微软Excel, Power BI的支持</a></h2><div align="left" class="post-meta">posted: Dec 25, 2015</div>
+          <a class="post-link" href="/blog/2015/12/25/support-powerbi-tableau9/">Apache Kylin supports Tableau 9 and MS Excel, Power BI now</a></h2><div align="left" class="post-meta">posted: Dec 25, 2015</div>
         
       </li>
     
             <li>
         <h2 align="left" style="margin:0px">
-          <a class="post-link" href="/blog/2015/12/25/support-powerbi-tableau9/">Apache Kylin supports Tableau 9 and MS Excel, Power BI now</a></h2><div align="left" class="post-meta">posted: Dec 25, 2015</div>
+          <a class="post-link" href="/cn/blog/2015/12/25/support-powerbi-tableau9/">Apache Kylin增加对Tableau 9及微软Excel, Power BI的支持</a></h2><div align="left" class="post-meta">posted: Dec 25, 2015</div>
         
       </li>
     
             <li>
         <h2 align="left" style="margin:0px">
-          <a class="post-link" href="/blog/2015/12/23/release-v1.2/">Apache Kylin v1.2 Release Announcement</a></h2><div align="left" class="post-meta">posted: Dec 23, 2015</div>
+          <a class="post-link" href="/cn/blog/2015/12/23/release-v1.2/">Apache Kylin v1.2 正式发布</a></h2><div align="left" class="post-meta">posted: Dec 23, 2015</div>
         
       </li>
     
             <li>
         <h2 align="left" style="margin:0px">
-          <a class="post-link" href="/cn/blog/2015/12/23/release-v1.2/">Apache Kylin v1.2 正式发布</a></h2><div align="left" class="post-meta">posted: Dec 23, 2015</div>
+          <a class="post-link" href="/blog/2015/12/23/release-v1.2/">Apache Kylin v1.2 Release Announcement</a></h2><div align="left" class="post-meta">posted: Dec 23, 2015</div>
         
       </li>
     

Modified: kylin/site/feed.xml
URL: http://svn.apache.org/viewvc/kylin/site/feed.xml?rev=1760296&r1=1760295&r2=1760296&view=diff
==============================================================================
--- kylin/site/feed.xml (original)
+++ kylin/site/feed.xml Mon Sep 12 06:02:21 2016
@@ -19,11 +19,61 @@
     <description>Apache Kylin Home</description>
     <link>http://kylin.apache.org/</link>
     <atom:link href="http://kylin.apache.org/feed.xml" rel="self" type="application/rss+xml"/>
-    <pubDate>Fri, 12 Aug 2016 06:59:13 -0700</pubDate>
-    <lastBuildDate>Fri, 12 Aug 2016 06:59:13 -0700</lastBuildDate>
+    <pubDate>Mon, 12 Sep 2016 06:59:09 -0700</pubDate>
+    <lastBuildDate>Mon, 12 Sep 2016 06:59:09 -0700</lastBuildDate>
     <generator>Jekyll v2.5.3</generator>
     
       <item>
+        <title>Query Metrics in Apache Kylin</title>
+        <description>&lt;p&gt;Apache Kylin support query metrics since 1.5.4. This blog will introduce why Kylin need query metrics, the concrete contents and meaning of query metrics, the daily function of query metrics and how to collect query metrics.&lt;/p&gt;
+
+&lt;h2 id=&quot;background&quot;&gt;Background&lt;/h2&gt;
+&lt;p&gt;When Kylin become an enterprise application, you must ensure Kylin query service is high availability and high performance, besides, you need to provide commitment of the SLA of query service to users, Which need Kylin to support query metrics.&lt;/p&gt;
+
+&lt;h2 id=&quot;introduction&quot;&gt;Introduction&lt;/h2&gt;
+&lt;p&gt;The query metrics have Server, Project, Cube three levels.&lt;/p&gt;
+
+&lt;p&gt;For example, &lt;code class=&quot;highlighter-rouge&quot;&gt;QueryCount&lt;/code&gt; will have three kinds of metrics:&lt;br /&gt;
+```&lt;br /&gt;
+Hadoop:name=Server_Total,service=Kylin.QueryCount&lt;br /&gt;
+Hadoop:name=learn_kylin,service=Kylin.QueryCount&lt;br /&gt;
+Hadoop:name=learn_kylin,service=Kylin,sub=kylin_sales_cube.QueryCount&lt;/p&gt;
+
+&lt;p&gt;Server_Total is represent for a query server node,&lt;br /&gt;
+learn_kylin is a project name,&lt;br /&gt;
+kylin_sales_cube is a cube name.&lt;br /&gt;
+```&lt;br /&gt;
+### The Key Query Metrics&lt;/p&gt;
+
+&lt;ul&gt;
+  &lt;li&gt;&lt;code class=&quot;highlighter-rouge&quot;&gt;QueryCount&lt;/code&gt;: the total of query count.&lt;/li&gt;
+  &lt;li&gt;&lt;code class=&quot;highlighter-rouge&quot;&gt;QueryFailCount&lt;/code&gt;: the total of failed query count.&lt;/li&gt;
+  &lt;li&gt;&lt;code class=&quot;highlighter-rouge&quot;&gt;QuerySuccessCount&lt;/code&gt;: the total of successful query count.&lt;/li&gt;
+  &lt;li&gt;&lt;code class=&quot;highlighter-rouge&quot;&gt;CacheHitCount&lt;/code&gt;: the total of query cache hit count.&lt;/li&gt;
+  &lt;li&gt;&lt;code class=&quot;highlighter-rouge&quot;&gt;QueryLatency60s99thPercentile&lt;/code&gt;: the 99th percentile of query latency in the 60s.(there are 99th, 95th, 90th, 75th, 50th five percentiles and 60s, 360s, 3600s three time intervals in Kylin query metrics. the time intervals could set by &lt;code class=&quot;highlighter-rouge&quot;&gt;kylin.query.metrics.percentiles.intervals&lt;/code&gt;, which default value is &lt;code class=&quot;highlighter-rouge&quot;&gt;60, 360, 3600&lt;/code&gt;)&lt;/li&gt;
+  &lt;li&gt;&lt;code class=&quot;highlighter-rouge&quot;&gt;QueryLatencyAvgTime&lt;/code&gt;,&lt;code class=&quot;highlighter-rouge&quot;&gt;QueryLatencyIMaxTime&lt;/code&gt;,&lt;code class=&quot;highlighter-rouge&quot;&gt;QueryLatencyIMinTime&lt;/code&gt;: the average, max, min of query latency.&lt;/li&gt;
+  &lt;li&gt;&lt;code class=&quot;highlighter-rouge&quot;&gt;ScanRowCount&lt;/code&gt;: the rows count of scan HBase, it’s like &lt;code class=&quot;highlighter-rouge&quot;&gt;QueryLatency&lt;/code&gt;.&lt;/li&gt;
+  &lt;li&gt;&lt;code class=&quot;highlighter-rouge&quot;&gt;ResultRowCount&lt;/code&gt;: the result count of query, it’s like &lt;code class=&quot;highlighter-rouge&quot;&gt;QueryLatency&lt;/code&gt;.&lt;/li&gt;
+&lt;/ul&gt;
+
+&lt;h2 id=&quot;daily-function&quot;&gt;Daily Function&lt;/h2&gt;
+&lt;p&gt;Besides providing SLA of query service to users, in the daily operation and maintenance, you could make Kylin query daily and Kylin query dashboard by query metrics. Which will help you know the rules, performance of Kylin query and analyze the Kylin query accident case.&lt;/p&gt;
+
+&lt;h2 id=&quot;how-to-use&quot;&gt;How To Use&lt;/h2&gt;
+&lt;p&gt;Firstly, you should set config &lt;code class=&quot;highlighter-rouge&quot;&gt;kylin.query.metrics.enabled&lt;/code&gt; as true to collect query metrics to JMX.&lt;/p&gt;
+
+&lt;p&gt;Secondly, you could use arbitrary JMX collection tool to collect the query metrics to your monitor system. Notice that, The query metrics have Server, Project, Cube three levels,  which was implemented by dynamic &lt;code class=&quot;highlighter-rouge&quot;&gt;ObjectName&lt;/code&gt;, so you should get &lt;code class=&quot;highlighter-rouge&quot;&gt;ObjectName&lt;/code&gt; by regular expression.&lt;/p&gt;
+</description>
+        <pubDate>Sat, 27 Aug 2016 10:30:00 -0700</pubDate>
+        <link>http://kylin.apache.org/blog/2016/08/27/query-metrics-in-kylin/</link>
+        <guid isPermaLink="true">http://kylin.apache.org/blog/2016/08/27/query-metrics-in-kylin/</guid>
+        
+        
+        <category>blog</category>
+        
+      </item>
+    
+      <item>
         <title>Use Count Distinct in Apache Kylin</title>
         <description>&lt;p&gt;Since v.1.5.3&lt;/p&gt;
 
@@ -837,94 +887,6 @@ send mail to Apache Kylin dev mailing li
         
         
         <category>blog</category>
-        
-      </item>
-    
-      <item>
-        <title>Apache Kylin v1.5.1 Release Announcement</title>
-        <description>&lt;p&gt;The Apache Kylin community is pleased to announce the release of Apache Kylin v1.5.1.&lt;/p&gt;
-
-&lt;p&gt;Apache Kylin is an open source Distributed Analytics Engine designed to provide SQL interface and multi-dimensional analysis (OLAP) on Hadoop supporting extremely large datasets, original contributed from eBay Inc.&lt;/p&gt;
-
-&lt;p&gt;To download Apache Kylin v1.5.1 source code or binary package:&lt;br /&gt;
-please visit the &lt;a href=&quot;http://kylin.apache.org/download&quot;&gt;download&lt;/a&gt; page.&lt;/p&gt;
-
-&lt;p&gt;This is a major release which brings more stable, robust and well management version, Apache Kylin community resolved about 37 issues including bug fixes, improvements, and few new features.&lt;/p&gt;
-
-&lt;h2 id=&quot;change-highlights&quot;&gt;Change Highlights&lt;/h2&gt;
-
-&lt;p&gt;&lt;strong&gt;New Feature&lt;/strong&gt;&lt;/p&gt;
-
-&lt;ul&gt;
-  &lt;li&gt;Kylin support detail data query from fact table &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1122&quot;&gt;KYLIN-1122&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;Add UI for TopN measure &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1378&quot;&gt;KYLIN-1378&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;Custom dimension encoding &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1492&quot;&gt;KYLIN-1492&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;Metadata upgrade from 1.0~1.3 to 1.5, including metadata correction, relevant tools, etc. &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1495&quot;&gt;KYLIN-1495&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;Run some classes at the beginning of kylin server startup &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1501&quot;&gt;KYLIN-1501&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;Print version information with kylin.sh &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1503&quot;&gt;KYLIN-1503&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;Add smoke test scripts &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1531&quot;&gt;KYLIN-1531&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;Cube specific config, override global kylin.properties &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1534&quot;&gt;KYLIN-1534&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;REST API for deleting segment &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1540&quot;&gt;KYLIN-1540&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;IntegerDimEnc, custom dimension encoding for integers &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1541&quot;&gt;KYLIN-1541&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;Tool to dump information for diagnosis &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1546&quot;&gt;KYLIN-1546&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;Persist some recent bad query &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1550&quot;&gt;KYLIN-1550&lt;/a&gt;&lt;/li&gt;
-&lt;/ul&gt;
-
-&lt;p&gt;&lt;strong&gt;Improvement&lt;/strong&gt;&lt;/p&gt;
-
-&lt;ul&gt;
-  &lt;li&gt;Use InstallShield 2015 to generate ODBC Driver setup files &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1490&quot;&gt;KYLIN-1490&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;cube desc signature not calculated correctly &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1498&quot;&gt;KYLIN-1498&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;streaming_fillgap cause out of memory &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1500&quot;&gt;KYLIN-1500&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;When cube is not empty, only signature consistent cube desc updates are allowed &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1502&quot;&gt;KYLIN-1502&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;Use NavigableSet to store rowkey and use prefix filter to check resource path prefix instead String comparison on tomcat side &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1504&quot;&gt;KYLIN-1504&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;Combine guava filters with Predicates.and &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1505&quot;&gt;KYLIN-1505&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;GTFilterScanner performance tuning &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1543&quot;&gt;KYLIN-1543&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;Enhance the check on aggregation group dimension number &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1557&quot;&gt;KYLIN-1557&lt;/a&gt;&lt;/li&gt;
-&lt;/ul&gt;
-
-&lt;p&gt;&lt;strong&gt;Bug&lt;/strong&gt;&lt;/p&gt;
-
-&lt;ul&gt;
-  &lt;li&gt;need to encode export query url to get right result in query page &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1373&quot;&gt;KYLIN-1373&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;Kylin Job Monitor API: /kylin/api/jobs is too slow in large kylin deployment &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1434&quot;&gt;KYLIN-1434&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;Export csv get error when there is a plus sign in the sql &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1472&quot;&gt;KYLIN-1472&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;java.lang.IllegalArgumentException: Too many digits for NumberDictionary &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1486&quot;&gt;KYLIN-1486&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;Should return base cuboid as valid cuboid if no aggregation group matches &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1491&quot;&gt;KYLIN-1491&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;make ExecutableManager.getInstance thread safe &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1493&quot;&gt;KYLIN-1493&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;Make three class.getInstance thread safe &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1497&quot;&gt;KYLIN-1497&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;Couldn’t find hive dependency jar on some platform like CDH &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1507&quot;&gt;KYLIN-1507&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;Time partitioning doesn’t work across multiple days &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1513&quot;&gt;KYLIN-1513&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;MD5 validation of Tomcat does not work when package tar &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1514&quot;&gt;KYLIN-1514&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;Couldn’t refresh a cube segment whose start time is before 1970-01-01 &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1521&quot;&gt;KYLIN-1521&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;HLLC is incorrect when result is feed from cache &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1522&quot;&gt;KYLIN-1522&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;Get “java.lang.Double cannot be cast to java.lang.Long” error when Top-N metris data type is BigInt &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1524&quot;&gt;KYLIN-1524&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;Columns with all NULL values can’t be queried &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1527&quot;&gt;KYLIN-1527&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;Failed to create flat hive table, when name is too long &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1537&quot;&gt;KYLIN-1537&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;DoubleDeltaSerializer cause obvious error after deserialize and serialize &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1538&quot;&gt;KYLIN-1538&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;Cannot find rowkey column “COL_NAME” in cube CubeDesc &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1553&quot;&gt;KYLIN-1553&lt;/a&gt;&lt;/li&gt;
-  &lt;li&gt;Unclosed table in BuildCubeWithEngine#checkHFilesInHBase() &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN-1564&quot;&gt;KYLIN-1564&lt;/a&gt;&lt;/li&gt;
-&lt;/ul&gt;
-
-&lt;p&gt;&lt;strong&gt;Upgrade&lt;/strong&gt;&lt;/p&gt;
-
-&lt;p&gt;Data and metadata of this version is back compatible with v1.5.0, but may need to &lt;a href=&quot;/docs15/howto/howto_update_coprocessor.html&quot;&gt;redeploy hbase coprocessor&lt;/a&gt;.&lt;/p&gt;
-
-&lt;p&gt;&lt;strong&gt;Support&lt;/strong&gt;&lt;/p&gt;
-
-&lt;p&gt;Any issue or question, please&lt;br /&gt;
-open JIRA to Kylin project: &lt;a href=&quot;https://issues.apache.org/jira/browse/KYLIN/&quot;&gt;https://issues.apache.org/jira/browse/KYLIN/&lt;/a&gt;&lt;br /&gt;
-or&lt;br /&gt;
-send mail to Apache Kylin dev mailing list: &lt;a href=&quot;&amp;#109;&amp;#097;&amp;#105;&amp;#108;&amp;#116;&amp;#111;:&amp;#100;&amp;#101;&amp;#118;&amp;#064;&amp;#107;&amp;#121;&amp;#108;&amp;#105;&amp;#110;&amp;#046;&amp;#097;&amp;#112;&amp;#097;&amp;#099;&amp;#104;&amp;#101;&amp;#046;&amp;#111;&amp;#114;&amp;#103;&quot;&gt;&amp;#100;&amp;#101;&amp;#118;&amp;#064;&amp;#107;&amp;#121;&amp;#108;&amp;#105;&amp;#110;&amp;#046;&amp;#097;&amp;#112;&amp;#097;&amp;#099;&amp;#104;&amp;#101;&amp;#046;&amp;#111;&amp;#114;&amp;#103;&lt;/a&gt;&lt;/p&gt;
-
-&lt;p&gt;&lt;em&gt;Great thanks to everyone who contributed!&lt;/em&gt;&lt;/p&gt;
-</description>
-        <pubDate>Tue, 12 Apr 2016 04:00:00 -0700</pubDate>
-        <link>http://kylin.apache.org/blog/2016/04/12/release-v1.5.1/</link>
-        <guid isPermaLink="true">http://kylin.apache.org/blog/2016/04/12/release-v1.5.1/</guid>
-        
-        
-        <category>blog</category>
         
       </item>