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 2018/12/27 14:09:16 UTC

svn commit: r1849799 - in /kylin/site: cn/docs/install/configuration.html docs/install/configuration.html feed.xml

Author: lidong
Date: Thu Dec 27 14:09:15 2018
New Revision: 1849799

URL: http://svn.apache.org/viewvc?rev=1849799&view=rev
Log:
KYLIN-3723 Can't find bad query configuration in kylin config doc

Modified:
    kylin/site/cn/docs/install/configuration.html
    kylin/site/docs/install/configuration.html
    kylin/site/feed.xml

Modified: kylin/site/cn/docs/install/configuration.html
URL: http://svn.apache.org/viewvc/kylin/site/cn/docs/install/configuration.html?rev=1849799&r1=1849798&r2=1849799&view=diff
==============================================================================
--- kylin/site/cn/docs/install/configuration.html (original)
+++ kylin/site/cn/docs/install/configuration.html Thu Dec 27 14:09:15 2018
@@ -224,6 +224,7 @@ var _hmt = _hmt || [];
       <li><a href="#fuzzy">模糊查询</a></li>
       <li><a href="#cache-config">查询缓存</a></li>
       <li><a href="#query-limit">查询限制</a></li>
+      <li><a href="#bad-query">坏查询</a></li>
       <li><a href="#query-pushdown">查询下压</a></li>
       <li><a href="#convert-sql">查询改写</a></li>
       <li><a href="#jmx-metrics">收集查询指标到 JMX</a></li>
@@ -761,6 +762,17 @@ Kylin 可以使用三ç§
   <li><code class="highlighter-rouge">kylin.query.max-return-rows</code>:指定查询返回行数的上限,默认值为 5000000</li>
 </ul>
 
+<h3 id="bad-query">坏查询</h3>
+
+<p><code class="highlighter-rouge">kylin.query.timeout-seconds</code> 的值为大于 60 或为 0,<code class="highlighter-rouge">kylin.query.timeout-seconds-coefficient</code> 其最大值为 double 的上限。这两个参数的乘积为坏查询检查的间隔时间,如果为 0,那么会设为 60 秒,最长秒数是 int 的最大值。</p>
+
+<ul>
+  <li><code class="highlighter-rouge">kylin.query.badquery-stacktrace-depth</code>:设置堆栈追踪的深度,默认值为 10</li>
+  <li><code class="highlighter-rouge">kylin.query.badquery-history-number</code>:设置要展示的历史坏查询的数量,默认为 50</li>
+  <li><code class="highlighter-rouge">kylin.query.badquery-alerting-seconds</code>:默认为 90,如果运行时间大于这个值,那么首先就会打出该查询的日志信息,包括(时长、项目、线程、用户、查询 id)。至于是否保存最近的查询,取决于另一个参数。然后记录 Stack 日志信息,记录的深度由另一个参数指定,方便后续问题分析</li>
+  <li><code class="highlighter-rouge">kylin.query.badquery-persistent-enabled</code>:默认为 true,会保存最近的一些坏查询,而且不可在 Cube 级别进行覆盖</li>
+</ul>
+
 <h3 id="query-pushdown">查询下压</h3>
 
 <ul>

Modified: kylin/site/docs/install/configuration.html
URL: http://svn.apache.org/viewvc/kylin/site/docs/install/configuration.html?rev=1849799&r1=1849798&r2=1849799&view=diff
==============================================================================
--- kylin/site/docs/install/configuration.html (original)
+++ kylin/site/docs/install/configuration.html Thu Dec 27 14:09:15 2018
@@ -6085,6 +6085,7 @@ var _hmt = _hmt || [];
       <li><a href="#fuzzy">Fuzzy Query</a></li>
       <li><a href="#cache-config">Query Cache</a></li>
       <li><a href="#query-limit">Query Limits</a></li>
+      <li><a href="#bad-query">Bad Query</a></li>
       <li><a href="#query-pushdown">Query Pushdown</a></li>
       <li><a href="#convert-sql">Query rewriting</a></li>
       <li><a href="#jmx-metrics">Collect Query Metrics to JMX</a></li>
@@ -6614,13 +6615,24 @@ Kylin can use three types of compression
 <h3 id="query-limit">Query Limits</h3>
 
 <ul>
-  <li><code class="highlighter-rouge">kylin.query.timeout-seconds</code>: specifies the query timeout in seconds. The default value is 0, that is, no timeout limit on query. If the value is less than 60, it will set to seconds.</li>
+  <li><code class="highlighter-rouge">kylin.query.timeout-seconds</code>: specifies the query timeout in seconds. The default value is 0, that is, no timeout limit on query. If the value is less than 60, it will set to 60 seconds.</li>
   <li><code class="highlighter-rouge">kylin.query.timeout-seconds-coefficient</code>: specifies the coefficient of the query timeout seconds. The default value is 0.5.</li>
   <li><code class="highlighter-rouge">kylin.query.max-scan-bytes</code>: specifies the maximum bytes scanned by the query. The default value is 0, that is, there is no limit.</li>
   <li><code class="highlighter-rouge">kylin.storage.partition.max-scan-bytes</code>: specifies the maximum number of bytes for the query scan. The default value is 3221225472 (bytes), which is 3GB.</li>
   <li><code class="highlighter-rouge">kylin.query.max-return-rows</code>: specifies the maximum number of rows returned by the query. The default value is 5000000.</li>
 </ul>
 
+<h3 id="bad-query">Bad Query</h3>
+
+<p>The value of <code class="highlighter-rouge">kylin.query.timeout-seconds</code> is greater than 60 or equals 0, the max value of <code class="highlighter-rouge">kylin.query.timeout-seconds-coefficient</code> is the upper limit of double. The result of multiplying two properties is the interval time of detecting bad query, if it equals 0, it will be set to 60 seconds, the max value of it is the upper limit of int.</p>
+
+<ul>
+  <li><code class="highlighter-rouge">kylin.query.badquery-stacktrace-depth</code>: specifies the depth of stack trace. The default value is 10.</li>
+  <li><code class="highlighter-rouge">kylin.query.badquery-history-number</code>: specifies the showing number of bad query history. The default value is 50.</li>
+  <li><code class="highlighter-rouge">kylin.query.badquery-alerting-seconds</code>: The default value is 90, if the time of running is greater than the value of this property, it will print the log of query firstly, including (duration, project, thread, user, query id). Whether to save the recent query, it depends on another property. Secondly, record the stack log, the depth of log depend on another property, so as to the analysis later</li>
+  <li><code class="highlighter-rouge">kylin.query.badquery-persistent-enabled</code>: The default value is true, it will save the recent bad query, and cannot override in Cube-level</li>
+</ul>
+
 <h3 id="query-pushdown">Query Pushdown</h3>
 
 <ul>

Modified: kylin/site/feed.xml
URL: http://svn.apache.org/viewvc/kylin/site/feed.xml?rev=1849799&r1=1849798&r2=1849799&view=diff
==============================================================================
--- kylin/site/feed.xml (original)
+++ kylin/site/feed.xml Thu Dec 27 14:09:15 2018
@@ -19,8 +19,8 @@
     <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>Mon, 24 Dec 2018 05:59:47 -0800</pubDate>
-    <lastBuildDate>Mon, 24 Dec 2018 05:59:47 -0800</lastBuildDate>
+    <pubDate>Thu, 27 Dec 2018 05:59:28 -0800</pubDate>
+    <lastBuildDate>Thu, 27 Dec 2018 05:59:28 -0800</lastBuildDate>
     <generator>Jekyll v2.5.3</generator>
     
       <item>