By default for MySQL server, InnoDB Engine is getting used widely due it’s ACID support, optimized read-write performance and for many other reasons which are great significance for the database server.
In this blog post, we are going to cover the InnoDB tablespace and its features like,
- InnoDB engine tablespaces
- Tablespace Data Encryption
- Tablespace related Configuration
InnoDB engine tablespaces System tablespace:
Common tablespace for MySQL server operations. Apart from the table data storage, InnoDB’s functionality requires looking for table metadata, storing and retrieving MVCC info to support ACID compliance and Transaction Isolation. It contains several types of information for InnoDB objects.
Table Data Pages
Table Index Pages …