look at the size of my wordpress database tables:
are there simple ways to optimize it? I fear of running out of memory one day
maybe bad collation? how can I analyze what is eating up so much space in the posts and post meta tables?
5
-
Take a look into WP-Sweep plugin. This will probably cut your database by half!– JohanssonCommented May 2, 2017 at 0:30
-
4don't see anything "huge" there.– Mark KaplunCommented May 2, 2017 at 4:52
-
.... you obviously should not store stats in the same DB, or even the same server, but that is not related to the size of the DB– Mark KaplunCommented May 2, 2017 at 4:55
-
2You post tables are actually rather small, also the options table. I don't think there is any problem with that.– fuxia ♦Commented May 2, 2017 at 6:33
-
Yep, I agree – that's quite small– Julian F. WeinertCommented May 3, 2017 at 0:07
Add a comment
|
2 Answers
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
The thing i do for this to minimize and optimize the database is by adding a two line of code on config.php
define('AUTOSAVE_INTERVAL', 300 ); //seconds (default is 60)
define('WP_POST_REVISIONS', 5 ); //alter number of post revisions kept.
- the constant ‘AUTOSAVE_INTERVAL’ represents the delay between the two autosaves in seconds.
- the constant ‘WP_POST_REVISIONS’ a record of each saved draft or published update.
you can also use wp-optimize plugin to optimize your Database and cleaning your WordPress database so that it runs at maximum efficiency.
