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

brasofilo

<p>With Admin Tweaks you’ll be able to simplify and make <strong>deep customizations</strong> in the administrative interface.<br />
It’s a compilation of hooks for enhancing, styling and reducing WordPress backend.</p>
<p>Do you like to adjust and style the backend as much as the frontend?<br />
So, we are together!</p>
<h4>Main Features</h4>
<ul>
<li>Admin Bar: remove, add and modify menu items.</li>
<li>Admin Menus: remove menu and submenu items; sort Settings menu; rename “Posts”.</li>
<li>Appearance: hide general elements; create admin notices.</li>
<li>Dashboard: remove and add widgets.</li>
<li>General Settings: enable arcane Link Manager; privacy; other misc options.</li>
<li>Listings: customize rows and columns for post types, users and plugins.</li>
<li>Media: custom columns; re-attachment; sanitize filenames; jpeg quality; audio/photo/video metadata.</li>
<li>Plugins: many row modifications; live filter by keyword/active/inactive; move plugins menus from the main menu into the Tools menu (Code Snippets, The SEO Framework, Hide Admin Notices).</li>
<li>User Profile: remove almost everything; add custom CSS.</li>
<li>Login: redirects; errors; modify almost everything; add custom CSS.</li>
<li>Maintenance Mode: with minimum Role allowed and possibility to block only the backend.</li>
</ul>
<h3>Acknowledgments</h3>
<ul>
<li>Everything changed after <a href="https://wordpress.stackexchange.com/" rel="nofollow ugc">WordPress Stack Exchange</a></li>
<li>Plugin interface using @bainternet’s <a href="https://github.com/bainternet/Admin-Page-Class" rel="nofollow ugc">Admin Page Class</a></li>
<li>CSS for hiding help texts adapted from <a href="https://wordpress.org/plugins/admin-expert-mode/" rel="ugc">Admin Expert Mode</a></li>
<li>Everything started with <a href="https://wordpress.org/plugins/adminimize/" rel="ugc">Adminimize</a>, by Frank Büeltge, which does an awesome job hiding WordPress elements, but I wanted more, and these are some of the great resources where I found many snippets: <a href="https://wordpress.stackexchange.com/questions/1567/best-collection-of-code-for-your-functions-php-file" rel="nofollow ugc">Stack Exchange</a>, <a href="https://wpengineer.com" rel="nofollow ugc">WPengineer</a>, <a href="https://www.wpbeginner.com" rel="nofollow ugc">wpbeginner</a>, <a href="https://css-tricks.com" rel="nofollow ugc">CSS-TRICKS</a>, <a href="https://wp.smashingmagazine.com" rel="nofollow ugc">Smashing Magazine</a>, <a href="https://justintadlock.com" rel="nofollow ugc">Justin Tadlock</a>…</li>
<li>The option to hide the help texts from many areas of WordPress uses the CSS file of the plugin <a href="https://wordpress.org/plugins/admin-expert-mode/" rel="ugc">Admin Expert Mode</a>, by Scott Reilly.</li>
</ul>


Admin Tweaks

This is a really cool plugin helping my everyday work in the admin dashboard. I install it for all my sites. I love it!

Simply awesome!

I found three separate bugs in 5 minutes after download. Is anyone maintaining this plugin in 2020?

3 bugs in 5 minutes

Customize various aspects of WordPress backend. Create a clean and easier admin area for the users.

MySQL query cache stats vs Admin Tweaks