安装了很多插件以及运行时间很长的WordPress会有很多垃圾信息,简单清理下。
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 = '_wp_old_slug';
DELETE FROM wp_postmeta WHERE meta_key = '_revision-control';
DELETE FROM wp_postmeta WHERE meta_key = 'robotsmeta';
DELETE FROM wp_postmeta WHERE meta_key = 'duoshuo_thread_id';
DELETE FROM wp_postmeta WHERE meta_value = '{{unknown}}';
DELETE FROM wp_postmeta WHERE meta_key = 'trackback_count';
DELETE FROM wp_postmeta WHERE post_id NOT IN (SELECT post_id FROM wp_posts);
DELETE FROM wp_postmeta WHERE meta_key = 'onesignal_send_notification';
DELETE FROM wp_postmeta WHERE meta_key = 'onesignal_meta_box_present';
DELETE FROM wp_postmeta WHERE meta_key LIKE '_oembed%';
DELETE FROM wp_postmeta WHERE meta_key = '_wpas_done_all';
DELETE FROM wp_postmeta WHERE meta_key = 'dsq_thread_id';
DELETE FROM wp_postmeta WHERE meta_key = 'post_views_count';
DELETE FROM wp_postmeta WHERE meta_key = '_jetpack_related_posts_cache';