Hamka
First, "query_cache_size"
‘MySQL query cache’ is a more controversial feature. Let me talk about my personal suggestion: When you are using caching software such as'redis' or'memcached', you can set the value of'query_cache_size' to 0 (0 is off); however, when you are not using caching software, there is extra When the database performance encounters a bottleneck, you can try to enable the "query cache".
This is a function that relies heavily on the data table structure and SQL statement optimization. If the data table structure and SQL statements are optimized for the query cache, it The effect is still very good.