WordPress Post revisions causing large MySQL database size

[Chris]

Hi,

I have one WordPress websites with thousands of posts. I have noticed that my database size is too large and it is due to WordPress post revisions. I am frequently updating the posts and it is auto saving WordPress posts. I am seeing large number of WordPress post revisions for all posts and I believe this should be causing large database size issue.

How can I disable WordPress post revisions or at least limit the number of post revisions so that it does not consume database space.

Thanks,
Chris

[Kailash]

Hello,

This is known issue in WordPress. By default it saves the post revisions whenever we edit any post and there is no limit on number of post revisions. This can cause large MySQL database size issue if you have large number of posts and you are frequently editing them.

You can certainly disable WordPress post revisions or you can limit it to number of post revisions. You can control this using wp-config.php file or there are third party plugins available. But it is better to manage it using wp-config.php file.

You can refer our following KB to disable or limit WordPress post revisions:

Disable Post Revisions in WordPress and Reduce Database Size

- Kailash