How does MySQL Query Cache work?

Question

MySQL

Does mysql consider the frequency of accesses to a particular query in the cache? The cache size is limited by the query_cache_size=128M option, but how will the cache behave when this limit is filled? Will those requests that are often taken from the cache be taken into account and Mysql will leave them in the cache, and delete those that are rarely requested? Should I force the SQL_NO_CACHE option with queries that are rarely repeated to avoid PUSHING the desired data out of the cache? Or am I worrying in vain and MySQL itself understands what data in the cache is often accessed and tries to save them in the first place?

Answer 1

When the limit is reached, old entries are simply deleted, the frequency of use is not taken into account.
https://github.com/MariaDB/server/blob/4243785f288...
It's better not to rely on the query cache, but in the application to decide what, where to cache and how to invalidate the cache.

Answer 2

The first link in Google for Mysql Query Cache
https://m.habr.com/en/post/41166/