Movatterモバイル変換

TheInnoDB transaction model aims to combine the best properties of amulti-versioning database with traditional two-phase locking.InnoDB performs locking at the row level and runs queries as nonlockingconsistent reads by default, in the style of Oracle. The lock information inInnoDB is stored space-efficiently so that lock escalation is not needed. Typically, several users are permitted to lock every row inInnoDB tables, or any random subset of the rows, without causingInnoDB memory exhaustion.