清除wordpress无用的sql信息,以及删除查找孤立项目

wordpress为了数据安全和执行效率会留下很多版本信息，插件及文章等添加删除过程中也可能留下没有完全清理的垃圾数据。这时，对wordpress表中没有用的数据垃圾清理就显得有必要了。

SQL清理常见垃圾：

DELETE FROM wp_posts WHERE post_type = 'revision';

DELETE FROM wp_posts WHERE post_status = 'draft';

DELETE FROM wp_posts WHERE post_status = 'auto-draft';

DELETE FROM wp_comments WHERE comment_approved = '0';

DELETE FROM wp_comments WHERE comment_approved = 'spam';

DELETE FROM wp_comments WHERE comment_approved = 'trash';

DELETE pm FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL;

DELETE FROM wp_commentmeta WHERE comment_id NOT IN (SELECT comment_id FROM wp_comments);

DELETE FROM wp_term_relationships WHERE term_taxonomy_id=1 AND object_id NOT IN (SELECT id FROM wp_posts);

DELETE FROM wp_options WHERE option_name LIKE '_site_transient_browser_%' OR option_name LIKE '_site_transient_timeout_browser_%' OR option_name LIKE '_transient_feed_%' OR option_name LIKE '_transient_timeout_feed_%';



这种垃圾清理有利于提升SQL执行速度，此外，原先的OPTIMIZE TABLE优化数据表命令在SQL版本升级后失效了。

#现在前往