刚刚进了下服务器后台,天啊,数据库怎么突然变得这么大了???居然20多M!前几天还是十几M呢,仔细检查一下,原来是wp_posts这个变大了,再进入此表看了下,post_type里的revision突然又有了接近2000行数据!
哦,原来前天我进行永久链接更换的时候,WP自动保存了所有修订记录,应该是这样,要不然不会突然之间变大这么多。
运行下面这段代码:DELETE FROM wp_posts WHERE post_type=‘revision‘;
DELETE FROM wp_postmeta WHERE post_id IN (SELECT id FROM wp_posts WHERE post_type = ‘revision‘);
DELETE FROM wp_term_relationships WHERE object_id IN (SELECT id FROM wp_posts WHERE post_type=‘revision‘);
DELETE FROM wp_posts WHERE post_type=‘revision‘;
DELETE FROM wp_term_relationships WHERE object_id IN (SELECT id FROM wp_posts WHERE post_type=‘revision‘);
DELETE FROM wp_posts WHERE post_type=‘revision‘;