Z
Z
Zikdelk2021-07-12 15:29:43
1C-Bitrix
Zikdelk, 2021-07-12 15:29:43

Query cache (size) 512 MB. Query cache size (query_cache_size) is over 128M. This may lead to a drop in performance. What to do with it?

Performance monitor: database server.

I got the following message:
Query cache (size) 512 MB. Query cache size (query_cache_size) is over 128M. This may lead to a drop in performance. What to do with it? What settings should be changed where?

And in the same place:

Query cache (efficiency) 0% If the cache efficiency is less than 20%, then it may be necessary to increase the value of the query_cache_limit parameter (current value: 16 MB)

query_cache_limit - what value should be set?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question