Whistle

这样一条mysql查询

SELECT * FROM keyword WHERE status = ‘active’ AND is_detected = 1 AND begin_time <= 1414080000 AND end_time >= 1414080000 AND click_start <= '13:43:31' AND click_end > ’13:43:31′ AND clicked_times < times AND ((last_click_time + click_interval) < 1414129411) ORDER BY last_click_time ASC LIMIT 1 ; mysql链接400左右，keyword表有记录7200多条，没加任何索引(主键id除外)， 8核16G的阿里云cpu占用700%多。 对status字段做索引，cpu占用马上降到130% ！ 对status和is_detected做联合做引，cpu降至110% ！