(mysql.info.gz) InnoDB overview
Info Catalog
(mysql.info.gz) InnoDB
(mysql.info.gz) InnoDB
(mysql.info.gz) InnoDB contact information
15.1 `InnoDB' Overview
======================
`InnoDB' provides MySQL with a transaction-safe (`ACID' compliant)
storage engine with commit, rollback, and crash recovery capabilities.
`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 in `InnoDB' fit in
very little space. `InnoDB' also supports `FOREIGN KEY' constraints.
In SQL queries you can freely mix `InnoDB' type tables with other table
types of MySQL, even within the same query.
`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 as of MySQL 4.0.
For information about `InnoDB' support in MySQL 3.23, see InnoDB
in MySQL 3.23. Starting from MySQL 4.1.5, the new Windows installer
makes `InnoDB' the MySQL default table type 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'.
`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/'.
Info Catalog
(mysql.info.gz) InnoDB
(mysql.info.gz) InnoDB
(mysql.info.gz) InnoDB contact information
automatically generated byinfo2html