As stated in the official documentation of MySQL, the dictionary object cache is a global cache shared by MySQL 8.0 that stores previously accessed data dictionary objects in memory to enable object reuse and minimize disk I/O.
It should be mentioned that the concept is similar to other caching mechanisms used by MySQL. The cache of dictionary objects uses a control strategy based on LRU to handle the least recently used memory objects.
It also includes cache partitions that store different types of objects. Some of the limits in the cache partition size are configurable, while others are integrated.
The following is the list of the tables from information_schema:
Tablespaces
|
Tablespace cache partition |
Schema cache partition |
table cache partition |
|
Stores table definition of objects |
Stores schema definition items |
Stores table definition... |
