[Treebase-devel] TreeBASE disk space

[William P. <wil...@ya...>]

On Apr 23, 2010, at 6:37 AM, Jon Auman wrote:

> I just exported the tomcat logs to another filesystem. It is recording every single query. One log was 1/2 a GB.  Do we need to record every query, or can I change the logging to only log errors?

Logging only errors seems okay with me. Does anyone else have an opinion?

> Secondly, the database is growing by leaps and bounds. I'm almost out of disk space for that as well. I need to schedule downtime very soon to extend the volume. The db has grown from 50 GB two months ago to over 90GB. Do you antiicipate this trend to continue? Is there junk in there that can be removed?


Yikes. That's weird. I have no reason to believe that the trend won't continue -- it's not as though we recently did something special that won't be repeated. I wonder if trash is collecting somewhere? 

Is there a way to output relative MB disc space used by different tables? If so, could you run it on stage and production (seeing as stage was a snapshot of production a week or two ago)? -- and then we could check out what table is growing out of control. 

thanks,

bp