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…

Kirtikumar Solanki

SmartPro Database Optimiser & Cleaner helps you maintain a faster, cleaner, and more efficient WordPress website by removing unnecessary database clutter and optimizing all database tables. 
It features a beautiful modern interface, one-click actions, real-time item counts, and AJAX-powered cleaning for a seamless experience.
This tool also includes an integrated full database backup system, allowing you to download your entire WordPress database in <code>.sql</code> format before cleaning.
No technical skills required — simply open Tools → SmartPro Database Optimiser & Cleaner, click “Clean”, and enjoy improved performance instantly.
<h3>🚀 Key Benefits</h3>
<ul>
<li>Faster database performance </li>
<li>Reduced storage usage </li>
<li>Ability to safely back up your WordPress database </li>
<li>Clean, modern, user-friendly UI </li>
<li>No page reloads (AJAX-based) </li>
<li>Safe queries using <code>$wpdb</code> </li>
<li>No bloat, lightweight, and optimized </li>
</ul>
<h3>🧹 Cleanup Features</h3>
Clean up unnecessary and unused database entries with a single click:
<ul>
<li>Remove post revisions</li>
<li>Delete auto-saved drafts</li>
<li>Remove trashed posts and trashed pages</li>
<li>Clean spam and trashed comments</li>
<li>Remove expired transients</li>
<li>Delete all transients</li>
<li>Remove orphaned post meta</li>
<li>Remove orphaned comment meta</li>
<li>Delete orphaned user meta</li>
<li>Remove unused tags</li>
<li>Delete empty taxonomy terms</li>
<li>Optimize all WordPress tables</li>
</ul>
Each cleanup item displays: 
– Real-time items count 
– Action button 
– Instant results message
Also includes: 
– Clean All button 
– Refresh Counts button
<h3>🛢️ Database Backup Features</h3>
Before cleaning, download your full database for safety.
<ul>
<li>One-click SQL backup download</li>
<li>Shows total database size</li>
<li>Backups stored in: 
 /wp-content/uploads/smartpro-database-optimiser-cleaner/</li>
<li>Backup is generated safely using WordPress standards</li>
</ul>
<h3>🗂️ Database Table Optimization</h3>
From the Optimize Tables tab, you can:
<ul>
<li>View every database table </li>
<li>See table size, index size, total size, row count </li>
<li>Optimize each table individually </li>
<li>Or use Optimize All Tables</li>
</ul>
All database optimization is handled using safe, built-in SQL operations.
<h3>🖥️ Smart, Modern UI</h3>
The plugin includes a clean and intuitive interface:
<ul>
<li>AJAX-powered actions </li>
<li>Smooth progress indicators </li>
<li>Live counts </li>
<li>Field-based table listing </li>
<li>Fully responsive design </li>
<li>Admin-friendly layout </li>
</ul>
<h3>🔒 Security & Permissions</h3>
<ul>
<li>Nonce-protected AJAX requests </li>
<li>Sanitized inputs </li>
<li>Works only for administrators </li>
<li>No risky SQL execution </li>
<li>Follows strict WordPress coding standards</li>
</ul>

SmartPro Database Optimiser & Cleaner

Smart, lightweight tool to clean, optimize, and back up your WordPress database for better speed and performance.

Figment Thinking WordPress Database Table Optimizer vs SmartPro Database Optimiser & Cleaner