mysql一直copying to tmp table_MySQL 优化 之 Copying to tmp table on disk

项目中遇到了慢查询问题

Sql语句

SELECT

sum(price) ASprice,

`member_id`FROM`crm_upload`GROUP BYmember_idORDER BYpriceDESCLIMIT10;

Explain 之后的结果：

MariaDB [member]> explain SELECT sum(price) as price,`member_id` FROM `crm_upload` WHERE `status` = 1 AND `approved` = 1 AND `consume_time` > '2015-09-10' GROUP BY member_id ORDER BY price desc LIMIT 10;+------+-------------+------------+------+---------------+------+---------+------+--------+----------------------------------------------+

| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |

+------+-------------+------------+------+---------------+------+---------+------+--------+----------------------------------------------+

| 1 | SIMPL