MySQL 大表优化方案

正文

请到「今天看啥」查看全文

explain partitions select count ( 1 ) from user_partition where id in ( 1 , 2 , 3 , 4 , 5 );

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

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

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

| 1 | SIMPLE | user_partition | p1 , p4 | range | PRIMARY | PRIMARY | 8

请到「今天看啥」查看全文