Javier Casares

darkmarsuk

Andrew Hutchings

<p>MariaDB Health Checks helps you debug your MariaDB database with advanced information from your database.</p>
<ul>
<li>Shows relevant information about the Database, Logs, Locale, Connnections, Character Set and Collation, and Options.</li>
<li>Shows a graph of the MariaDB average execution time (7 days by default) and its data.</li>
<li>Allows enabling of MariaDB optimizer histograms for improved MariaDB performance.</li>
<li>Checks that your MariaDB version is still supported.</li>
</ul>
<h3>Contributors</h3>
<ul>
<li><a href="https://github.com/MariaDB/wordpress-mariadb-health-checks/graphs/contributors" rel="nofollow ugc">Plugin contributors at GitHub</a></li>
</ul>


MariaDB Health Checks


The database is often the bottleneck for WordPress, so using this plugin to quickly identify what is going on with the database is very handy!


Handy for MariaDB users

MariaDB Health Checks helps you debug your MariaDB database with advanced information from your database.

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

MariaDB Health Checks vs MySQL query cache stats