Forum Discussion

jamesramsden's avatar
jamesramsden
Icon for Contributor III rankContributor III
2 months ago
Solved

Collector filestore DB size

Since upgrading to 12.2.x We have noticed our collector DB sizes increase quiet dramatically and appears to be down to the filestore storage_system_package table, which contains around 6gb. 

I would assume that anything in the filestore system_package table can now be truncated once deployment have been completed?

  • TonyAndres's avatar
    TonyAndres
    2 months ago

    Hello James,

    Future upgrades will refer to this table to ensure the correct packages are upgraded, so it is not recommended that this table be truncated. Doing so will negatively affect future upgrades.

    Antonio Andres

    Senior Technical Support Engineer | ScienceLogic

  • TonyAndres's avatar
    TonyAndres
    Icon for Moderator rankModerator
    2 months ago

    Hello James,

    Future upgrades will refer to this table to ensure the correct packages are upgraded, so it is not recommended that this table be truncated. Doing so will negatively affect future upgrades.

    Antonio Andres

    Senior Technical Support Engineer | ScienceLogic

  • teppotahkapaa's avatar
    teppotahkapaa
    Icon for Expert rankExpert
    2 months ago

    Hi TonyAndres will it then be so that each update package will be added into collector database, so each update will add some 6GB into database? Or will there only be the last update?

  • TonyAndres's avatar
    TonyAndres
    Icon for Moderator rankModerator
    2 months ago

    Hello Teppo,

    This table can get large, however, assuming that the collector is sized properly per our Collector Sizing guide here System Requirements, this should not cause any issues with space availability. 

    Antonio Andres

    Senior Technical Support Engineer | ScienceLogic