Maintenance and Tuning:
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 |