DB Pruner

DB Pruner is the perfect utility to prepare for a Liferay upgrade!

The Liferay upgrade documentation says a best practice is to prune unnecessary data from your database before doing an upgrade. The reason this is a best practice is that the Liferay upgrade processes will typically at least verify but often update all of the records in the database. The more records you have, the longer the upgrade process will take to run. Cleaning out old and/or unnecessary records can shorten your upgrade time.

Although the documentation tells you it is a best practice to prune unused data, they don't tell you how to prune it properly (other than to invoke the Liferay API and never delete in the database directly).

This tool, however, does handle the pruning properly.

The DB Pruning Wizard is a control panel available for Liferay 6.2 CE, Liferay 6.2 EE, Liferay 7.0 CE, Liferay 7.0 DXP, Liferay 7.1 CE and Liferay 7.1 DXP which can prune data correctly. The following data can be pruned using the wizard:

Relevant configuration overrides can be done in the portal-ext.properties file per instructions on the wizard pages for the data to prune.

The DB Pruning Wizard can also be used to regularly reduce the database size by purging cruft from the database.

All DB pruning activities must be approved before changes are made to the database, and each area can skipped entirely.

So get this tool today and shrink your database to shorten your upgrade time!