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
Additional Information
See also SFX System Administration Guide > Chapter 6: Server Admin Utility
- Article last edited: 12/27/2013