Periodic Fluctuations in Batch Index Scan

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 16-core CPU 32G memory 16-core CPU 32G memory 16-core CPU 32G memory

[Attachments: Screenshots/Logs/Monitoring]

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?

| 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.

| username: system | Original post link

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