Shulou(Shulou.com)05/31 Report--

This article mainly explains the "mysql query cache and innodb cache recovery mechanism explanation", the content of the article is simple and clear, easy to learn and understand, now please follow the editor's ideas slowly in depth, together to study and learn "mysql query cache and innodb cache recovery mechanism explanation" bar!

1 what the cache has in common is based on physical memory, and physical memory is limited

Mysql query cache

Cache until cache size is used up, follow FIFO cache strategy (first-in, first-out algorithm)

When the table data is written or updated, the cache associated with the table is invalidated.

Innodb cache reclaim

1. Insert cache is reclaimed through dirty pages and checkpoint mechanism

two。 Query the data cache. When the innodb_buffer_pool_size is full, use the LRU algorithm to reclaim it.

The LRU (Least recently used, least recently used) algorithm eliminates data according to its historical access records, and its core idea is that "if the data has been accessed recently, it is more likely to be accessed in the future."

Thank you for your reading, the above is the "mysql query cache and innodb cache recovery mechanism explanation" content, after the study of this article, I believe you on the mysql query cache and innodb cache collection mechanism to explain this issue has a deeper understanding, the specific use of the need for you to practice and verify. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.