索引的Cardinality是什么意思?
show index from tbl的结果中会有Cardinality这一项,
一直不明白是什么意思,这个值对于索引的效率有什么影响吗?
[解决办法]
的确是,很奇怪。应该是MYSQL的问题。
但当你再多插入几行后,倒是正确了。
mysql> insert into tt(a, b, c, d) -> values(1, 1, 1, 1), (1, 1, 1, 2), -> (1, 1, 2, 1), (1, 1, 2, 1), -> (1, 1, 2, 2), (1, 2, 1, 1), -> (1, 2, 2, 1), (1, 2, 2, 2);Query OK, 8 rows affected (0.00 sec)Records: 8 Duplicates: 0 Warnings: 0mysql> insert into tt(a, b, c, d) -> values(1, 1, 1, 1), (1, 1, 1, 2), -> (1, 1, 2, 1), (1, 1, 2, 1), -> (1, 1, 2, 2), (1, 2, 1, 1), -> (1, 2, 2, 1), (1, 2, 2, 2);Query OK, 8 rows affected (0.00 sec)Records: 8 Duplicates: 0 Warnings: 0mysql> explain select * from tt where a = 1;+----+-------------+-------+------+---------------+------+---------+------+------+-------------+| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |+----+-------------+-------+------+---------------+------+---------+------+------+-------------+| 1 | SIMPLE | tt | ALL | ind_a | NULL | NULL | NULL | 48 | Using where |+----+-------------+-------+------+---------------+------+---------+------+------+-------------+1 row in set (0.00 sec)mysql>