山水云的博客

原创 如何不让一个慢查询把服务器搞冒烟

手机API接口如何抗住高并发前段时间项目迎来七夕高峰，有一个接口的SQL本来长这样：mysql> explain SELECT *,sum(num) AS sum FROM bi_search WHERE search_time >= '2016-08-30' AND type = 0 AND state = 1 GROUP BY keyword ORDER BY sum DESC LIMIT 50