Abnormal Performance of point_get Query

Translated
1

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

Original topic: point_get点查性能异常

| username: charis

【TiDB Usage Environment】Production environment
【TiDB Version】v5.1.0
【Reproduction Path】No recent adjustments, SQL performance suddenly abnormal
【Encountered Problem: Phenomenon and Impact】From the TiDB slow query log, point_get fetching only a few rows of data takes about 6-12 seconds
【Resource Configuration】32 CPUs, 64GB memory, three-node mixed deployment, each node running PD, TiDB, and TiKV
【Attachments: Screenshots/Logs/Monitoring】

image
image1045×652 91 KB

2
| username: WalterWj | Original post link

Is there any issue with the network? :thinking:

3
| username: charis | Original post link

I directly observed the network on the machine and didn’t find any issues. Is there any monitoring tool that can check for network problems?

4
| username: WalterWj | Original post link

TiDB has built-in blackbox monitoring, check the ping inside.

5
| username: charis | Original post link

Sure, let me take a look. Thanks.

6
| username: jansu-dev | Original post link

Is there an update or has it been resolved?

7
| username: system | Original post link

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