|
Innter.Net© supports the InnoDB as well as the MyISAM storage engines for MySQL databases.
InnoDB
InnoDB is the description for the transaction-oriented MySQL storage engine by Innobase Oy Inc.
Unlike the commonly used MyISAM engine, InnoDB supports transactions, which means:
- All write operations can be undone (rolled back)
- Repeated read accesses within a transaction are not affected by write accesses of other transactions (Isolation from ACID)
- Write accesses in a transaction cause the affected rows to be locked for writing by other transactions (row level locking)
Additionally, InnoDB is the only MySQL engine which guarantees the referential integrity of foreign keys.
InnoDB is supported by all Business Webserver plans.
MyISAM
MyISAM distinguishes itself with high efficiency when compared to other table types supported by MySQL, and it supports an efficient full-text search. However, as opposed to InnoDB, MyISAM does not support transactions or referential integrity. |
