This is an automated email from the ASF dual-hosted git repository.
lijibing pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new ed4524fec74 Change auto analyze max table width default value to 100.
(#30395)
ed4524fec74 is described below
commit ed4524fec74f4f074daa8bd4cbd2aa5928348a69
Author: Jibing-Li <[email protected]>
AuthorDate: Fri Jan 26 14:18:57 2024 +0800
Change auto analyze max table width default value to 100. (#30395)
---
docs/en/docs/query-acceleration/statistics.md | 2 +-
docs/zh-CN/docs/query-acceleration/statistics.md | 2 +-
fe/fe-core/src/main/java/org/apache/doris/qe/SessionVariable.java | 2 +-
.../src/main/java/org/apache/doris/statistics/StatisticConstants.java | 2 +-
4 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/docs/en/docs/query-acceleration/statistics.md
b/docs/en/docs/query-acceleration/statistics.md
index 10486c08059..b92e137f828 100644
--- a/docs/en/docs/query-acceleration/statistics.md
+++ b/docs/en/docs/query-acceleration/statistics.md
@@ -305,7 +305,7 @@ mysql> KILL ANALYZE 52357;
|huge_table_auto_analyze_interval_in_millis|Controls the minimum time interval
for automatic ANALYZE on large tables. Tables with sizes greater than
`huge_table_lower_bound_size_in_bytes * 5` will be ANALYZEed only once within
this time interval.|0|
|table_stats_health_threshold|Ranges from 0 to 100. If data updates since the
last statistics collection exceed `(100 - table_stats_health_threshold)%`, the
table's statistics are considered outdated.|60|
|analyze_timeout|Controls the timeout for synchronous ANALYZE in seconds|43200|
-|auto_analyze_table_width_threshold|Controls the maximum width of table that
will be auto analyzed. Table with more columns than this value will not be auto
analyzed.|70|
+|auto_analyze_table_width_threshold|Controls the maximum width of table that
will be auto analyzed. Table with more columns than this value will not be auto
analyzed.|100|
<br/>
diff --git a/docs/zh-CN/docs/query-acceleration/statistics.md
b/docs/zh-CN/docs/query-acceleration/statistics.md
index 446aa5605a8..6ad3a291f79 100644
--- a/docs/zh-CN/docs/query-acceleration/statistics.md
+++ b/docs/zh-CN/docs/query-acceleration/statistics.md
@@ -309,7 +309,7 @@ mysql> KILL ANALYZE 52357;
|huge_table_auto_analyze_interval_in_millis|控制对大表的自动ANALYZE的最小时间间隔，在该时间间隔内大小超过huge_table_lower_bound_size_in_bytes
* 5的表仅ANALYZE一次|0|
|table_stats_health_threshold|取值在0-100之间，当自上次统计信息收集操作之后，数据更新量达到 (100 -
table_stats_health_threshold)% ，认为该表的统计信息已过时|60|
|analyze_timeout|控制ANALYZE超时时间，单位为秒|43200|
-|auto_analyze_table_width_threshold|控制自动统计信息收集处理的最大表宽度，列数大于该值的表不会参与自动统计信息收集|70|
+|auto_analyze_table_width_threshold|控制自动统计信息收集处理的最大表宽度，列数大于该值的表不会参与自动统计信息收集|100|
<br/>
diff --git a/fe/fe-core/src/main/java/org/apache/doris/qe/SessionVariable.java
b/fe/fe-core/src/main/java/org/apache/doris/qe/SessionVariable.java
index 61cadfae735..6648d5217ae 100644
--- a/fe/fe-core/src/main/java/org/apache/doris/qe/SessionVariable.java
+++ b/fe/fe-core/src/main/java/org/apache/doris/qe/SessionVariable.java
@@ -1447,7 +1447,7 @@ public class SessionVariable implements Serializable,
Writable {
"Maximum table width to enable auto analyze, "
+ "table with more columns than this value will not be
auto analyzed."},
flag = VariableMgr.GLOBAL)
- public int autoAnalyzeTableWidthThreshold = 70;
+ public int autoAnalyzeTableWidthThreshold = 100;
@VariableMgr.VarAttr(name = AUTO_ANALYZE_START_TIME, needForward = true,
checker = "checkAnalyzeTimeFormat",
description = {"该参数定义自动ANALYZE例程的开始时间",
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/statistics/StatisticConstants.java
b/fe/fe-core/src/main/java/org/apache/doris/statistics/StatisticConstants.java
index 857a50e234c..f2f53fa7457 100644
---
a/fe/fe-core/src/main/java/org/apache/doris/statistics/StatisticConstants.java
+++
b/fe/fe-core/src/main/java/org/apache/doris/statistics/StatisticConstants.java
@@ -98,7 +98,7 @@ public class StatisticConstants {
public static final int TASK_QUEUE_CAP = 10;
- public static final int AUTO_ANALYZE_TABLE_WIDTH_THRESHOLD = 70;
+ public static final int AUTO_ANALYZE_TABLE_WIDTH_THRESHOLD = 100;
public static final int MSG_LEN_UPPER_BOUND = 1024;
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
