You are here
ER-Diagram of the InnoDB Data Dictionary
Fri, 2011-07-29 17:37 — Shinguz
With the new MySQL 5.6 release there are some more InnoDB Data Dictionary Tables in the INFORMATION_SCHEMA:
New with MySQL 5.5 are:
| INNODB_CMP |
| INNODB_CMP_RESET |
| INNODB_CMPMEM |
| INNODB_CMPMEM_RESET |
| INNODB_TRX |
| INNODB_LOCK_WAITS |
| INNODB_LOCKS |
New with MySQL 5.6 are:
| INNODB_BUFFER_PAGE |
| INNODB_BUFFER_PAGE_LRU |
| INNODB_BUFFER_POOL_STATS |
| INNODB_FT_CONFIG |
| INNODB_FT_DELETED |
| INNODB_FT_DEFAULT_STOPWORD |
| INNODB_FT_INDEX_CACHE |
| INNODB_FT_BEING_DELETED |
| INNODB_FT_INDEX_TABLE |
| INNODB_FT_INSERTED |
| INNODB_METRICS |
| INNODB_SYS_COLUMNS |
| INNODB_SYS_FIELDS |
| INNODB_SYS_FOREIGN |
| INNODB_SYS_FOREIGN_COLS |
| INNODB_SYS_INDEXES |
| INNODB_SYS_TABLES |
| INNODB_SYS_TABLESTATS |
The INNODB_SYS tables where already available before but not accessible via SQL. You could see them by enabling the InnoDB Table Monitor.
To get a rough overview how they are related to each other we have reverse engineered the ER Diagram of the InnoDB Data Dictionary. Please let us know when you see any error or if something is missing...
Have fun!
Oli
innodb_dd.pdf (PDF: 93k)
Taxonomy upgrade extras:
- Shinguz's blog
- Log in or register to post comments