內容簡介
SweepPress 是一款易於使用的 WordPress 插件，圍繞著 30 個不同的清理程式（專業版有 33 個）進行數據庫清理，支援 WP-CLI 和 WP REST API 執行清理操作。
清理模式：
- 自動清理：在儀表板上提供，運行多個（非全部）清理程式，無需用戶輸入。
- 快速清理：在儀表板上提供，允許選擇要運行的清理程式。
- 完整清理：在自己的面板上提供，提供有關清理程序的詳細信息，不限制運行次數。
所有清理程序使用優化的 SQL 查詢查找要刪除的數據，並且刪除也使用 SQL 查詢執行。這是刪除數據的最快和最有效方法，可以快速刪除大量數據。
清理程序列表：
- 文章：自動草稿
- 文章：垃圾內容
- 文章：垃圾箱內容
- 文章：文章修訂版本
- 文章：孤立的文章修訂版本
- 文章：文章元數據鎖
- 文章：文章元數據上次編輯
- 文章：文章嵌入內容
- 文章：文章元數據孤立
- 評論：垃圾評論
- 評論：垃圾箱評論
- 評論：未獲批准的評論
- 評論：孤立的評論
- 評論：評論用戶代理
- 評論：評論元數據孤立
- 評論：Pingbacks 清理
- 評論：Trackbacks 清理
- 評論：Akismet Meta 記錄（v1.1）
- 分類：分類元數據孤立
- 分類：分類元數據鎖
- 用戶：用戶元數據孤立
- 選項：過期 Transients
- 選項：RSS 訂閱源
- 選項：全部 Transients
- 選項：CRON 任務
- 網絡：過期 Transients
- 網絡：全部 Transients
- 網絡：非活躍註冊（v2.0）
- 數據庫：優化數據庫表
- 數據庫：修復數據庫表（v1.6）
插件還註冊了新的 CLI 命令，可以從命令行運行清理操作（需要 WP-CLI）。此外，插件還註冊了 REST API 端點，可以執行遠程清理操作（僅限管理員角色！）。可以通過插件設置啟用 CLI 和 REST API 支援。
SweepPress Lite 版本可在 WordPress.org 上下載，是一個完整功能的插件，操作沒有任何限制。但是，SweepPress Pro 包含一些 Lite 版本中沒有的附加功能：
- 建立和管理清理工作：創建自定義的後台清理工作，在特定日期運行或作為重複工作運行。
- 控制和跟踪 WordPress CRON 工作：列出所有 WordPress CRON 工作，跟踪並顯示源代碼等。
- 清潔器監控功能：每天或每週監控網站進行清理，當達到清理限制時發送通知。
- 數據庫表格：概述數據庫中的所有表以及來源信息和各種操作，以便更好地控制。
- 清理器文件日誌：將每個清理器執行記錄在日誌文件中，包括每個使用的清理器執行的所有清理器/刪除 SQL 查詢。
- GravityForms 支持：添加了三個額外的清理器，用於按表格刪除所有已刪除、垃圾和垃圾箱項目。
未來更新將帶來更多專業版特有的功能。注意，該插件默認會在每個插件頁面上顯示備份提醒通知（可以禁用）。了解備份的重要性。
外掛標籤
開發者團隊
② 後台搜尋「SweepPress: Website Cleanup and Optimization」→ 直接安裝（推薦）
📦 歷史版本下載
原文外掛簡介
SweepPress is an easy-to-use WordPress plugin built around 52 different Sweepers for database cleanup (the Pro version has 57), support for WP-CLI, and WP REST API to perform the cleanup operations. The plugin also features a powerful WordPress Options database table management panel.
Quick Video Overview
Options Management
The WordPress Options database table holds settings for WordPress Core, all the plugins, and themes. This table can grow significantly, especially since records are not auto-deleted when removing a plugin or theme. SweepPress has Sweepers that deal with transient cache records (stored in this table), and now, since version 3.0, it has a full Management panel where you can see all the records in the Options table, detect source for the record and status to help you decide if you should delete the record or not.
SweepPress has two methods to detect the source of the record, and it will mark all the recognized records. This panel doesn’t show transient records (used for cache) or WordPress options (deleting these options is a terrible idea). There is also a Quick Tasks subpanel, which can help you quickly remove options fitting into few standard predefined criteria.
Options deletion process is not automatic! No matter how precise options usage detection is, you need to verify and confirm that you want to delete one or more records.
SweepPress Pro It also has advanced management panels for all the WordPress metadata and multisite Sitemeta database tables, including options to track the usage of meta-records, and remove all the entries from the database associated with specific meta.
Modes of Sweeping
Auto Sweep: available on the dashboard, running many (not all) sweepers without user input.
Quick Sweep: available on the dashboard, allowing the sweepers to be selected.
Full Sweep: available on its panel, with detailed information about sweepers and no limit run.
CLI Sweep: the plugin supports WP-CLI and adds commands to run all the sweepers with the command line.
REST API Sweep: the plugin supports WP REST API and allows sweeping via the new REST endpoints.
All sweepers use optimized SQL queries to find the data for removal, which is also done using SQL queries. This is the fastest and most efficient way to remove a large amount of data quickly.
List of Sweepers
Posts: Auto Drafts
Posts: Spam Content
Posts: Trashed Content
Posts: Posts Revisions
Posts: Posts Orphaned Revisions
Posts: Draft Posts Revisions
Posts: Postmeta Locks
Posts: Postmeta Last Edits
Posts: Postmeta Oembeds
Posts: Postmeta Old Data
Posts: Postmeta Orphans
Posts: Postmeta Duplicates
Comments: Spam Comments
Comments: Trashed Comments
Comments: Unapproved Comments
Comments: Orphaned Comments
Comments: Comments User Agents
Comments: Commentmeta Orphans
Comments: Commentmeta Duplicates
Comments: Pingbacks Cleanup
Comments: Trackbacks Cleanup
Comments: Akismet Meta Records
Terms: Terms Orphans
Terms: Termmeta Orphans
Terms: Termmeta Duplicates
Terms: Term Relationships Taxonomy Orphans
Terms: Term Relationships Objects Orphans
Terms: AMP Validation Errors
Terms: Unused Terms
Users: Usermeta Orphans
Users: Usermeta Duplicates
Options: Expired Transients
Options: RSS Feeds
Options: All Transients
Options: CRON Jobs
Options: Unhooked CRON Jobs
Network: Expired Transients
Network: All Transients
Network: Inactive Signups
Database: Optimize Database Tables
Database: Repair Database Tables
ActionScheduler: Log Entries
ActionScheduler: Orphaned Log Entries
ActionScheduler: Failed Actions
ActionScheduler: Completed Actions
ActionScheduler: Canceled Actions
bbPress: Replies Orphans
BuddyPress: Activity Meta Orphans
BuddyPress: Groups Meta Orphans
BuddyPress: Messages Meta Orphans
BuddyPress: Notifications Meta Orphans
Elementor: Trashed Submissions
WP-CLI and WP REST API Support
The plugin registers new CLI commands for running sweep operations from the command line (WP-CLI is required). It also registers the REST API endpoint for the same purpose: running remote sweep operations (only for the administrator role!). CLI and REST API support can be enabled through plugin settings.
Action Scheduler Support
The plugin can clean up the ActionScheduler tables. These tables are used by the Action Schedule plugin and components developed for WooCommerce but also in many other WordPress plugins, including WP Rocket and Rank Math. For these sweepers to be visible, at least one plugin using those tables needs to be active.
Additional Features
Sweeper File Log: log every sweeper execution into a log file with all sweeper/removal SQL queries executed by each used sweeper.
Special Notice
The plugin will show the backup reminder notice by default (and it can be disabled) on every page. It is essential to understand that once the plugin deletes data, it can’t be restored. So, if you change your mind later, it is important to make the backup before the data removal. The SweepPress plugin is not responsible for any data loss — ensure backups! In SweepPress Pro, there is a Backup Data feature that will create partial backups from data before it is removed and store it into SQL export files.
Plugin Home Page
Learn more about the plugin: SweepPress Home Page
Plugin knowledge base: SweepPress on Dev4Press
Support for the Lite version: Support Forum on Dev4Press
SweepPress Pro
SweepPress Lite edition is a fully functional plugin with no limits to its operations. But SweepPress Pro contains a lot of additional features not available in the Lite version:
Backup the data before it is deleted into SQL export files. Includes a management panel for Backup files.
Management for ALL the WordPress Metadata tables: postmeta, termmeta, commentmeta, usermeta and blogmeta.
Management for the WordPress Multisite Sitemeta table: this table is equivalent of the Options table, but for all the blogs in the multisite.
Track and Detect use of metadata and allow removal of any meta-records for all supported metadata tables.
Preview duplicated metadata records for all supported metadata tables. Preview data for some sweepers.
Create and manage Sweeper Jobs: create custom background sweeper jobs to run at a specific date or as a recurring job.
Control and track WordPress CRON jobs: list all the WordPress CRON jobs, track and display the source, and more.
Sweeper Monitor: monitor the website for cleanup daily or weekly, and send notifications when the sweeping limit is reached.
Database Tables: an overview of all tables in the database with source information and various actions for better control.
GravityForms Support: three additional sweepers to remove all trashed forms, spammed, and trash entries by form.
CLI Command to list CRON jobs: list all registered WP CRON jobs via the command line.
Future updates will include more exclusive Pro features.
