Physically cluster a MYSQL table for better performance
- by ming yeow
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?