CantonBolo

Optimize your database, support WordPress mutisite.
优化你的数据库，支持多站点。

Database Optimizer by Bolo

Optimize your database, support WordPress mutisite. 优化你的数据库，支持多站点。

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.

Database Optimizer by Bolo vs SmartPro Database Optimiser & Cleaner