![]() ![]() ![]() When the query cache is enabled and a new SELECT query is processed, the query cache is examined to see if the query appears in the cache. See Limiting the size of the Query Cache below for details. Starting from MariaDB 10.1.7, query_cache_type is automatically set to ON if the server is started with the query_cache_size set to a non-zero (and non-default) value. If needed set the cache to a size large enough amount, for example: SET GLOBAL query_cache_size = 1000000 From 10.1.7 on the cache size defaults to 1MB. It is enabled by default in MariaDB versions up to 10.1.6, but disabled starting with MariaDB 10.1.7 - if needed enable it by setting query_cache_type to 1.Īlthough enabled in versions prior to MariaDB 10.1.7, the query_cache_size is by default 0KB there, which effectively disables the query cache. To see if the cache is enabled, view the query_cache_type server variable. If this is set to NO, you cannot enable the query cache unless you rebuild or reinstall a version of MariaDB with the cache available. SHOW VARIABLES LIKE 'have_query_cache' + -+-+ | Variable_name | Value | + -+-+ | have_query_cache | YES | + -+-+ The have_query_cache server variable will show whether the query cache is available. Unless MariaDB has been specifically built without the query cache, the query cache will always be available, although inactive. Note that the query cache cannot be enabled in certain environments. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |