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 Content Services cannot use a MyISAM database and hence an InnoDB-experienced MySQL DBA is required). Refer to the following link: http://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: http://www.postgresql.org/docs/8.4/static/maintenance.html.|
|Oracle||Depends on version – consult with an experienced, certified Oracle DBA. Refer to the following link: http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/stats.htm#PFGRF003.|
|Microsoft SQL Server||ALTER INDEX REBUILD (http://technet.microsoft.com/en-‐us/library/ms188388.aspx), UPDATE STATISTICS (http://technet.microsoft.com/en-‐us/library/ms187348.aspx) – consult with an experienced, certified MS SQL Server DBA|