Clean Up Data Storage - BloomReach Experience - Open Source CMS

This article covers a Hippo CMS version 12. There's an updated version available that covers our most recent release.

11-10-2017

Clean Up Data Storage

Introduction

Goal

Remove orphaned binary data from the content repository data store.

Use Case

In Hippo Repository binaries larger than a configurable size are stored in a separate database table. Nodes with identical binary properties use the same blob entry in this separate database table in order to save space. However, when these properties are dereferenced, no check is made whether they can be removed from the data store. The Checker tool features a janitor option that finds and removes orphaned binaries from the data store.

Clean Up Binary Data using the Checker Tool

  1. Download and configure the Checker Tool.
  2. Run the data storage clean-up:
    java -jar checker.jar cleands
The InnoDB engine of MySQL never shrinks its files. You need to perform an optimize table operation after running the cleanup tools.
Did you find this page helpful?
How could this documentation serve you better?
On this page
    Did you find this page helpful?
    How could this documentation serve you better?