mysql在使用group by之后产生using temporary，导致性能较慢

问题描述：在一个单表的分组查询中，group by字段使用了临时表导致性能较慢

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

表结构如下： 索引： explain分析结果，group by 之后使用临时表，看Extra中Using temporary 优化方案各位多指导