刪除文章修訂版本

DELETE FROM wp_posts WHERE post_type = 'revision';
wp 媒體管理器上傳圖片的時候同事會成才attachment 文章格式，如果你不需要根據這個檢索圖片的話也可以刪掉。

DELETE FROM wp_posts WHERE post_type = 'attachment';
wp_postmeta是重災區(qū)，可以執(zhí)行以下命令

DELETE FROM wp_postmeta WHERE meta_key = '_edit_lock';
DELETE FROM wp_postmeta WHERE meta_key = '_edit_last';
DELETE FROM wp_postmeta WHERE meta_key = '_revision-control';
DELETE FROM wp_postmeta WHERE post_id NOT IN (SELECT post_id FROM wp_posts);
DELETE FROM wp_postmeta WHERE meta_key = '_wp_old_slug';
DELETE FROM wp_postmeta WHERE meta_key = '_revision-control';
DELETE FROM wp_postmeta WHERE meta_value = '{{unknown}}';
如果你不需要管理你的多媒體文件可以使用下面這兩句

DELETE FROM wp_postmeta WHERE meta_key = '_wp_attached_file';
DELETE FROM wp_postmeta WHERE meta_key = '_wp_attachment_metadata';
綜合到一起可直接執(zhí)行下面兩句

DELETE FROM wp_postmeta WHERE meta_key in ('_edit_lock', '_edit_last', '_wp_old_slug', '_revision-control', '{{unknown}}', '_wp_attached_file', '_wp_attachment_metadata');
DELETE FROM wp_postmeta WHERE post_id NOT IN (SELECT id FROM wp_posts);
刪除所有垃圾評論

DELETE FROM wp_comments WHERE comment_type = 'trash';
刪除所有待審評論

DELETE FROM wp_comments WHERE comment_approved = '0';

一般來說直接刪掉wp_commentmeta就可以了，我是完全不使用這貨的，如果你使用了commentmeta存儲信息請謹慎執(zhí)行此句

TRUNCATE TABLE wp_commentmeta
wp_options
尤其是使用我的網易云音樂和牧風的hermit，都會在wp_options表中產生大量垃圾數據。

DELETE FROM wp_options WHERE option_name LIKE 'transient%';
DELETE FROM wp_options WHERE option_name LIKE 'transient_timeout%'
這樣會刪除所有臨時數據，包括未過期的，謹慎使用。

未經允許不得轉載：445IT之家 » WordPress 清理數據庫冗余數據命令