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

This article introduces the knowledge of "the use of Query Cache in different environments". Many people will encounter this dilemma in the operation of actual cases, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

The function of Query Cache is to cache the result set of select statements. The query cache stores the corresponding result that the text of a select query is passed to the crying side. If the same query is received later, the server will retrieve the results from the query cache, and the text will not analyze and execute the same query again.

Query caching never goes back on expired data. When the data is modified, the data in the query cache will be cleared. If some tables are not changed frequently and a large number of the same queries are executed, the query cache is very useful.

If there are few writes and frequent reads in the environment, opening query_cache_type=1 will significantly improve performance.

If there are a lot of write operations in the environment, it is not appropriate to turn on this parameter, query_cache_type=0, and set the following parameters:

Close QCACHE

Query_cache_size=0

Query_cache_type=0

Query_cache_limit=0

Open QCACHE

Query_cache_size=1

Query_cache_type=1

Query_cache_limit=1

This is the end of the content of "the use of Query Cache in different environments". Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.