See inline notes.

Another thing -- you might get a SMALLER data file if you flagged the
indices containing your AUTOINC field (which must be unique anyway) as
UNIQUE. This will use a more compact index structure, which should save
disk space (and thus memory) in the file.