what is innodb

11 months ago 28
Nature

InnoDB is a storage engine for the MySQL and MariaDB database management systems. It is a general-purpose storage engine that balances high reliability and high performance. InnoDB provides standard ACID-compliant transaction features, along with row-level locking and Oracle-style consistent reads to increase multi-user concurrency and performance. It follows the ACID properties to maintain the integrity of data. InnoDB is the default MySQL storage engine since the release of MySQL 5.5.5 in 2010, replacing MyISAM. InnoDB supports both SQL and XA transactions, tablespaces, foreign keys, full-text search indexes, spatial operations, and virtual columns. It is dual-licensed under the GNU General Public License and can also be licensed to parties wishing to combine InnoDB in proprietary software.