Re: Text(1024)
Posted by:
Rick James
Date: April 03, 2011 10:29PM
In MyISAM, the leaf node of an Index (in the .MYI file) contains a pointer to the data record (in the .MYD file). For FIXED, this pointer is a record number; for DYNAMIC it is a byte offset. The only difference in lookup is whether it has to multiply by the record size to get the byte offset.
In InnoDB, FIXED is irrelevant. Everything (data and indexes) is in BTree structure in 16KB-sized blocks. There are big numbers (6-byte?) to point to a block. Within the block is a complex structure, wherein the hundred (or so) records in the block can be located. The complexity is largely for Transactional processing.
Subject
Written By
Posted
Re: Text(1024)
April 03, 2011 10:29PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.