Periodic Fluctuations in Batch Index Scan

Translated
1

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

Original topic: batch_index_scan 周期性波动

| username: Cehae

[TiDB Usage Environment] Production Environment
[TiDB Version] V5.4
[Reproduction Path] Overview Panel > TiKV > coprocessor executor count > batch_index_scan
[Encountered Problem: Problem Phenomenon and Impact]

Found that batch_index_scan fluctuates periodically, no impact observed yet. Want to understand what an increase in batch_index_scan count represents?

[Resource Configuration]

3 TiKV configurations
10.100.5.71 16-core CPU 32G memory
10.100.5.73 16-core CPU 32G memory
10.100.5.74 16-core CPU 32G memory

[Attachments: Screenshots/Logs/Monitoring]

image
image1380×598 77.2 KB

The official documentation only explains coprocessor executor count. I want to understand the function of batch_index_scan and what an increase in its count represents?

image
image909×457 16.7 KB

2
| username: Billmay表妹 | Original post link

Question 1: This periodic growth needs to be examined in the context of the business’s query pattern. The peak indicates that at this point in time, a batch of queries has executed computation pushdown, pushing down batch_index_scan to the TiKV side.

Question 2: This is a statistical metric for the number of operators (in this case, batch_index_scan) that TiDB has pushed down to the coprocessor layer of TiKV for execution. Batch_index_scan represents an index scan.

3
| username: system | Original post link

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