How To Deal With Datebase Size? 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?
Put your session and cache data in memcache or APC.
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.