Title: SmartPro Database Optimiser & Cleaner Author: Kirtikumar Solanki Published: 2025 年 11 月 20 日 Last modified: 2026 年 5 月 23 日 --- 搜索插件 ![](https://ps.w.org/smartpro-database-optimiser-cleaner/assets/banner-772x250.png? rev=3400638) ![](https://ps.w.org/smartpro-database-optimiser-cleaner/assets/icon-256x256.png? rev=3400638) # SmartPro Database Optimiser & Cleaner 作者：[Kirtikumar Solanki](https://profiles.wordpress.org/solankisoftware/) [下载](https://downloads.wordpress.org/plugin/smartpro-database-optimiser-cleaner.1.0.zip) * [详情](https://cn.wordpress.org/plugins/smartpro-database-optimiser-cleaner/#description) * [评价](https://cn.wordpress.org/plugins/smartpro-database-optimiser-cleaner/#reviews) * [安装](https://cn.wordpress.org/plugins/smartpro-database-optimiser-cleaner/#installation) * [开发进展](https://cn.wordpress.org/plugins/smartpro-database-optimiser-cleaner/#developers) [支持](https://wordpress.org/support/plugin/smartpro-database-optimiser-cleaner/) ## 描述 **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 `.sql` format before cleaning. No technical skills required — simply open **Tools SmartPro Database Optimiser & Cleaner**, click “Clean”, and enjoy improved performance instantly. ### 🚀 Key Benefits * Faster database performance * Reduced storage usage * Ability to safely back up your WordPress database * Clean, modern, user-friendly UI * No page reloads (AJAX-based) * Safe queries using `$wpdb` * No bloat, lightweight, and optimized ### 🧹 Cleanup Features Clean up unnecessary and unused database entries with a single click: * Remove **post revisions** * Delete **auto-saved drafts** * Remove **trashed posts** and **trashed pages** * Clean **spam** and **trashed comments** * Remove **expired transients** * Delete **all transients** * Remove **orphaned post meta** * Remove **orphaned comment meta** * Delete **orphaned user meta** * Remove **unused tags** * Delete **empty taxonomy terms** * Optimize all WordPress tables Each cleanup item displays: – **Real-time items count** – **Action button** – ** Instant results message** Also includes: – **Clean All** button – **Refresh Counts** button ### 🛢️ Database Backup Features Before cleaning, download your full database for safety. * One-click **SQL backup download** * Shows **total database size** * Backups stored in: /wp-content/uploads/smartpro-database-optimiser-cleaner/ * Backup is generated safely using WordPress standards ### 🗂️ Database Table Optimization From the **Optimize Tables** tab, you can: * View every database table * See table size, index size, total size, row count * Optimize each table individually * Or use **Optimize All Tables** All database optimization is handled using safe, built-in SQL operations. ### 🖥️ Smart, Modern UI The plugin includes a clean and intuitive interface: * AJAX-powered actions * Smooth progress indicators * Live counts * Field-based table listing * Fully responsive design * Admin-friendly layout ### 🔒 Security & Permissions * Nonce-protected AJAX requests * Sanitized inputs * Works only for administrators * No risky SQL execution * Follows strict WordPress coding standards ## 屏幕截图 * [[ * Dashboard — Cleanup Tools * [[ * Database Table Optimization Interface ## 安装 1. Upload the plugin folder to the `/wp-content/plugins/` directory 2. Activate the plugin through the “Plugins” menu in WordPress 3. Go to **Tools SmartPro Database Optimiser & Cleaner** 4. Click **Refresh Counts** 5. Clean or optimize the database using the action buttons ## 常见问题 ### ❓ Is it safe to clean my database? Yes — all operations use safe WordPress and SQL methods. However, it’s recommended to take a backup using the built-in download tool. ### ❓ Where are backups stored? Backups are saved inside: /wp-content/uploads/smartpro-database-optimiser-cleaner/ ### ❓ Does this plugin work with WooCommerce? Yes. It can clean and optimize WooCommerce database tables safely. ### ❓ Can this break my site? No. The plugin only removes unnecessary and unused entries. It does **not** modify posts, pages, users, WooCommerce products, or active content. ### ❓ Does the plugin use AJAX? Yes — all cleaning and optimization actions run without page reloads. ## 评价 ![](https://secure.gravatar.com/avatar/a31cd68e1c5de1a15c4a31dd99cc0e9eb0eb4f2aaedd3d3025a1e22d928b9a32? s=60&d=retro&r=g) ### 󠀁[Cleaned Heavy Junks on Tables](https://wordpress.org/support/topic/cleaned-heavy-junks-on-tables/)󠁿 [Skrlance](https://profiles.wordpress.org/seanlance/) 2025 年 12 月 15 日 1 回复 Absolutely, an awesome plugin! It helped me remove lots of empty terms, removed heavy amount of junks on wp_options table, also removed many junks of postmeta table without creating any problem on the website. I suggest this plugin to be marked tested for WordPress 6.9 so more people start using it! [ 阅读所有1条评价 ](https://wordpress.org/support/plugin/smartpro-database-optimiser-cleaner/reviews/) ## 贡献者及开发者 「SmartPro Database Optimiser & Cleaner」是开源软件。 以下人员对此插件做出了贡献。 贡献者 * [ Kirtikumar Solanki ](https://profiles.wordpress.org/solankisoftware/) [帮助将「SmartPro Database Optimiser & Cleaner」翻译成简体中文。](https://translate.wordpress.org/projects/wp-plugins/smartpro-database-optimiser-cleaner) ### 对开发感兴趣吗? 您可以[浏览代码](https://plugins.trac.wordpress.org/browser/smartpro-database-optimiser-cleaner/)， 查看[SVN仓库](https://plugins.svn.wordpress.org/smartpro-database-optimiser-cleaner/)， 或通过[RSS](https://plugins.trac.wordpress.org/log/smartpro-database-optimiser-cleaner/?limit=100&mode=stop_on_copy&format=rss) 订阅[开发日志](https://plugins.trac.wordpress.org/log/smartpro-database-optimiser-cleaner/)。 ## 更新日志 #### 1.0 * Initial release * Added full database backup system * Added real-time counts for all cleanup types * Added cleanup tools (revisions, drafts, trash, comments, transients, orphaned meta) * Added table optimization module * Added Clean All and Refresh Counts buttons * Added progress UI and AJAX engine * Stable, optimized, and secure release ## 额外信息 * 版本 **1.0** * 最后更新：**1 周前** * 活跃安装数量 **10+** * WordPress 版本 ** 5.0 或更高版本 ** * 已测试的最高版本为 **6.9.4** * PHP 版本 ** 7.4 或更高版本 ** * 语言 * [English (US)](https://wordpress.org/plugins/smartpro-database-optimiser-cleaner/) * 标签 * [backup](https://cn.wordpress.org/plugins/tags/backup/)[clean](https://cn.wordpress.org/plugins/tags/clean/) [database](https://cn.wordpress.org/plugins/tags/database/)[Optimize](https://cn.wordpress.org/plugins/tags/optimize/) [performance](https://cn.wordpress.org/plugins/tags/performance/) * [高级视图](https://cn.wordpress.org/plugins/smartpro-database-optimiser-cleaner/advanced/) ## 评级 5 星（最高 5 星）。 * [ 1 条 5 星评价 ](https://wordpress.org/support/plugin/smartpro-database-optimiser-cleaner/reviews/?filter=5) * [ 0 条 4 星评价 ](https://wordpress.org/support/plugin/smartpro-database-optimiser-cleaner/reviews/?filter=4) * [ 0 条 3 星评价 ](https://wordpress.org/support/plugin/smartpro-database-optimiser-cleaner/reviews/?filter=3) * [ 0 条 2 星评价 ](https://wordpress.org/support/plugin/smartpro-database-optimiser-cleaner/reviews/?filter=2) * [ 0 条 1 星评价 ](https://wordpress.org/support/plugin/smartpro-database-optimiser-cleaner/reviews/?filter=1) [Your review](https://wordpress.org/support/plugin/smartpro-database-optimiser-cleaner/reviews/#new-post) [查看全部评论](https://wordpress.org/support/plugin/smartpro-database-optimiser-cleaner/reviews/) ## 贡献者 * [ Kirtikumar Solanki ](https://profiles.wordpress.org/solankisoftware/) ## 支持 有话要说吗？是否需要帮助？ [查看支持论坛](https://wordpress.org/support/plugin/smartpro-database-optimiser-cleaner/) ## 捐助 您愿意支持这个插件的发展吗? [ 捐助此插件 ](https://paypal.me/kirtikumar89)