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

Filed under:
|
|

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

Related posts about mysql

Related posts about database-design