One thing you can do to help reduce the amount of bloat is add a plugin that controls the number of previous revisions kept for Pages, Posts, etc (preferably one that allows for separate values for each type, such as last 5 revisions for pages and last 20 revisions for posts, or whatever.)
There are numerous plugins that handle this, check around https://wordpress.org/plugins/search/revision+control/ and similar
Related Posts:
- WordPress database scalability from the code perspective
- Performance tips for a large user base [closed]
- WP_Options ID high
- WordPress for a very large website
- Improve or optimize a very slow query
- WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
- Efficiency on displaying random authors based on large database
- How to solve slow WordPress site caused by attachment_metadata
- Relationship between performance and database size
- Database slowdown after update to 3.4.1
- wp_redirection_404 table has grown to 7GB
- Which is more efficient? Using usermeta, or creating a new MySQL table?
- One post carries 30 postmeta values, is this too much?
- Multiple wp_options tables to share content across installs
- Improve performance by removing unnecessary database queries
- fastest replacement DB
- How to prevent/delay MySQL connections when an object cache is used?
- Does auto_load to ‘no’ in wp_options improve performance
- How to combine multiple wp_insert_post into one in order to gain better performance
- Optimizing function that automatically creates internal links based on post title string
- Is there anyway to split posts to different databases?
- Will memcached improve performance with WP Super Cache already running?
- Job and Employee Performance Tracking with Product Safety
- What structure and database storage method should I use for temporary storage that may be written concurrently?
- Get all top categories, then only 3 posts for each
- Best way to store 1 billion+ posts?
- Optimize WP site for millions of posts
- Counting user’s comments – efficient way?
- Performance bug – slow DB query
- Mysql Queries per Visit – Crazy High
- Staging sites, how do you manage synchronising updates in the DB?
- How to get the post publish date outside the loop?
- Using transients in conjunction with memcached
- How to define composite keys with dbDelta()
- Has parent field in the table wp_term_taxonomy has term_id or term_taxonomy_id
- Forcing nickname as display_name in custom edit profile template
- Syncing local content with development / staging sites
- Export WP database for import using WP-CLI on Vagrant Box
- Faulty restore of the database, encoding issue
- Updating all rows of table with $wpdb
- What actions affect files, DB, or both?
- Cannot unserialize WordPress serialized values in `wp_options` table?
- Is $wpdb->prepare escaping to much? How to use it properly?
- Using same database for main and subdomain
- What is stored in the webserver? (Separated Database)
- Remove database entries where post_date > expiration date
- Installation with sql server express edition
- Emojis getting converted to “?”
- Building a Scalable Resiliant WP Setup
- Single database for multiple instances
- Get all tags not just first 10 with wp api 2.0
- Should non-WordPress data get its own DB?
- Search and replace special characters (å,ä,ö) for image attachments only in database
- Accidentally deleted active_plugins portion of the wp_options DB table
- delete post meta from db, even if does not exist?
- In what part of the WordPress core does the users table and usermeta table get joined?
- WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
- Output custom content not from the posts table?
- Reducing Database Query Time
- How can I get my wordpress password from an SQL file?
- Create table from array with prepare
- Migrate database between 2 different wordpress version
- Is there an atomic way to update_option in WordPress (to ensure data integrity)?
- Form that sends data to an admin panel and can export it
- All text disappeared (seems to be a database problem) [closed]
- Convert user passwords to MD5?
- is wordpress stores Role Id in WP database?
- Why do database examples sometimes finish with an add_option call?
- How to backup my site and restore my wordpress site
- How and where is wordpress adding mySQL content to database?
- restore a db after bad backup
- How get Data form wordpress database as array not stdclass?
- cannot connect database
- How to delete a particular row in a database table
- Connecting to wordpress database in my application [closed]
- change the year on all of my custom post types?
- Delete user with only subscriber role
- WordPress keeps redirecting to localhost
- get value from ‘terms’ table
- custom tables in wordpress Database? (can i just create them with sql?)
- How to rename custom table name programatically in wordpress?
- Displaying requested data from a the database in wordpress
- Accidently changed the GUID
- generate PDF from member information
- Is it safe to add INDEX to a column in WordPress database?
- Help posting values to DB on submit using $wpdb->query
- Restore Old Database Over Newer WP & Plugin Files
- How to create index (sql) to a meta_key?
- Not sure what to do next to optimize
- Database structure for thousands of posts
- $wpdb not working
- Accessing content from third party as native posts in WordPress
- Extracted CSV as Array for Custom Query Loop
- One WP Database outside localhost and two connections
- Fetch data from another site, but the same database
- Simple email input store in database
- Every time I update or install a plugin I get “Error Establishing a Database Connection in WordPress”
- Upload wordpress from localhost to 000webhost
- WP Multisite Users Not Linking
- Query a meta key using an array of values where the database value is a string