From 08604d7f08339162238f21e06f848e9606c9ad4e Mon Sep 17 00:00:00 2001 From: Tyron Madlener Date: Sat, 20 Aug 2011 14:18:53 +0300 Subject: [PATCH] duplicate rule name --- libraries/advisory_rules.txt | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/libraries/advisory_rules.txt b/libraries/advisory_rules.txt index f13f838890..bbc8d5c6fd 100644 --- a/libraries/advisory_rules.txt +++ b/libraries/advisory_rules.txt @@ -127,7 +127,7 @@ rule 'Query cache disabled' The query cache is known to greatly improve performance if configured correctly. Enable it by setting {query_cache_size} to a 2 digit MiB value and setting {query_cache_type} to 'ON'. Note: If you are using memcached, ignore this recommendation. query_cache_size is set to 0 or query_cache_type is set to 'OFF' -rule 'Query cache usage' [!fired('Query cache disabled')] +rule 'Query caching method' [!fired('Query cache disabled')] Questions / Uptime value > 100 Suboptimal caching method. @@ -141,7 +141,7 @@ rule 'Query cache efficiency (%)' [Com_select + Qcache_hits > 0 && !fired('Query Consider increasing {query_cache_limit}. The current query cache hit rate of %s% is below 20% | round(value,1) -rule 'Query Cache usage' [!fired('Query cache disabled')] +rule 'Query cache usage' [!fired('Query cache disabled')] 100 - Qcache_free_memory / query_cache_size * 100 value < 80 Less than 80% of the query cache is being utilized. -- 2.11.4.GIT