分类
WordPress

WordPress清理postmeta垃圾信息

安装了很多插件以及运行时间很长的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'; 

发表评论

电子邮件地址不会被公开。 必填项已用*标注

此站点使用Akismet来减少垃圾评论。了解我们如何处理您的评论数据