This is an automated email from the ASF dual-hosted git repository.
morrysnow pushed a commit to branch branch-2.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-2.0 by this push:
new b3022a5ea17 [Improvement](statistics) Change auto analyze max table
width default value to 100. (#30395) (#30411)
b3022a5ea17 is described below
commit b3022a5ea1790a9bd99b5d626985921646ef3b09
Author: Jibing-Li <[email protected]>
AuthorDate: Fri Jan 26 16:36:23 2024 +0800
[Improvement](statistics) Change auto analyze max table width default value
to 100. (#30395) (#30411)
backport #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 4cb0891172d..3f56fb0545c 100644
--- a/docs/en/docs/query-acceleration/statistics.md
+++ b/docs/en/docs/query-acceleration/statistics.md
@@ -299,7 +299,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 bff100fa98a..88fa5efbc16 100644
--- a/docs/zh-CN/docs/query-acceleration/statistics.md
+++ b/docs/zh-CN/docs/query-acceleration/statistics.md
@@ -303,7 +303,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 bd188eaa236..227b5b98f88 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
@@ -1243,7 +1243,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 350b6b4fba5..95c8c890863 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]
