commit, rollback, crash recovery 기능을 가진 transaction-safe MySQL을 제공합니다.
로우 레벨에서 locking을 하며, SELECT 문 사용시 Oracle-style과 일치하는 non-locking을 지원합니다.
이런 특징들은 멀티유저 동시성과 성능을 증가시켜 줍니다.
FOREIGN KEY 제약을 지원하며, 다른 MySQL 저장엔진과 혼합 사용이 가능합니다.
InnoDB provides MySQL with a
ACID compliant) storage engine that has commit, rollback, and crash recovery
InnoDB does locking on the row level and also provides an Oracle-style consistent
non-locking read in
SELECT statements. These features increase multi-user concurrency and
performance. There is no need for lock escalation in
InnoDB because row-level locks fit in very little space.
InnoDB also supports
FOREIGN KEY constraints. You can freely mix
InnoDB tables with tables from other MySQL storage engines,
even within the same statement.
InnoDB has been designed for
maximum performance when processing large data volumes. Its CPU efficiency is
probably not matched by any other disk-based relational database engine.
Fully integrated with MySQL Server, the
InnoDB storage engine maintains its own buffer pool for caching
data and indexes in main memory.
InnoDB stores its tables and indexes in a tablespace, which may consist of
several files (or raw disk partitions). This is different from, for example,
MyISAM tables where each table is stored using separate files.
InnoDB tables can be of any size even on operating systems
where file size is limited to 2GB.
InnoDB is included in binary
distributions by default. The Windows Essentials installer makes
InnoDB the MySQL default storage engine on Windows.
InnoDB is used in production
at numerous large database sites requiring high performance. The famous
Internet news site Slashdot.org runs on
InnoDB. Mytrix, Inc. stores over 1TB of data in
InnoDB, and another site handles an average load of 800
inserts/updates per second in
InnoDB is published under
the same GNU GPL License Version 2 (of June 1991) as MySQL. For more
information on MySQL licensing, see http://www.mysql.com/company/legal/licensing/.
A forum dedicated to
InnoDB storage engine is
available at http://forums.mysql.com/list.php?22.