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.




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

    Posted 01-10-2018 12:50 PM


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


    Here are the instructions on how to manage Audit sink


    Hope this helps



  • 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: