mysql优化

jjjjjjj

SELECT jri.TASK_ID
AS TASK_ID,
SUM(IF(jri.SELECT_RATE >= jri.LOAD_RATE, jri.SELECT_RATE, jri.LOAD_RATE))
AS traffic, SUM(sl.SELECT_COUNT) AS file_amount, COUNT(jri.TASK_ID) AS executions, jri.FINISH_TIME
AS summary_time
FROM  sys_log AS sl INNER JOIN job_run_info AS jri
ON jri.TASK_ID = sl.TASK_ID AND jri.START_TIME = sl.START_TIME AND jri.FINISH_TIME = sl.END_TIME
WHERE jri.CURRENT_STATUS = '2'
AND sl.OPERATION_RESULTS = '0' AND jri.id > 30 AND jri.FINISH_TIME < STR_TO_DATE("2017-06-10","%Y-%m-%d")
AND sl.TASK_ID  IN (34,32,27,36,10)
GROUP BY sl.TASK_ID, END_TIME
ORDER BY null
关联聚合查询
两个表中大约都有100多万条记录

jjjjjjj

现在查询时间大约在2-10秒

jjjjjjj

求各位大哥帮忙看一下

jjjjjjj

Task_ID是有大量重复的 另外我在开始和结束时间上都加了索引，不然根本查不完

je_ck

这个语句频繁使用吗？
2-10秒的速度不错了。

还有就是你用的mysql是什么版本？