檢查有多少自動儲存文章
select * FROM wp_posts WHERE post_type = ‘revision’;
以上方法不能徹底關閉文章版本功能。
1、wp-settings.php
define( ‘AUTOSAVE_INTERVAL’, 60 );
60單位為秒，是修訂文章自動保存的時間，數值可以改大
2、wp-config.php
加上define(‘WP_POST_REVISIONS’, false);或者define(‘WP_POST_REVISIONS’, ‘0’);
3、wp-admin里post-new.php和page-new.php
注釋或刪除掉wp_enqueue_script(‘autosave’);
SQL語句徹底刪除數據庫里的文章版本，需要按順序分三次執行以下三個語句
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’;
若已先刪除 post_type=’revision’ ，檢查wp_postmeta及wp_term_relationships
select * FROM wp_postmeta WHERE post_id NOT IN (SELECT id FROM wp_posts );
select * FROM wp_term_relationships WHERE object_id NOT IN (SELECT id FROM wp_posts );
select * FROM wp_posts WHERE post_type=’revision’;