标题: mysql优化 [打印本页] 作者: jjjjjjj 时间: 2017-6-29 09:17 标题: mysql优化 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 时间: 2017-6-29 09:17
现在查询时间大约在2-10秒作者: jjjjjjj 时间: 2017-6-29 09:18
求各位大哥帮忙看一下作者: jjjjjjj 时间: 2017-6-29 09:19
Task_ID是有大量重复的 另外我在开始和结束时间上都加了索引，不然根本查不完作者: je_ck 时间: 2017-8-28 11:54
这个语句频繁使用吗？
2-10秒的速度不错了。