News:

We really need your input in this questionnaire

Main Menu

netXMS server occupied space

Started by fabrizio.alba, April 24, 2023, 11:16:12 AM

Previous topic - Next topic

fabrizio.alba

Good morning.
Anyone can help me understand if there's a way to force netXMS to overwrite logs and saved data after a specific period of time?
Occupied disk space growed up to 100% so easy...
Thank you

Filipp Sudanov

First of all, you can check what exactly tables take the most space in your database, e.g. for MySQL: https://stackoverflow.com/questions/9620198/how-to-get-the-sizes-of-the-tables-of-a-mysql-database

Log retention time is set in Configuration -> Server configuration, search for "RetentionTime" there.
Next housekeeper run after you have changed retention times will delete records according to the new retention time.

But databases typically do not instantly return all freed space to the file system. Depending on the database, you might need to execute some command for data compacting, e.g. VACCUUM for postgres database.

fabrizio.alba