Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    SFX

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. SFX
    3. Knowledge Articles
    4. Optimize MySQL Tables to Resolve Table Size Issues

    Optimize MySQL Tables to Resolve Table Size Issues

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • 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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • OpenURLs with more than one Author incorrectly display their initials.
      • Order of services in SFX menu
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Content Type
      Knowledge Article
      Language
      English
      Product
      SFX
    2. Tags
      1. 4
      2. contype:kba
      3. Prod:SFX
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved