Marion Dorsett

The WordPress Database Table Optimizer plugin will automatically make sure that your WordPress MySQL database tables are always optimized.
I’ve also included an admin page located at Manage > Optimize Database. This page will allow you to confirm your WordPress MySQL database tables are optimized, show you the number of rows per table, and the size of the table.
<h3>Arbitrary section</h3>
This plugin uses Aidan Lister size_readable PHP function to show the file sizes of the MySQL tables. I’ve changed the name of the function to avoid naming conflicts with other plugins that may be using this function as well.
http://aidanlister.com/repos/v/function.size_readable.php
Special thanks to David Potter (http://dpotter.net/Technical/) for catching my oversight.
http://www.figmentthinking.com/wordpress-database-table-optimizer/#comment-74

Figment Thinking WordPress Database Table Optimizer

The WordPress Database Table Optimizer plugin will automatically make sure that your WordPress MySQL database…

wppforeveryone

🚀 Optimize your WordPress website speed! Gzip, LazyLoading, WebP conversion, Cache, DB backups & cleanup, preload CSS/JS/images.
<h3>⚡ Key Features:</h3>
<ol>
<li>
Cache Optimization:
<ul>
<li>Cache pages, posts, and products for faster loading.</li>
<li>Minifies HTML automatically on cache</li>
<li>If WooCommerce is activated, you can also cache product pages.</li>
<li>Inline CSS for each post type</li>
<li>Easily clear the cache manually for better performance.</li>
<li>Individual manual page/post/product clear & create caches <a href="https://wppfe.com/wp-performance-and-speed-for-everyone/#pricing" rel="nofollow ugc">Premium</a></li>
<li>Delete all cached objects in one click or separately by post type</li>
<li>Delete individual page/post/product cache if needed</li>
<li>Clear & cache pages/posts/products automatically after saving them <a href="https://wppfe.com/wp-performance-and-speed-for-everyone/#pricing" rel="nofollow ugc">Premium</a></li>
</ul>
</li>
<li>
Database Settings:
<ul>
<li>Clean up your database by removing unnecessary data such as post revisions, spam comments, transient options, and orphaned metadata.</li>
<li>Run optimization queries to defragment database tables, ensuring efficient data management.</li>
<li>Review and clean the <code>wp_options</code> table to ensure only essential data is autoloaded.</li>
<li>Regularly clean up term relationships and other unused data for a more streamlined database.</li>
<li>Backup your database before performing cleanups and monitor database performance, including size and optimization results before and after cleanup.</li>
<li>Automatic Database backups periodically <a href="https://wppfe.com/wp-performance-and-speed-for-everyone/#pricing" rel="nofollow ugc">Premium</a></li>
</ul>
</li>
<li>
JavaScript Settings:
<ul>
<li>Disable jQuery Migrate and embedded scripts for a leaner codebase.</li>
<li>Add ‘defer’ to JS scripts to prioritize content loading.</li>
<li>Disable reCAPTCHA if not used in the page <a href="https://wppfe.com/wp-performance-and-speed-for-everyone/#pricing" rel="nofollow ugc">Premium</a></li>
</ul>
</li>
<li>
General Settings:
<ul>
<li>Enable Gzip compression to shrink file sizes sent from your server.</li>
<li>Disable default emoji scripts for a cleaner, faster site.</li>
<li>Disable Contact Form 7 scripts if they are not used on that page <a href="https://wppfe.com/wp-performance-and-speed-for-everyone/#pricing" rel="nofollow ugc">Premium</a></li>
</ul>
</li>
<li>
Speed Test:
<ul>
<li>Measure your website’s loading speed for both mobile and desktop.</li>
<li>Get insights and identify issues that may impact your site’s performance.</li>
<li>Access a performance dashboard with real-time data, including page load times and optimization suggestions.</li>
<li>Delete results to keep DB optimized;</li>
</ul>
</li>
<li>
Images:
<ul>
<li>Preload images for better performance</li>
<li>Lazy Load images which are off-screen</li>
<li>Convert all uploaded images to webp format</li>
<li>Optimize images quality level on each upload <a href="https://wppfe.com/wp-performance-and-speed-for-everyone/#pricing" rel="nofollow ugc">Premium</a></li>
<li>Use WebP image formats on a whole website in one click</li>
<li>Converting all WebP images including resized ones</li>
<li>Convert ALL existing images to WebP in one click <a href="https://wppfe.com/wp-performance-and-speed-for-everyone/#pricing" rel="nofollow ugc">Premium</a></li>
</ul>
</li>
<li>
Styling (CSS):
<ul>
<li>Preload CSS files which are blocking rendering <a href="https://wppfe.com/wp-performance-and-speed-for-everyone/#pricing" rel="nofollow ugc">Premium</a></li>
<li>Minify & inline selected CSS files <a href="https://wppfe.com/wp-performance-and-speed-for-everyone/#pricing" rel="nofollow ugc">Premium</a></li>
</ul>
</li>
<li>
Help:
<ul>
<li>Let’s build best product together! Help us to do that and we will help you to get best of this product!</li>
<li>Premium support for any issue or improvement! <a href="https://wppfe.com/wp-performance-and-speed-for-everyone/#pricing" rel="nofollow ugc">Premium</a></li>
</ul>
</li>
</ol>
<h3>🌟 Upcoming Features ⏳:</h3>
<ul>
<li>Scheduled Database Cleanups</li>
<li>Database Health Automatic Monitoring</li>
<li>WooCommerce-Specific Optimizations</li>
<li>Browser Caching Enhancements</li>
<li>Image CDN Integration</li>
<li>Advanced Page Preloading</li>
<li>Keeping Database backups in Cloud Service</li>
<li>Critical CSS generation</li>
<li>Object Caching</li>
<li>Preconnect & prefetch</li>
<li>AMP compatability</li>
</ul>
<h3>Third-Party Services</h3>
This plugin uses the following third-party services:
<ol>
<li>Google PageSpeed Insights API
<ul>
<li>Purpose: This plugin relies on the Google PageSpeed Insights API to measure the performance of your website. When you click the “Measure My Website Performance” button, the plugin sends your website URL to the Google PageSpeed Insights service to retrieve performance data.</li>
<li>Data Sent: Your website URL is sent to the Google PageSpeed Insights service.</li>
<li>Service Link: <a href="https://developers.google.com/speed/pagespeed/insights/" rel="nofollow ugc">Google PageSpeed Insights</a></li>
<li>Privacy Policy: <a href="https://policies.google.com/privacy" rel="nofollow ugc">Google Privacy Policy</a></li>
<li>Terms of Use: <a href="https://developers.google.com/speed/docs/insights/terms" rel="nofollow ugc">Google PageSpeed API Terms of Use</a></li>
</ul>
</li>
</ol>
<h3>Additional Information</h3>
<ul>
<li>📋 License: GPLv2 or later.</li>
<li>💬 Support: If you need assistance, feel free to reach out via <a href="https://wppfe.com/contacts" rel="nofollow ugc">WPPFE.com</a>.</li>
</ul>

WP-performance for everyone – Boost Page Speed & Performance

Boost your WordPress website speed: Gzip, Lazy Loading, WebP conversion, Cache, DB backups & more.

Figment Thinking WordPress Database Table Optimizer vs WP-performance for everyone – Boost Page Speed & Performance