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>