Automatic Table Analysis Issues

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 自动表分析问题

| username: TiDBer_Terry261

[Test Environment for TiDB] Testing
[TiDB Version] 6.6.0
[Reproduction Path] Automatic Table Analysis
[Encountered Issue: Problem Phenomenon and Impact]

image
image1380×116 45.1 KB

Every time auto analyze table is about to complete, it fails due to tikv:1317 query execution was interrupted.
[Resource Configuration]
[Attachment: Screenshot/Log/Monitoring]

2
| username: WalterWj | Original post link

What about executing it manually?

3
| username: TiDBer_Terry261 | Original post link

It’s the same.

4
| username: tidb菜鸟一只 | Original post link

Set global tidb_build_stats_concurrency=16;
Set global tidb_distsql_scan_concurrency=64;
At the same time, specify WITH FLOAT_NUM SAMPLERATE percentage to manually collect and see. It seems that your automatic collection task has timed out after exceeding 12 hours.

5
| username: TiDBer_Terry261 | Original post link

Okay, I’ll give it a try first. Thank you!

6
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.