Shulou(Shulou.com)06/01 Report--

When performing sql optimization, the first check is very slow, and the second check is very fast because it is checked in the flush cache.

So you can't see whether it's the effect of optimization or the effect of caching queries.

Therefore, it is best to close the cache to execute sql when optimizing

command is as follows

Select SQL_NO_CACHE * from tbl_picture4

If you need to turn off caching

modify parameter query_cache_type

query_cache_type=0

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.