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

Call the police today with an error:host xxxx has more lowmem_prunes,please add Memory....

This alarm was written by a shell script.

Qcache_lowmem_prunes= `$ Procedure_source-h$host-P$Port-uadmin-pxxxx-e "show status" | grep "Qcache_lowmem_prunes" | awk'{print $2} '`if [$Qcache_lowmem_prunes-gt 700000000] thenecho "$host has more lowmem_prunes,please add Memory" | mail-s "$host has more lowmem_prunes,now lowmem_prunes is $Qcache_lowmem_prunes `date +% R% F" `"$maillist elseecho" $host lowmem_prunes ok "fi

The official document's interpretation of Qcache_lowmem_prunes:

The number of queries that were deleted from the query cache because of low memory.

It probably means that the cache pool is full, resulting in query pruning.

Combined with the following two articles, the decision is made as follows: change the my.cnf file, query_cache_type=1- > 0 query_cache_size=1G- > 0

Be sure to restart

Reference: http://t.cn/RAF4d7z http://t.cn/RAF4d7Z

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.