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
- Download and configure the Checker Tool.
- Run the data storage clean-up:
java -jar hippo-addon-checker-<version>.jar cleands
The InnoDB engine of MySQL never shrinks its files. You need to perform an optimize table operation after running the cleanup tools.