MySQL 8.0 implements atomic and crash-safe DDL. We will discuss how this affects behaviour of individual DDL statements, binlog and crash-safeness. We will also discuss the role of InnoDB as a data dictionary SE and a user tables SE, and touch upon requirements for writing a data dictionary SE for MySQL.
MySQL 8.0 implements I_S as views over dictionary tables stored in InnoDB. There are legacy features that require queries to SE. What is the impact of this, and how to make a compromise between updated and fast information.
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.