2011-04-06 14:37:09 0 Comments MySQL Boy.Lee

MySQL Schema optimize

{Rules One}

use less join

{Rules Two}

split big field - cut IO cost, move less frequency fields out.

{Rules Three}

split big table to small by type

{Rules Four}

static table use cache strategy