Gateway mysqldump having issues with locks on service_metrics

Products

• CA API Gateway

Issue/Introduction

We are experiencing  lots of locks and problems with service_metrics table in ssg db. How do we remove this data and start fresh?

Environment

Release :

Component :

Resolution

To truncate service metrics:

# mysql ssg

mysql> SET FOREIGN_KEY_CHECKS = 0;

mysql> truncate table service_metrics_details;

mysql> truncate table service_metrics;

mysql> SET FOREIGN_KEY_CHECKS = 1;

mysql> analyze table service_metrics_details;

mysql> analyze table service_metrics;

 

Then mysql database dump

# mysqldump ssg > /tmp/ssgdb08312022.sql