aburton
June 28 2011, 09:09 AM
We keep running into the traverse directory filling up. we keep removing old logs but its now to the point were that doesn't help. It looks like the biggest offender is: /traverse/database/mysql/aggregateddatadb/AggregationDataScheme2.TMD
Is there a better way or an easy way to clean this directory up short of increasing the file system size?
thanks
rajib
July 4 2011, 08:35 AM
Hi Aaron,
A ".TMD" file is created while performing a (MySQL) database repair task and should have been removed automatically after the task was completed. You can safely delete AggregationDataScheme2.TMD file, but we should explore why this file was left behind in the first place.
Typically such a repair task requires 1.5 times available disk space used by the database/mysql/aggregateddatadb directory, but since you have already indicated that there is a shortage of space, I suspect that the previous repair attempt was not successful. One quick way to test this would be:
Log into the Web Application
Navigate to Status -> Devices
Drill down into any device
Locate a test that will exhibit some variation in results (eg. traffic, CPU)
Drill down into the selected test
Click on Long Term History
If you are able to view the historical data on week, month and year charts (all 3), then the historical performance database/tables are in working order. In the event you notice a problem, you will need to repair the DGE database following the instructions outlined in http://community.zyrion.com/showthread.php?t=51.
One other area where you can find some more disk space would be under database/backup, where nightly backups of the configuration and DGE databases are stored. You may consider setting up an additional cron job to move all but the most recent backup to an alternate location.
As Traverse continues to record new events and your monitoring requirements continue to grow, you may find that the space constraints affecting day to day operation. So ultimately you may want to allocate additional space to the partition where Traverse is installed. If you are using Linux, extending the volumn should require some simple steps:
http://tldp.org/HOWTO/LVM-HOWTO/extendlv.html
http://www.howtoforge.com/linux_lvm
http://www.linuxhomenetworking.com/wiki/index.php/Quick_HOWTO_:_Ch27_:_Expanding_Disk_Capacity
As always, we strongly recommend that you create a backup of the Traverse installation directory (after shutting down all components) at an alternate location before performing such maintenance tasks.
Regards - Rajib
Powered by vBulletin® Version 4.1.10 Copyright © 2012 vBulletin Solutions, Inc. All rights reserved.