Lapland's Blog

WordPress 数据库清理

WordPress越来越臃肿了，搜索了关于清理数据库的东西，整理下给自己备用。

DELETE FROM `自己数据库的名字`.`wp_posts` WHERE `wp_posts`.`post_status` = 'inherit'
DELETE FROM `wp_options` WHERE `option_name` LIKE ('_transient%_feed_%')
DELETE FROM wp_comments WHERE comment_approved = 'trash';
DELETE FROM wp_commentmeta WHERE comment_id NOT IN (SELECT comment_id FROM wp_comments);
DELETE FROM wp_commentmeta WHERE meta_key LIKE '%trash%';
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_posts WHERE post_type = "revision";
DELETE from wp_comments WHERE comment_approved = '0';
DELETE FROM wp_posts WHERE post_status = "auto-draft";
UPDATE wp_posts SET ping_status = 'closed';
DELETE FROM wp_postmeta WHERE meta_key = '自己用过的自定义域（如果确定不再使用）';