All posts by Ståle Deraas

About Ståle Deraas

Ståle Deraas has been working with MySQL Database team since 2008. He is currently employed by Oracle, based in Norway. He is Senior Software Development Manager for the runtime team of the MySQL Database. He has a background in the database industry, working for Sun Microsystems on Java DB, and prior to that on Software Development Tools. He has a B.Sc Hons degree in Computing Science from the University of Glasgow.

MySQL 8.0: Data Dictionary Architecture and Design

This blog post elaborates on the architecture and design of the transactional data dictionary that will be part of MySQL 8.0. Some descriptions of architecture will be implemented in later versions. See  MySQL 8.0 Data Dictionary:  Background and motivation.

The MySQL Data Dictionary Schema
dd-in-innodb-tables
The Transactional Data Dictionary in 8.0 has a simplified and uniform handling of dictionary data

Dictionary  tables and system tables store data and meta data needed by the MySQL server.…