WP-Sweep

説明

このプラグインは以下を掃除します。

  • リビジョン
  • 自動保存下書き
  • 削除済みコメント
  • 未承認コメント
  • スパムコメント
  • 削除済みコメント
  • 孤立投稿メタ
  • 孤立コメントメタ
  • 孤立ユーザーメタ
  • 孤立タームメタ
  • 孤立ターム関係
  • 未使用のターム
  • 重複投稿メタ
  • 重複コメントメタ
  • 重複ユーザーメタ
  • 重複タームメタ
  • Transient オプション
  • データベースのテーブルの最適化
  • 投稿メタ内の oEmbed キャッシュ

このプラグインでは MySQL の直接削除クエリーを実行する代わりに、適切なWordPress の削除関数を可能な限り最大限使用します。

以下の削除関数が使われます。

  • wp_delete_post_revision()
  • wp_delete_post()
  • wp_delete_comment()
  • delete_post_meta()
  • delete_comment_meta()
  • delete_user_meta()
  • delete_term_meta()
  • wp_remove_object_terms()
  • wp_delete_term()
  • delete_transient()
  • delete_site_transient()

WP-Sweep WP REST API Endpoints
* GET /wp-json/sweep/v1/count/<Name>. Get the number of items that we will be sweeping.
* GET /wp-json/sweep/v1/details/<Name>. Get the details of the items that we will be sweeping.
* DELETE /wp-json/sweep/v1/sweep/<Name>. Runs sweep for that particular item.

WP-Sweep WP-CLI Commands
* wp sweep --all. Runs sweep for all items.
* wp sweep <Name>. Runs sweep for that particular item.
* wp sweep <Name1> <Name2>. Run sweep for the selected items.

WP-Sweep で利用できる項目:
* revisions
* auto_drafts
* deleted_posts
* unapproved_comments
* spam_comments
* deleted_comments
* transient_options
* orphan_postmeta
* orphan_commentmeta
* orphan_usermeta
* orphan_termmeta
* orphan_term_relationships
* unused_terms
* duplicated_postmeta
* duplicated_commentmeta
* duplicated_usermeta
* duplicated_termmeta
* optimize_database
* oembed_postmeta

WP-Sweep is not compatible with the following plugins:
* Asgaros Forum
* Custom Fonts
* Elementor Popup Builder
* MailPress
* Meta Slider
* Polylang
* Slider Revolution
* Viba Portfolio
* WPML

ビルドの状況

開発

クレジット

寄付

自由な時間のほとんどをこれらのプラグインの作成、更新、保守、サポートに費やしました。私のプラグインを本当に気に入ってくれて、数百円を割いていただけるなら、心より感謝します。そうでない場合は、何も義務はありませんのでご自由にお使いください。

スクリーンショット

  • WP-Sweep 管理ページ (掃除前)
  • WP-Sweep 管理ページ (掃除後)

インストール

  1. wp-sweep フォルダーを /wp-content/plugins ディレクトリーにアップロードしてください
  2. Activate the WP-Sweep plugin through the ‘Plugins’ menu in WordPress
  3. WordPress ダッシュボード -> ツール -> Sweep (データベース掃除) から WP-Sweep にアクセスできます

FAQ

Coming soon …

評価

2022年2月11日
How this plugin should work? I installed this plugin and my DB was 88.8 MB big. After install and Sweep All, my DB become 91.5 MB big, so maybe i just missed the point what the plugin does. I can change my review later if problem is on my side.
2022年1月31日
Elementor gave me Server Error 500. Their support suggested cleaning the revision table using this excellent plugin - and it did the trick 🙂 Only shame is that this plugin doesn't allow limiting the number of allowed revisions... for this you need another plugin or editing wp-config.php.
2021年11月17日
Picked up stuff that the biggest plugins never did. It actually shaved a few ms off loading time (small but complex e-commerce site)
2021年11月14日
I was a bit skeptical about this plugin just because I was a bit "afraid" to touch my database. Having absolutely NO knowledge of what is normal and what is not... my elementor plugin grew the post_meta database to 1399MB(!). I was tearing my hair out over the slow site until I found the database was the problem. Then I found the sweep plugin... three sweeps later (thousands of "revisions" and thousands of "duplicated post meta" and one sweep at the end to "optimize the tables") My elementor database size shrunk to 81MB (webshop with thousands of products and variations) and is running smoothly now. I had no problems with this at all. Thank you so much for this fantastic tool! There is one thing that could be improved -- but this really might be only because I had such a huge amount to sweep... the plugin page seemingly just stayed stuck on "sweeping..." I let it run for hours because I was afraid what would happen if I switch it off in the middle but eventually I did just refresh the page and it showed there was nothing left to sweep. So it might be nice to add some alert message that it finished or something similar.
2021年10月25日
My new hero... WP Sweep after manually agonizing over my database trying to get rid of crapola, my wp_postmeta was 57MiB... for 26 pages... and I was sort of in agony Swept away 40 MB in just a couple minutes work thank you
110件のレビューをすべて表示

