About MySQL InnoDB

The preferred engine for transactional databases. It supports acid transactions and row-level locking. InnoDB is designed for maximum performance when processing massive data volumes. The InnoDB Storage engine is fully compatible with the MySQL service.
The InnoDB Storage engine maintains its own buffer pool to cache data and indexes in the main memory. InnoDB stores its tables and indexes in one tablespace. The tablespace can contain several files.
(Or original disk partition ). This is different from the MyISAM table. For example, in the MyISAM table, each table is in a separate file. InnoDB
A table can be of any size, even on an operating system with a file size limited to 2 GB. InnoDB is included in MySQL binary distribution by default. Windows
Essentials installer makes InnoDB the default MySQL table on Windows.

Introduction

InnoDB provides MySQL with a transaction and rollback)
And crash recovery capabilities, multi-versioned concurrency
Transaction-safe (acid compliant) table. InnoDB
Provides locking on Row level and non-locking read in similar to Oracle.
Selects ). InnoDB locks row-level and also provides an oracle-style non-locked read in the SELECT statement. These features increase the deployment and performance of multiple users. Not in
The need to expand locking in InnoDB, because row-level locking in InnoDB is suitable for a very small amount of space. InnoDB also supports foreign
Key. In SQL queries, You can freely mix InnoDB tables with other MySQL tables, or even in the same query. These features are improved
Performance of multi-user concurrent operations. In the InnoDB table, you do not need to expand the lock escalation because InnoDB row-level locking (row level)
Locks) suitable for a very small space. InnoDB is the first MySQL table engine to provide foreign key constraints (foreign key constraints.
Technically, InnoDB is a complete database system on the MySQL background. InnoDB establishes a dedicated buffer pool in the primary memory for high-speed data buffering and indexing.

MYSQL

InnoDB
Store Data and indexes in tablespaces and may contain multiple files. This is different from other types. For example, in MyISAM, tables are stored in separate files. InnoDB
The table size is limited by the file size of the operating system. You can also use independent tablespaces for each table. You only need to enable the innodb_file_per_table option.
In the source code of MySQL, the InnoDB table engine is included from 3.23.34a and activated in the binary version of MySQL-max.