MySQL 8.0: Data Dictionary & Information Schema

[Edwin Desouza]

MySQL 8.0: Overview
- http://mysqlserverteam.com/the-mysql-8-0-0-milestone-release-is-available/

slides:
- https://www.slideshare.net/StleDeraas/data-dictionary-pl17

MySQL 8.0: Data Dictionary
- http://mysqlserverteam.com/the-unified-data-dictionary-lab-release/
- http://mysqlserverteam.com/mysql-8-0-data-dictionary-status-in-the-8-0-0-dmr/
- https://mysqlserverteam.com/bootstrapping-the-transactional-data-dictionary/
- http://mysqlserverteam.com/mysql-server-bootstrapping-and-dictionary-initialization/
- http://mysqlserverteam.com/mysql-8-0-data-dictionary-architecture-and-design/
- http://mysqlserverteam.com/mysql-8-0-data-dictionary-background-and-motivation/
- http://mysqlserverteam.com/a-new-data-dictionary-for-mysql/
- http://www.tocker.ca/2014/07/30/beyond-the-frm-ideas-for-a-native-mysql-data-dictionary.html

MySQL 8.0: Information Schema
- https://mysqlserverteam.com/further-improvements-on-information_schema-in-mysql-8-0-3/
- http://mysqlserverteam.com/mysql-8-0-scaling-and-performance-of-information_schema/
- http://mysqlserverteam.com/mysql-8-0-improvements-to-information_schema/

MySQL 8.0 General Tablespaces: InnoDB-File-Per-Schema (and no FRM files)
- https://www.percona.com/blog/2016/10/03/mysql-8-0-general-tablespaces-file-per-database-no-frm-files/
- https://bugs.mysql.com/bug.php?id=80431

MySQL 8.0: "hidden" Data Dictionary Tables
- http://lefred.be/content/mysql-8-0-data-dictionary-tables-and-why-they-should-stay-protected/
- http://datacharmer.blogspot.co.uk/2017/04/revisiting-hidden-mysql-80-data.html
- https://datacharmer.blogspot.co.uk/2016/09/showing-hidden-tables-in-mysql-8-data.html


MySQL 8.0: deep-dive into DD + SDI
- http://www.tusacentral.net/joomla/index.php/mysql-blogs/206-mysql-8-and-the-frm-drop.html


MySQL 8.0: Keywords
- https://dev.mysql.com/doc/refman/8.0/en/keywords-table.html
- https://lefred.be/content/mysql-8-0-and-keywords/

Misc:
- https://mysql.wisborg.dk/2018/11/11/tracking-foreign-keys/



Edited 18 time(s). Last edit at 02/12/2019 10:25AM by Edwin Desouza.