By runeveryday on

my drupal database size is too large(400MB), how to make it small, the mainly lage table are cache_filter(9MB),cache_form(61.5MB),cache_page(37.5MB),search_index(55MB),seach_total(12.2MB),sear_dataset(10.3MB),node_revision(9mb). any tips would be appreciated.

⋅ Categories: Drupal 6.x

Comments

narayanis’s picture

narayanis commented

Revision Deletion to mass delete old revisions - http://drupal.org/project/revision_deletion
Perhaps you can use Boost to keep the cache tables to a small size - http://drupal.org/project/boost

mcfilms’s picture

mcfilms commented

Do you have the Admin Menu module installed? What if you use the "Flush all caches" command from there?

A list of some of the Drupal sites I have designed and/or developed can be viewed at motioncity.com

runeveryday’s picture

runeveryday commented

thanks for you replies! is there a simplae way to optimize the database?

narayanis’s picture

narayanis commented

If you are looking for speed, check out the Pressflow distribution of Drupal; it's 100% compatible and is a pretty simple drop-in replacement.

narayanis’s picture

narayanis commented

Another option that will help performance (though it won't make the database smaller) is the DB Tuner module: http://drupal.org/project/dbtuner.