In MySQL, there are many caching mechanisms, such as key cache, query cache, and table cache. While the key cache holds index blocks to facilitate index lookups, the query cache keeps the results of frequently conducted queries in memory.
To speed up table operations, the table cache saves table information in memory.
