Recordlength: 149
Table Description:

Key Start Len Index Type Rec/key Root Blocksize

1 1 4 Unique Unsigned Long 1 4535296 1024

2 5 2 Multip. Unsigned Short 13776 12540928 1024

3 111 4 Multip. Unsigned Long 1 18854912 1024

4 28 3 Multip. Uint24 18 24546304 1024

5 7 3 Multip. Uint24 7 32827392 1024

111 4 Unsigned Long 1

6 7 3 Multip. Uint24 7 40418304 1024

28 3 Uint24

The thing of hearten making a person happened, the Max Datafile Length of this watch: 281474976710654 Max Keyfile Length: 4398046510079, namely dimension of the biggest data (MYD file) achieved 2TB, measure of the oldest index (MYI) still is 4G.

The 4G limitation that acquiesces from this was broken through. About among them principle, actually very simple: Assume you have a diary this, there is 10 pages paper to be able to write a thing above, weave catalog needs a byte only (because of 0 ～ 9 enough) . If you fill in this notebook into two pieces of paper again, become 12 pages, the catalog space of a byte cannot search location to arrive in the two pages from the back, produced a mistake then. Above the numerical value in that ALTER statement is me succeed to assure, extraction bigger cost (because ALTER is too slow really, do not have time to experiment in that chaos) , be equivalent to telling a database, this notebook has 1000000000 pages, every page has 15000 byte on average. Such databases know this is a very big edition, because of this do one's best took out 100 pages (say suppose) do catalog to weave, this such new directory can search location to arrive diary this all content. The mistake disappears.

The defect of only is, the space that catalog takes up is a few more, but already very little, made this kind of change actually the file dimension size of 4G increased 1M only much, special rise with force and spirit making a person.