| Careerhunt - Fast track your career as a ninja

InnoDB vs ISAM


  • administrators

    InnoDB is the storage engine that was used in this thesis, and it is therefore
    only InnoDB that is described here. It is the most complex storage engine in
    MySQL, where transactions, foreign keys, row-level locks and multi-versioning are
    supported. However, the most interesting part is how the data is stored. InnoDB
    uses something called clustering index, and this is a B-tree where the primary key
    is the key in the tree and the record in the data part. This implies that each table
    must have a primary key, however if it is not specified by the user, InnoDB creates
    one not visible to the user [42].


Log in to reply
 

Looks like your connection to CareerHunt was lost, please wait while we try to reconnect.