Removing logs

[zladuric]

Hello,

We have an installation of alfresco with ~200,000 documents in it. Now, over the time, our database has grown, so now it's really huge - the ibdata file is 11GB big! We had to do an upgrade recently, but all the data came along - the database is still that big.
I've been told that this may because we didn't "truncate the logs" or something like that. And I've been suggested that I create a "blank" database and data, and do an export-import procedure about the documents.
While this is acceptable, I'm not sure if this is a long term solution. Will I have to do that every year? What if our needs scale up, we'll have to copy over the data every month or what?


So my actual questions:
Why is the database so big for only 200,000 documents?
Is there a way to remove the unnecessary data from the database other than doing this?

[mrogers]

Your database is that big because mySql is not deleting data, just writing new stuff.

http://forums.mysql.com/read.php?35,121880,121886

[zladuric]

Thanks for the link.

On the other hand, I've been doing dump and reload on a completely blank mysql server, it didn't shrink much. I'll have to go out and check what else I can do.