January 2019
Intermediate to advanced
286 pages
7h 41m
English
Content preview from Advanced MySQL 8
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Applications of the data dictionary
In this section, we will explore and summarize the different uses of the data dictionary.
Previously, to prevent the creation and destruction of tables or databases:
- It was necessary to enable the innodb_read_only variable for protection, which impacted only the InnoDB engine. Now, with MySQL version 8.0, all storage engines are affected.
- One of the functionalities in MySQL 8.0 has been improved, the data dictionary tables are protected and not visible, and the INFORMATION_SCHEMA is more stable.
- The tables of INFORMATION_SCHEMA are now connected directly to the data dictionary. This allows the optimizer to use indexes continuously live, resulting in better performance.
- Before MySQL 8.0, we could use ...