(mysql.info.gz) InnoDB physical structure

(mysql.info.gz) InnoDB Insert buffering

 
 15.14.1 Physical Structure of an Index
 --------------------------------------
 
 All indexes in `InnoDB' are B-trees where the index records are stored
 in the leaf pages of the tree. The default size of an index page is
 16KB. When new records are inserted, `InnoDB' tries to leave 1/16 of
 the page free for future insertions and updates of the index records.
 
 If index records are inserted in a sequential order (ascending or
 descending), the resulting index pages will be about 15/16 full.  If
 records are inserted in a random order, the pages will be from 1/2 to
 15/16 full. If the fillfactor of an index page drops below 1/2,
 `InnoDB' tries to contract the index tree to free the page.

Info Catalog

(mysql.info.gz) Table and index

(mysql.info.gz) InnoDB Insert buffering

automatically generated byinfo2html