I'm using domain access sharing the same database for 6 different sub domain websites

My concern my database limit is 1000MB

Is there a way to create new database set to a limit for example every 700MB

What the best way to deal with large database size?

  1. Put your session and cache data in memcache or APC.
  2. Use non-database log backend.
    • Don't store logs to long, if you have to keep them in DB.

If above fails, just change your hosting company or hosting plan, to get bigger limit. Database space is cheap nowadays.

| improve this answer | |
  • Molot will boost module do that thing or not ? – Bala Jul 10 '13 at 8:33
  • 1
    @Bala nope, Boost provides only a HTML copy of your site for faster serving of static content. It does not prevent logs from being created, nor does it prevent sessions - if they happen, they happen, boost or not. It may help a bit with anonymous user sessions if they are initiated on pages that should be static (and are not excluded from cache in Boost config), but that's all. – Mołot Jul 10 '13 at 8:37

I think limit the database to 700MB is not a good idea, instead I would think to split your subdomains in separate Drupal installations.

| improve this answer | |

Your Answer

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