Physically cluster a MYSQL table for better performance
Posted
by ming yeow
on Stack Overflow
See other posts from Stack Overflow
or by ming yeow
Published on 2010-05-29T22:56:14Z
Indexed on
2010/05/29
23:02 UTC
Read the original article
Hit count: 227
I have a 30M row table, which is indexed by ID now. However, a lot of the requests are around a much smaller subset, which is identified by app_user=1
Does it make sense to physically cluster the table according to this? If so, how can I do so?
© Stack Overflow or respective owner