There is few information about the read path or write path with respect to the role of metadata or index. I mean I cannot really understand how InnoDB manage its metadata, and when to access it in order to execute a query.
Can you please name some keyword or provide docs which could make this clear?
Thank you very much!
As of MySQL 5.6, you can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA system tables.
Read more on oracles website: https://docs.oracle.com/cd/E17952_01/mysql-5.6-en/innodb-information-schema-system-tables.html