mysql的group by优化

问题描述：在一个单表的分组查询中，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

表结构如下：

表结构.png

索引：

索引.png

sql分析.png

优化方案各位多指导