2

look at the size of my wordpress database tables:

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?

  • Take a look into WP-Sweep plugin. This will probably cut your database by half! – Jack Johansson May 2 '17 at 0:30
  • 4
    don't see anything "huge" there. – Mark Kaplun May 2 '17 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 Kaplun May 2 '17 at 4:55
  • 2
    You post tables are actually rather small, also the options table. I don't think there is any problem with that. – fuxia May 2 '17 at 6:33
  • Yep, I agree – that's quite small – Julian F. Weinert May 3 '17 at 0:07
2

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

1

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.