By mediafrenzy on

Hey everyone, one of my Drupal 4.7 sites has now been running for a couple of years and the database is getting rather large. I'm just wondering what methods I can use to keep it as small as possible, without restricting user activity of course. There are a few thousand user accounts, but less than a hundred active users.

I'm guessing things like some log settings could be changed or switched off to limit database bloat?

Any ideas (or common knowledge) on how to keep Drupal mysql database size under control?

Thanks

⋅ Categories: Drupal 4.7.x

Comments

vm’s picture

vm commented

watchdog logs can bloat the DB. I clear those tables along with cache minimum of every two weeks.

mediafrenzy’s picture

mediafrenzy commented

Ok thanks for the tip. What method do you use to do this?

vm’s picture

vm commented

phpmyadmin