https://connect.hyland.com/t5/alfresco-archive/removing-logs/m-p/243098#M196228 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>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.</SPAN><BR /><SPAN>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. </SPAN><BR /><SPAN>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?</SPAN><BR /><BR /><BR /><SPAN>So my actual questions: </SPAN><BR /><SPAN>Why is the database so big for only 200,000 documents?</SPAN><BR /><SPAN>Is there a way to remove the unnecessary data from the database other than doing this?</SPAN></BODY></HTML> Thu, 28 Oct 2010 09:00:50 GMT zladuric 2010-10-28T09:00:50Z https://connect.hyland.com/t5/alfresco-archive/removing-logs/m-p/243098#M196228 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 beca Thu, 28 Oct 2010 09:00:50 GMT https://connect.hyland.com/t5/alfresco-archive/removing-logs/m-p/243098#M196228 zladuric 2010-10-28T09:00:50Z https://connect.hyland.com/t5/alfresco-archive/removing-logs/m-p/243099#M196229 <HTML><HEAD></HEAD><BODY><SPAN>Your database is that big because mySql is not deleting data, just writing new stuff.</SPAN><BR /><BR /><A href="http://forums.mysql.com/read.php?35,121880,121886" rel="nofollow noopener noreferrer">http://forums.mysql.com/read.php?35,121880,121886</A></BODY></HTML> Thu, 28 Oct 2010 18:37:45 GMT https://connect.hyland.com/t5/alfresco-archive/removing-logs/m-p/243099#M196229 mrogers 2010-10-28T18:37:45Z https://connect.hyland.com/t5/alfresco-archive/removing-logs/m-p/243100#M196230 <HTML><HEAD></HEAD><BODY><SPAN>Thanks for the link.</SPAN><BR /><BR /><SPAN>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.</SPAN></BODY></HTML> Fri, 29 Oct 2010 06:42:50 GMT https://connect.hyland.com/t5/alfresco-archive/removing-logs/m-p/243100#M196230 zladuric 2010-10-29T06:42:50Z