How clear old collected DCI Data??

[radw]

Hello, how can I clear collected DCI Data for free db and hd space??. I tried deleting DCIs ( and even entire nodes with their DCIs ), but hd space dont decrease.

Regards.

[Tursiops]

That will depend on the database you use, but usually the actual disk space usage won't decrease.
Even if something is deleted from the database, the database file size itself will generally remain the same.

For Postgres, a VACUUM FULL will do what you are looking for, but it will lock tables while processing them.
For MySQL you may have to dump the data and re-import. It's been a while.

[radw]

Hello, my db is mysql, and yes, I found out that the disk space didnt decrease when I purged all the db in my first NetXMS installation.

For its, in my new NetXMS installation, I was careful of configure the DCI data storage only for DCIs, not for entire tables. However , I still have the doubt why the disk space dont decrease.

Regards.

[Tursiops]

Hi,

Just found a previous post regarding MySQL database size and shrinking the file size:
https://www.netxms.org/forum/general-support/mysql-db-fast-grow-how-to-free-space/

It includes a link that may help. Another link that may be helpful:
http://www.thegeekstuff.com/2016/02/mysql-innodb-file-per-table/

This is not a NetXMS specific issue, it is simply how the database software itself (in your case MySQL, presumably using InnoDB) operates.

Hope the links help.