MySQL 8.0 Reference Manual  /  MySQL Data Dictionary  /  Transactional Storage of Dictionary Data

Pre-General Availability Draft: 2017-05-26

15.3 Transactional Storage of Dictionary Data

The data dictionary schema stores dictionary data in transactional (InnoDB) tables. Data dictionary tables are located in the mysql database together with non-data dictionary system tables.

In MySQL 8.0.0 and 8.0.1, data dictionary tables are created in individual file-per-table tablespaces, which are located in the in the mysql database directory. As of MySQL 8.0.2, data dictionary tables are created in a single InnoDB tablespace named mysql.ibd, located in the MySQL data directory.

Dictionary data is now protected by the same commit, rollback, and crash-recovery capabilities that protect user data stored in InnoDB tables.

User Comments
Sign Up Login You must be logged in to post a comment.