求大神帮忙分析,现有50w条记录,使用下面语句查询得到49w条,稍微做的附加条件是key(cpid) key(apmid) ,耗时8秒左右,降到2s需要做什么优化,,引擎用的myisam
SELECT
a.sip,
a.dip,
sum(c.server_turns_number)
FROM
communication_pair_201711182130_1m a
INNER JOIN basicrelation_201711182130_1m b ON a.cpid = b.cpid
INNER JOIN apm_201711182130_1m c ON b.apmid = c.apmid
GROUP BY
a.dip;
实在想不出来啥办法了