問題描述：在一個(gè)單表的分組查詢中，group by字段使用了臨時(shí)表導(dǎo)致性能較慢
SELECT
id,http_url,count(1) as callCount,sum(IF((`status`='200'),1,0)) as successNum,
sum(IF((`status`!='200'),1,0)) as failNum, avg(responseTime) as avgResponseTime
FROM http_log_info
WHERE system_cd = 'CCRC'
AND begin_time BETWEEN '2020-03-16' AND '2020-04-17'
and delete_flag = 0
group by http_url
表結(jié)構(gòu)如下：
表結(jié)構(gòu).png
索引：
索引.png
explain分析結(jié)果，group by 之后使用臨時(shí)表，看Extra中Using temporary
sql分析.png
優(yōu)化方案各位多指導(dǎo)
