InnoDB Transaction ModelInnoDB transaction model, the goal is to combine the best properties of a multi-versioning database with traditional two-phase locking.
InnoDB does locking on the row level and runs queries as non-locking consistent reads by default, in the style of Oracle.
InnoDB is stored so space-efficiently that lock escalation is not needed.
InnoDB running out of memory.
Are there any InnoDB performance tuning tips?
© 2007 John Michael Pierobon