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

remapdb

<p>Remapdb gives customers a clean way to find their vehicle, view tuning gains, choose relevant services, and request a quote, powered by a modern tuning database platform built for real businesses.</p>
<p>This plugin connects WordPress to Remapdb, embeds the Remapdb widget with shortcode, and syncs SEO plus subscription and website status securely.</p>
<p>This plugin provides:</p>
<ul>
<li>Easy connect flow to connect your website to Remapdb.</li>
<li>Shortcode rendering via <code>[remapdb]</code>.</li>
<li>SEO metadata sync from Remapdb:
<ul>
<li>title / meta description</li>
<li>canonical URL</li>
<li>Open Graph tags</li>
<li>JSON-LD</li>
</ul>
</li>
<li>Admin dashboard status:
<ul>
<li>connected widget</li>
<li>subscription status</li>
<li>billing cycle</li>
<li>plan name</li>
</ul>
</li>
<li>host allowance status for this WordPress site</li>
</ul>
<h3>License</h3>
<p>This plugin is licensed under GPLv2 or later.</p>
<p>Remapdb trademarks, logos, and hosted Remapdb platform services are proprietary and not licensed under GPL.</p>
<h3>Requirements</h3>
<ul>
<li>WordPress 6.2+</li>
<li>PHP 8.1+</li>
<li>A Remapdb account</li>
</ul>
<h3>Connect Flow</h3>
<p>The plugin uses a secure authorization flow:</p>
<ol>
<li>WordPress opens a popup to Remapdb connect endpoint.</li>
<li>User authenticates in Remapdb and confirms widget/site connection.</li>
<li>Remapdb returns a one-time authorization code to WP callback.</li>
<li>Plugin exchanges the code for API credentials.</li>
<li>Credentials are stored server-side and used for signed API calls.</li>
</ol>
<p>Notes:<br />
– If hostname is not allowed and plan has a free slot, Remapdb adds it when user confirms Connect.<br />
– If no free slot exists, user can replace an active allowed website during connect.</p>
<h3>Shortcode</h3>
<pre><code>[remapdb]
</code></pre>
<p>Renders the Remapdb widget container for the connected <code>widget_id</code>.</p>
<p>For clean URLs, set one or more pages in the plugin Settings tab (includes Homepage option). Root clean URLs route to Homepage first when selected, otherwise first selected page. URLs like <code>/internal-page/catalog/...</code> route to that page when it is selected.</p>
<h3>SEO Behavior</h3>
<p>On pages where <code>[remapdb]</code> is rendered, the plugin requests SEO payload from Remapdb and applies relevant metadata through WordPress hooks.</p>
<p>The plugin uses caching based on API TTL to reduce API calls and preserve performance.</p>
<h3>Security</h3>
<ul>
<li>Credentials stored server-side only.</li>
<li>API secret is never exposed to frontend JavaScript.</li>
<li>Requests signed with HMAC headers (key, timestamp, nonce, signature).</li>
<li>Nonce + timestamp used for replay protection.</li>
<li>Connect flow protected by PKCE and state validation.</li>
</ul>
<h3>Plugin dashboard</h3>
<p>The plugin dashboard includes:<br />
– Settings (widget connected state, connected widget details, pages where shortcode is added, clean URLs configuration)<br />
– Subscription (subscription status, billing cycle, plan name, host allowance status for this WordPress site, SEO options)<br />
– Widget preview<br />
– Support (contact support, debug and logs, cache management)</p>
<h3>Privacy</h3>
<p>This plugin connects to the Remapdb service (https://remapdb.com) to:<br />
– Authenticate and authorize the WordPress site during the connect flow.<br />
– Fetch widget configuration and SEO metadata for shortcode rendering.<br />
– Report subscription and host allowance status.</p>
<p>No visitor/end-user data is collected or transmitted. The site hostname and<br />
WordPress site name are sent to Remapdb during the connect flow only, with<br />
the administrator’s explicit consent.</p>
<p>See the Remapdb Privacy Policy: https://remapdb.com/privacy</p>


Remapdb

Put chiptuning specs and quoting on your website.

MySQL query cache stats vs Remapdb