Manually removing revision post types

IF you want, you can disable revisions in first place (No need to run CRON then)

To disable them go to wp-config.php and add this line:

define('WP_POST_REVISIONS', false );

Or to limit to 10 revisions

define('WP_POST_REVISIONS', 10);

And to delete all current revisions you can run this SQL query:

DELETE FROM wp_posts WHERE post_type = "revision";

Here seems to be quite decent plugin to do that for you (It does a lot more too)
https://wordpress.org/plugins/rvg-optimize-database/

Also DO backups

And another SO thread:
Safest way to bulk delete post revisions

Related Posts:

  1. What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?
  2. SQL Query for getting all posts in their latest revised state
  3. Reset/Reorder posts ID in the MySQL wp_posts table
  4. How do I find which articles are missing a featured image in The WordPress database?
  5. Remove a shortcode from all WordPress posts
  6. What do these phpMyAdmin errors mean on my WordPress databaes?
  7. why there are so many posts whoes post_type is revision? will these records waste too much database space?
  8. Why my wp_posts data is so huge?
  9. Delete post revisions only for a single post
  10. Restore woocommerce orders
  11. How to select particular month post from table and update the post status using MySQL?
  12. Bulk find & replace on WordPress posts/pages (minus image paths)
  13. Clean up customize_changeset in DB
  14. SQL trigger failes with post_content
  15. Converting Posts to Pages
  16. How to change the publishing date of each posts?
  17. Where is the old post permalink slug stored?
  18. MySQL Query to Retrieve Category from wp_posts
  19. How to Group Posts by the First Letter or Number?
  20. How are terms connected with posts in database?
  21. Moving WordPress to new server: no posts found
  22. Search & Remove Specific Shortcode From All Posts
  23. Manually delete post from database
  24. how to enable different number of revisions for different blogs when using WPMU?
  25. How to force update all posts after import
  26. Custom Taxonomies Incorrectly Counting Revisions?
  27. Sanitizing `wp_editor();` Values for Database, Edit, and Display
  28. Insert posts in two tables
  29. Instead of submiting an entire post, is there any way to submit a lite-post or a simple message?
  30. How to migrate the posts from an old custom legacy blog to a new WordPress website?
  31. Adding a cancel button to edit post screen
  32. Are posts updated or built from revisions + autosaves?
  33. How much of my site can I recover from public_html?
  34. Most recent post from another database
  35. Tags to Post-ID mysql query. Tag Search
  36. What structure should post_content have in the database?
  37. Multiples Empty Posts were created and cannot delete them
  38. How to delete all the content of a wordpress site without deleting the Post and pages?
  39. Extracting post categories
  40. wp_insert_post – duration
  41. How to hide html tags on revision comparison pages?
  42. Get user categories with most posts in it
  43. MySql query to get posts with all meta and terms
  44. Can’t update old posts 3.5.2
  45. Visual (non-HTML) display of post revisions [closed]
  46. Custom order for Mysql array
  47. Copy post to separate database with “add_action(….)”
  48. List authors with the last post title and order by last post date
  49. When open add new post or page WordPress add post with ID=0 continuously [closed]
  50. Anyone know why wordpress converts some html entities to their numeric equivalents?
  51. How to Mysql select a list of posts with meta_values AND all relevant categories?
  52. Order posts alphabetically: how to set order=asc in mysql query?
  53. Display post changelog in post
  54. Delete all drafts?
  55. Is it possible to use WP_Query to only pull posts with attachments?
  56. Get posts and include taxonomy term
  57. Add field to user meta table in database when link is clicked
  58. How safe is it to delete old posts edits to save database space?
  59. wp_posts table extremely large
  60. How to Assign / Move all Deleted post to a category
  61. Saving Post Data in Another Database
  62. Queries take 120+ seconds on my large WordPress site
  63. Database hacked – random posts are modified
  64. How do post IDs work in WordPress?
  65. Get author posts count after excluding a category
  66. Import custom database into wp and keep the post id
  67. why the posts queried from sql is more than those showed on the page?
  68. Moved to a new server, backup was a day old and missing 3 posts, anyway to recover them from old host?
  69. Is there a function to get post info for any publish_status by post ID?
  70. query for filtering published posts?
  71. Your ideas on my though “delete or move all of the posts in a specific category when 3 days are passed”
  72. How Can I Always Display A Particular Post First Using WP_Query?
  73. Help on conditional statement to accompany wp_insert_post function please?
  74. MySQL: Possible to replace all of wp_posts.post_content(id#) via UPDATE + REPLACE + SELECT?
  75. Deleting post tags removes categories
  76. How can I globally italicize list of texts in the UI database or Posts? [closed]
  77. Menu Items disappearing/being empty on save or post edit
  78. Query to fetch custom taxonomy along with post title
  79. Mysql update menu_order problem
  80. Prevent a post with a specific ID from being created
  81. How can I stop ‘in use’ message from intermittently blocking my wp_posts table?
  82. ‘posts’ table should not store the absolute image path
  83. load post data into mysql
  84. More Than 50K Categories and WordPress Admin Panel Stop Showing Categories and Posts
  85. how i show manual data in a post
  86. Maximum number of posts per page before affecting performance?
  87. Surrogate ID for posts, is there an alternative field in the posts table?
  88. get backup file from wordpress database in x days
  89. Expired Post with More Recent Time Stamp?
  90. Extra field in wp_post instead of postmeta
  91. Voting System, database connections?
  92. SQL query to remove first image in all posts
  93. Given two custom post types: Automatically add meta fields from one custom post type to another
  94. Delete junk text from all the post using my sql command
  95. Load posts from external source if not found in database
  96. If meta_key exists then don’t select this post?
  97. What effect can a large wp_post table have on overall site performance?
  98. How to update wp_posts with just the returned comment count from wp_comments (SQL GROUP BY)
  99. How can I merge a several related posts into one post?
  100. Change permalinks in posts via SQL