Layer 7 API Management

Expand all | Collapse all

Hidden usage of mysql ibdata

Jump to Best Answer
  • 1.  Hidden usage of mysql ibdata

    Posted 01-10-2018 12:38 PM

    Hi All,

     

    I am using mysql provided by CA API Gateway.  I have started observing from recent days size of ibdata file is getting bigger and is currently on 15GB (close to total allocated space).  However I found total tables size are less than 2GB across all schemas.  I am not very sure where 13GB space is used.  Can some one throw some light on this and also on how to clear this space without loosing any policies.

     

    Is there a way to redirect all audit logging to different schema rather than ssg.

     

    Regards

    Chaitanya



  • 2.  Re: Hidden usage of mysql ibdata
    Best Answer

    Posted 01-10-2018 12:50 PM

    Hi

    Here is the article on how to shrink you ibdata files which will free up the space you need.

     

    https://support.ca.com/us/knowledge-base-articles.TEC0000001057.html

    Here are the instructions on how to manage Audit sink

    https://docops.ca.com/ca-api-gateway/8-3/en/configure-security/tasks-menu-security-options/manage-log-audit-sinks/managing-audit-sinks/

     

    Hope this helps

    Thanks

    Abs



  • 3.  Re: Hidden usage of mysql ibdata

    Posted 01-10-2018 03:22 PM

    Along with Abbs sent, you may also find this doc on configuring and installing the audit record maintenance script helpful as well:   https://support.ca.com/us/knowledge-base-articles.tec0000001279.html