How to clean up and optimize WordPress databases

Step 1: back up the database

Step 2: run the following SQL

The code is as follows:	Copy code
Delete from wp_posts WHERE post_type = 'Revision ';

However, for post_type and wp_post, besides articles, links, pages, and other content, if they are deleted together, the unsaved links or draft status pages are all deleted. There may be unnecessary losses, so it is safer to use the following command to delete.

The code is as follows:	Copy code
Delete FROM wp_posts WHERE post_type = 'post' & post_status! = 'Publish '; Delete FROM wp_posts WHERE post_type = 'Revision '& post_status! = 'Publish ';

Part 3: optimize table wp_posts

The code is as follows:	Copy code
Optimize table wp_posts;

Step 4: disable WordPress from automatically saving drafts
Add in wp-config.php

The code is as follows:	Copy code
Define ('WP _ POST_REVISIONS ', false ); Define ('autosave _ INTERVAL ', 3600 );