Optimize MySQL Tables to Resolve Table Size Issues

• Article Type: General
• Product: SFX
• Product Version: 4

Desired Outcome Goal:
Update the MySQL table size in cases where the size was not automatically adjusted after records have been moved to archive or offline

Procedure:
1. Log in to the Server using the relevant instance user
2. Access the Server Admin Util
3. Type ‘4’ for Database maintenance
4. Type ‘5’ for OPTIMIZE MySQL tables
5. Press Enter to choose all tables
6. Type ‘Y’ to continue