Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: TIDB相同查询返回时间不稳定从2min-10min
|
username: TiDBer_8ND2nTtI
【TiDB Usage Environment】Production Environment
【TiDB Version】5.3
【Encountered Problem】Unstable response time for the same query in TiDB
【Reproduction Path】Using the same query
“SELECT a.fundid,
tradingday,
unitnav,
accunav,
virtualnav,
adjustednav,
b.fundname,
coalesce(b.fundshortname, b.fundname) fundshortname
from NetValue a
left join (select a.fundid, b.fundname, coalesce(b.fundshortname, b.fundname) as fundshortname
from table_a a
join table_b b on a.fundsyscode = b.fundsyscode
where a.fundid in (156366, 156367, 156369, 156370, 156373, 156377, 156382, 156383, 156384, 156385, 156389, 156392, 156393, 156397, 156398, 156399, 156400, 156401, 156404, 156405,”(len :123247);
【Problem Phenomenon and Impact】
【Attachment】
The attachment shows the Time statistics for the same query on TiDB Dashboard
Send response time varies greatly, once it was 1.9 minutes, another time it was 9.8 minutes
|
username: 
|
username: 
|
username: