Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    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

    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