MySQL Sub-table

Sub-table strategy

1, according to the characteristics of the time table, different days, the time may be uneven, some more, some less, and may appear too large data volume situation

2, according to the hash Modulus sub-table (or primary key to mold) features: Interval lookup is not the same data table, difficult to find, the number of barrels can not be increased, increase the need to refactor

3, Binary shift sub-table features: more flexible, but the data segmentation location is more difficult to control, so the interval lookup is difficult to achieve.

General right Shift 23 bits, can be divided into 1.5G table, each row 180B calculation

MySQL Sub-table