topic IMC Database Maintenance or Clean Up script? in IMC

IMC Database Maintenance or Clean Up script?

wrightmt — Mon, 17 Feb 2020 03:22:52 GMT

Is there a maintenance script we can run on the IMC database?

Ours is getting too large and triggering alerts.

Shruthi_L — Mon, 17 Feb 2020 11:59:36 GMT

Hello

Greetings!!

Can you please help explain when you say a script ? When you to clean up the database what exactly you meant?

What is the current requirement of database and which version of IMC is been installed ?

Thanks

Riborg — Sat, 22 Feb 2020 09:48:51 GMT

As I see it this is greatly needed in all IMC installations, some mechanism/script for purging old posts in the database.

In our case MySQL on Linux.

For example, the database "perf_db" is growing out of our hands, several tens of GB's. This impacts the nightly backup as well.

I would like a button in the GUI for each database that says - Purge and delete all posts older than XXX days.