Error in ssg logs that say audit database is fulll even after run audit_purge script

Products

• CA API Gateway

Issue/Introduction

In CA API Gateway version 10.1, get an error in the ssg log that said "The Audit Database is full".   We have run the audit_purge.sh script and it deleted a lot of records.  After a ssg restart, the ssg logs still has the same error. 

Environment

Release : 10.1

Cause

Audit table stats have not been updated. 

Resolution

Run mysql commands: 

analyze table ssg.audit_admin;
analyze table ssg.audit_detail;
analyze table ssg.audit_detail_params;
analyze table ssg.audit_main;
analyze table ssg.audit_message;
analyze table ssg.audit_system;