Experts! Help me figure out how to locate, troubleshoot, and optimize

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

Original topic: 大佬们!帮忙参谋下该怎么定位排查和调优

| username: 点点-求助来了

[TiDB Usage Environment] Production Environment
[TiDB Version] 5.0.1
[Reproduction Path] None, have restarted the master node
[Encountered Problem: Symptoms and Impact] Slow transaction commit for large table writes, billion-level large table, single insert, manifested as data delay, select count(1) table name can retrieve the count, select * from table name cannot retrieve real-time data, and there are certain ERROR logs in all components
[Resource Configuration] 40 cores, 128GB memory * 5
[Attachments: Screenshots/Logs/Monitoring]
tiflash


tiflash_tikv

cdc

pd

tikv

Inspection

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

Please provide the table structure. Using “select *” might return too much data.

| username: 点点-求助来了 | Original post link

10 rows, select * from xx limit 10 is just for verification.

| username: WalterWj | Original post link

Take a look at the dashboard and the performance monitoring section on the official website.

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

It seems that TiFlash is fine, but there is an issue with TiKV. Check the execution plan to see if count(*) is using TiFlash and * is using TiKV.

| username: system | Original post link

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