We are experiencing lots of locks and problems with service_metrics table in ssg db. How do we remove this data and start fresh?
Release :
Component :
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