MySQL数据库培训
InnoDB存储引擎 特性介绍
TOPIC
InnoDB History
InnoDB Architecture
Feature
Double Write
Insert/Change Buffer
Adaptive Hash Index
Storage Structure
2
INNODB HISTORY
Heikki Tuuri
Born 1964 in Helsinki, Finland
PhD degree in mathematical logic from the University of
Helsinki, 1990
In 1995, Innobase Oy was founded, to develop InnoDB, a
high performance transactional database engine
In September 2000 Innobase Oy started collaboration with
MySQL AB, which resulted in the release of MySQL that
incorporated InnoDB in March 2001.
In MySQL 5.5, InnoDB becomes default storage engine.
Chinese
Calvin Sun
Jimmy Yang
3
INNODB HISTORY
4
INNODB STORAGE ENGINE
Fully ACID
Row-level locking
Multi-version concurrency control(MVCC)
Foreign key support
Automatic deadlock detection
High performance, high scalability, high
availability
5