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

Mr Pete

<p>The (mu-compatible) WP Tuner plugin for WordPress is a powerful and easy to use way to answer many hard questions about why your blog is slow or cranky. What’s causing the slowdown? Is it a plugin? Is it your host?</p>
<p>Used with a bit of common sense, this powerful plugin will help blog administrators as well as software developers improve their WordPress blog performance.</p>
<p>Perfect for WordPress site administrators, plugin and theme designers, developers</p>
<p>Fully translatable.</p>
<h3>Advanced Use</h3>
<p>Here are more advanced ways to make use of <em>WP Tuner</em>. Please <a href="http://blogs.icta.net/plugins/wptuner" title="(Visit the WP Tuner home page)" rel="nofollow ugc">share your questions and/or stories</a> examples to share with others!</p>
<p>1) Hook any WordPress action</p>
<p>In wptuner.php, you will find a default set of action hooks. You can add as many hooks as you like for other actions. They look like this (just change “admin_footer” to the name of the action you want to measure):</p>
<pre><code>add_action('admin_footer', 'wpTuneFilterTime' );
</code></pre>
<p>Each hook adds a line to the <em>WP Tuner</em> performance analysis table, when that action is triggered.</p>
<p>2) Time anything at all in WordPress</p>
<p>WP Tuner contains a function that causes performance analysis for any section of WordPress code. Just use<br />
  wpTuneMarkTime(‘My Marker string’);</p>
<p>…at the beginning of the code you want analyzed. Add another marker at the end if needed.</p>
<p>For example, suppose you want to know how much time is spent loading each of the plugins you have enabled. Here’s how to do it, by adding two simple lines to wp-settings.php:</p>
<pre><code>if (function_exists(wpTuneMarkTime)) wpTuneMarkTime('Load Plugins'); // ** Add THIS line **

if ( get_option('active_plugins') ) {
  $current_plugins = get_option('active_plugins');
  if ( is_array($current_plugins) ) {
    foreach ($current_plugins as $plugin) {
      if (function_exists(wpTuneMarkTime)) wpTuneMarkTime('Plugin: '.$plugin); // ** Add THIS line **
      if ( '' != $plugin && 0 == validate_file($plugin) && file_exists(WP_PLUGIN_DIR . '/' . $plugin) )
        include_once(WP_PLUGIN_DIR . '/' . $plugin);
    }
  }
}<h3>Credits</h3>
</code></pre>
<p>Many thanks to the WP Tuner translation team!</p>
<p>Русский: <a href="http://lecactus.ru" rel="nofollow ugc">Кактусу</a> (updated through WP Tuner 0.9.3)</p>
<h3>Readme Validator</h3>
<p>This readme was validated using:<br />
<a href="https://wordpress.org/extend/plugins/about/validator/" rel="ugc">https://wordpress.org/extend/plugins/about/validator/</a></p>


WP Tuner

Easily, powerfully, discover why your blog or plugin is slow or cranky. Comprehensive time and database access analyzer. WPmu. multi-lingual.

MySQL query cache stats vs WP Tuner