NetXMS Support Forum

English Support => General Support => Topic started by: fabrizio.alba on April 24, 2023, 11:16:12 AM

Title: netXMS server occupied space
Post by: fabrizio.alba on April 24, 2023, 11:16:12 AM
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
Title: Re: netXMS server occupied space
Post by: Filipp Sudanov on April 25, 2023, 01:39:51 PM
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.
Title: Re: netXMS server occupied space
Post by: fabrizio.alba on April 26, 2023, 10:47:22 AM
Thank you so much...