MySQL query Cache

The query cache of the MySQL server is enabled. The following command is used to view the query cache parameters:

# Whether to enable the current feature
Select @ query_cache_type;
# Current application or not
Show variables like 'have _ query_cache ';
# The cache value currently set. If it is 0, it indicates that it is not enabled and has not been applied.
Select @ Global. query_cache_size;
# Set the cache value of the server, in bytes, 1 m = 1048576 bytes. The following is the configured 10 m.
Set @ Global. query_cache_size = 10485760;