【 TiDB 使用环境】生产环境
【 TiDB 版本】5.3
【遇到的问题】TIDB相同查询返回时间不稳定
【复现路径】使用相同查询
“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);
【问题现象及影响】
【附件】
附件是同一查询在TIDB Dashboard上的Time统计
Send response Time 差异较大，一次是1.9min，一次是9.8min
