MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0

16.4 Dictionary Object Cache

The dictionary object cache is a shared global cache that stores previously accessed data dictionary objects in memory to enable object reuse and minimize disk I/O. Similar to other cache mechanisms used by MySQL, the dictionary object cache uses an LRU-based eviction strategy to evict least recently used objects from memory.

The dictionary object cache comprises cache partitions that store different object types. Some cache partition size limits are configurable, whereas others are hardcoded.

For information about valid values for dictionary object cache configuration options, refer to Section 7.1.8, “Server System Variables”.