Moris Papasmadov

<p>Admin dashboard widget measuring and monitoring MySQL / MariaDB <a href="https://mariadb.com/resources/blog/flexible-mariadb-server-query-cache" title="MariaDB Query Cache" rel="nofollow ugc">query cache</a> performance & statistics – to optimize sizing configuration and highlight bottlenecks.</p>
<h4>Why</h4>
<p>Database Query for <a href="https://kinsta.com/knowledgebase/wp-options-autoloaded-data/#what-is-the-wp_options-table" title="What is the wp_options table" rel="nofollow ugc">Options Autoload</a> is repeatedly executed for each WP page load and its poor performance has been identified as a good indicator for a poorly performing database resulting in slow site.</p>
<h4>How</h4>
<ul>
<li>Use dashboard widget to measure and monitor <code>Options Autoload Query Time</code></li>
<li>Use dashboard widget to measure and monitor <code>Options Autoload Query Size</code><br />
This query result size increases constantly over time, as WP site usage grows – but its oversized sudden growth or constant balooning must not be overlooked.</li>
</ul>
<p>Heavy plugins might rely heavily on adding data to <code>Options Autoload Query Size</code>.<br />
Poorly written plugins causing WP performance degradation have been found to constantly increase this query result size.</p>
<h4>Time Metrics</h4>
<p>‘Options Autoload Query Time’ is measured in milliseconds (ms)</p>
<p>0 ms – great performance below one millisecond<br />
 1-2 ms – good performance<br />
 3-5 ms – OK performance<br />
 50+ ms – poor performance should be investigated</p>
<h4>Size Metrics</h4>
<p>‘Options Autoload Size’ is measured in Bytes<br />
If you have the control to enable the database server wide query cache – configure query_cache_limit to be larger than <code>Options Autoload Size</code></p>
<p>20,000 Bytes – freshly installed clean wordpress site<br />
 30,000 Bytes – small wordpress site<br />
 50,000 Bytes – medium wordpress site<br />
 250,000 Bytes – large wordpress site<br />
 2,000,000+ Bytes – too large should be investigated<br />
( <code>all above are rough metrics</code> )</p>


MySQL query cache stats

Admin dashboard widget measuring MySQL database performance & query cache

gl_SPICE

<p>Quick and usefull wordpress tunes!</p>
<ol>
<li>Show resources usage in admin or theme footer</li>
<li>Clean up your HEAD section</li>
<li>Change theme uri (if you want to use subdomain for it)</li>
<li>Quick insert Google Analytics and Yandex Metric codes</li>
</ol>


MySQL query cache stats vs WP Tuning