MySQL 8.0: Data Dictionary & Information Schema
Posted by: Edwin Desouza
Date: September 12, 2016 10:39PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL 8.0: Data Dictionary & Information Schema
1233
September 12, 2016 10:39PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.