boostpooler is very big

[sonne83]

Good day!

Boostpooler file is very large, can I delete it? According to which algorithm this should be done without loss of system operability?

[TheWitness]

What Cacti version?

[sonne83]

1.2.27

[TheWitness]

Well, you can shrink it this way, you will loose some graph history. You should review how it got so large though

Code: Select all

CREATE TABLE pob LIKE poller_output_boost;
DROP TABLE poller_output_boost;
RENAME table pob TO poller_output_boost;

That series of commands will create an identical but empty table, drop the large table (could take a while), and then rename the empty table to the original name.