貢献者と開発者

WP-Sweep はオープンソースソフトウェアです。以下の人々がこのプラグインに貢献しています。

貢献者

“WP-Sweep” は16ロケールに翻訳されています。 翻訳者のみなさん、翻訳へのご協力ありがとうございます。

“WP-Sweep” をあなたの言語に翻訳しましょう。

開発に興味がありますか ?

コードを閲覧するか、SVN リポジトリをチェックするか、開発ログRSS で購読してみてください。

変更履歴

1.1.15

  • NEW: Bump to WordPress 5.8

1.1.4

  • FIXED: Replaced %_transient_% with %\_transient\_%. Escape _ in MySQL if not it is being used as a wildcard character. Props @janrenn.

1.1.3

  • FIXED: Changed permissions check to activate_plugins because update_plugins will return false when DISALLOW_FILE_MODS=true.

1.1.2

  • NEW: Changed permission check to update_plugins for better MultiSite compatibility.
  • NEW: Bump min PHP version to 5.6.

1.1.1

  • NEW: wp_sweep_excluded_termids filter.

1.1.0

  • NEW: Added WP Rest API Endpoint support, sweep/v1/count/<Name>, sweep/v1/details/<Name>, and sweep/v1/sweep/<Name>
  • FIXED: Follow as close as possible to WordPress Coding Standards

1.0.12

  • NEW: Bump to WordPress 4.9
  • NEW: Update README to incompatible plugins

1.0.10

  • FIXED: Invalid plugin head ‘This plugin has an invalid header.’

1.0.9

  • NEW: Support for Codeclimate
  • FIXES: Uses get_sites() on WordPress 4.6. This should fix deprecated notices.
  • FIXES: Fixes translation placeholder count. Props @pedro-mendonca.
  • FIXES: Use manage_options capability as it conflicts with Admin Menu Editor on multisite installs. Props @EusebiuOprinoiu.

1.0.8

  • NEW: Added wp_sweep_excluded_taxonomies filter to allow more than just link_category taxonomy
  • NEW: Support for WP-CLI wp sweep

1.0.7

  • FIXES: Use custom query to delete Orphaned Term Relationship if wp_remove_object_terms() fails

1.0.6

  • NEW: Delete ‘languages’ folder from the plugin
  • NEW: Use translate.wordpress.org to translate the plugin
  • FIXED: Works only with WordPress 4.4 because of new term meta

1.0.5

  • FIXED: apply_filters() wrong arguments

1.0.4

  • NEW: oEmbed caches in post meta Sweep
  • NEW: Add POT file for translators

1.0.3

  • NEW: AJAX Sweep All
  • NEW: AJAX Sweeping
  • NEW: View details of sweep
  • NEW: Optimize DB sweep
  • NEW: User hint and confirmation. Props @SiamKreative
  • FIXED: Division by zero. Pros @barisunver

1.0.2

  • FIXED: Use term_id for wp_remove_object_terms()
  • FIXED: number_format_i18n() issues after sweeping

1.0.1

  • NEW: Moved plugin location to WP-Admin -> Tools -> Sweep
  • NEW: Add Deleted Post Sweep
  • FIXED: Use forced_delete for wp_delete_post() and wp_delete_comment();
  • FIXED: If orphaned meta has an object id of 0, use SQL query to delete

1.0.0

  • 最初のリリース