Detailed introduction to query_cache_size

MySQL query cache has been available since version 4.1, but it is worth studying it today. Under the default configuration, this function of MySQL is not enabled. You may find that the value of the variable have_query_cache is yes through show variables like '%query_cache%'; MYSQL beginners can easily think that if this parameter is YES, it means that query is enabled. Caching is actually wrong. This parameter indicates whether the current version of MYSQL supports Query Cache. In fact, whether to enable query cache depends on the value of another parameter: query_cache_size. The value is 0, which means query cache is disabled, and the default configuration is correct. is configured as 0. Configuration method: Find the following content in the MYSQL configuration file my.ini or my.cnf: # Query cache is used to cache SELECT results and later return them# without ac

1. Analyze the MySQL cache startup method and parameters (query_cache_size)

##Introduction: MySQL query cache starts from version 4.1 It is provided, but it is worth researching it today. Under the default configuration, this function of MySQL is not enabled. You may find that the value of the variable have_query_cache is yes through show variables like '%query_cache%'; MYSQL beginners can easily think that if this parameter is YES, it means that query is enabled. Caching is actually incorrect. This parameter is

2. Detailed explanation of MySQL cache startup method and parameters (query_cache_size)

Introduction: MySQL query cache has been provided since version 4.1, but it is worth studying it today. Under the default configuration, this function of MySQL is not enabled. You may find that the value of the variable have_query_cache is yes through show variables like '%query_cache%';. MYSQL beginners can easily think that if this parameter is YES, it means it is enabled.

3. Detailed explanation of MySQL cache startup method and parameters (query_cache_size)_MySQL

The above is the detailed content of Detailed introduction to query_cache_size. For more information, please follow other related articles on the PHP Chinese website!