If a table experiences high pressure during a query, it gets stuck. Can the pressure on TiKV be distributed?

Translated
1

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

Original topic: 就是查询时一个表压力大的话就卡住了 能不能把tikv的压力打散一下

| username: tidb狂热爱好者

[TiDB Usage Environment] Production Environment
[TiDB Version] 5.4
[Encountered Problem]
[Reproduction Path] What operations were performed that caused the problem
[Problem Phenomenon and Impact]

In our production environment, a single TiKV node often crashes during queries. Is it possible that the table is not properly distributed?
When a table has high query pressure, it gets stuck. Can we distribute the pressure on TiKV nodes?

[Attachment]

Please provide the version information of each component, such as cdc/tikv, which can be obtained by executing cdc version/tikv-server --version.

2
| username: tidb狂热爱好者 | Original post link

Could you please help answer this?

3
| username: h5n1 | Original post link

show table xxx regions, tikv_region_status to check the region distribution of the table

4
| username: 特雷西-迈克-格雷迪 | Original post link

show table xxx regions; show table xxx index xxx regions; Check the region distribution. You can also use TiFlash to share the query load.

5
| username: tidb狂热爱好者 | Original post link

I solved this problem myself.

6
| username: Kongdom | Original post link

How did you solve it? Can you share it?

7
| username: tidb狂热爱好者 | Original post link

Divide a table into multiple segments. The official documentation provides an answer.

8
| username: system | Original post link

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