Maintenance and Tuning - Alfresco Content Services - 23.4 - 23.4 - Ready - Alfresco - external

Alfresco Content Services
Platform
Alfresco
Product
Alfresco Content Services
Release
23.4
License

As with any application that uses a relational database, regular maintenance and tuning of the database and schema is necessary. Specifically, all of the database servers that Content Services supports require a minimum level of index statistics maintenance at frequent, regular intervals. Unless your DBA suggests otherwise, Alfresco recommends daily maintenance.

Note: Relying on your database’s automated statistics gathering mechanism might not be optimal – consult an experienced, certified DBA for your database to confirm this.
Note: Index maintenance on most databases is an expensive, and in some cases, blocking operation that can severely impact performance while in progress. Consult your experienced, certified DBA regarding best practices for scheduling these operations in your database.

The following table describes example commands for specific databases. These commands are for illustration only. You must validate the commands required for your environment with your DBA.

Database Example maintenance commands
MySQL ANALYZE.

Consult with an experienced, certified MySQL DBA who has InnoDB experience (Content Services can’t use a MyISAM database and hence an InnoDB-experienced MySQL DBA is required).
PostgreSQL VACUUM and ANALYZE

Consult with an experienced, certified PostgreSQL DBA.
Oracle

Consult with an experienced, certified Oracle DBA.
Microsoft SQL Server ALTER INDEX REBUILD

UPDATE STATISTICS

Consult with an experienced, certified MS SQL Server DBA.