Load/redis memory/mysql query cache

Top

P CPU Sequencing

M Cache ratio Sort

Login REDIS-CLI

Info memory

The MySQL query cache is based on the SQL query statement to calculate the hash value, the query cache into a list of hash, if the related data table changes, the system will make the relevant query cache invalidation

Have_query_cache whether the query cache is supported

Query_cache_limit Query Cache single largest result set

Query_cache_min_res_unit Query cache minimum result set

Query_cache_size System allocation query cache memory size

Query_cache_type the system is open Query_cache

The query cache is suitable for infrequently changing tables, and thousands of concurrent queries can be queried for the cache hash list to bring resource consumption or large

Load/redis memory/mysql query cache