Question

database cleanup

  • 19 April 2023
  • 0 replies
  • 59 views

Userlevel 1
Badge +7

I ran this command to remove old metrics

find /var/lib/centreon/metrics -type f -name '*.rrd' -mtime +90 -delete

and I would like to know if is safe to perform this query directly 

DELETE FROM data_bin WHERE id_metric NOT IN (SELECT metric_id FROM metrics)

 


0 replies

Be the first to reply!

Reply