Validate your database to ensure that it meets the prerequisites for an Alfresco Community Edition installation.
Note: We are unable to provide specialized support for maintaining or tuning your relational
database. You MUST have an experienced, certified DBA on staff to support your
installation(s). Typically this is not a full time role once the database is configured and
tuned and automated maintenance processes are in place. However an experienced, certified
DBA is required to get to this point.
Maintenance and Tuning:
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 Alfresco Community Edition 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 (Alfresco Community Edition cannot
use a MyISAM database and hence an InnoDB-experienced MySQL DBA is required). Refer to the following link: https://dev.mysql.com/doc/refman/5.6/en/analyze-table.html. |
| PostgreSQL | VACUUM and ANALYZE – consult with an experienced, certified PostgreSQL DBA.
Refer to the following link: https://www.postgresql.org/docs/10/maintenance.html. |
| Oracle | Depends on version – consult with an experienced, certified Oracle DBA. Refer to the following link: https://docs.oracle.com/cd/B19306_01/server.102/b14211/stats.htm#g49431. |
| Microsoft SQL Server | ALTER INDEX
REBUILD
(Transact-SQL) UPDATE STATISTICS (Transact-SQL) Consult with an experienced, certified MS SQL Server DBA |