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.
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
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