Skip to content

change the way of checking auto analyze ratio #24237

@eurekaka

Description

@eurekaka

Development Task

Currently, we use (modify_count / count) > autoAnalyzeRatio as the check for auto analyze, this may lead to confusing results sometimes.

For example, if the table has 200 rows, then a 200-row insert can trigger auto analyze if the autoAnalyzeRatio is 0.5, while a 67-row delete can trigger it as well. This inconsistency should be confusing.

To solve this problem, we can use (modify_count / hist.TotalRowCount()) > autoAnalyzeRatio as the check instead.

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions