Re: How to speed up query of indexed column with 5M rows?

[ryan zheng]

"ANALYZE TABLE flow " should be the same as "myisamchk -a flow.MYI".

After analyze the table again, mysql truly use the index now.


mysql> explain select * from flow where owner=25514;
+----+-------------+-------+------+-----------------+-----------------+---------+-------+------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+------+-----------------+-----------------+---------+-------+------+-------------+
| 1 | SIMPLE | flow | ref | flow_fk_owner | flow_fk_owner | 4 | const | 1 | Using where |
+----+-------------+-------+------+-----------------+-----------------+---------+-------+------+-------------+
1 row in set (0.04 sec)

Thanks.
About Larry Kagan and Toa Sty 's solutions, I will try later, and give you a report.