MENU
InnoDB
Balancing high reliability and performance, InnoDB is the default storage engine.The advantages of using InnoDB are:
- The DML (Data Manipulative Language) operations follow the ACID (atomicity, consistency, isolation and durability) model, featuring commit, rollback, and crash-recovery capabilities.
- Row-level locking and Oracle-style consistent reads increase performance and multi-user concurrency.
- The tables arrange your data on disk to optimize queries based on primary keys.
- FOREIGN KEY constraints are supported.
- You can freely mingle InnoDB tables with tables from other storage engines, even within the same statement. For example, you can use a join operation to combine data from InnoDB and MEMORY tables in a single query.
- InnoDB has been designed for maximum performance when processing large data volumes.
- InnoDB maintains its own buffer pool for caching data and indexes in main memory.
- The tables can handle a lot of data, even on operating systems where the file size is limited to 2GB.
| Storage Limits | 64TB |
| Transactions | Yes |
| Locking granularity | Row |
| MVCC | Yes |
| Geospatial data type support | Yes |
| Geospatial indexing support | No |
| B-tree indexes | Yes |
| B-tree indexes | No |
| Hash indexes | No |
| Full-text search indexes | Yes |
| Clustered indexes | Yes |
| Data caches | Yes |
| Index caches | Yes |
| Compressed data | Yes |
| Encrypted data | Yes |
| Cluster database support | No |
| Replication support | Yes |
| Foreign key support | Yes |
| Backup/ Point-in-time recovery | Yes |
| Query cache support | Yes |
| Update statistics for data dictionary | Yes |