How to prune a single ddmdb database file

Products

• Network Observability
• Spectrum

Issue/Introduction

Our disk is full and we need to remove one excessively large database file

Cause

We had an excessive amount of events that overloaded the disk space we had

Resolution

Assume this is the database file that grew excessively and overloaded the environment:

-rw-r-----. 1 spectrum spectrum 2457091009536 Jan  1 00:10 event#p#event_1_1_2025.ibd

 

Log into mysql:

1. cd /usr/Spectrum/mysql/bin/
2. ./mysql --defaults-file=../my-spectrum.cnf -uroot -p<password> -A ddmdb

Issue the below mysql call to PERMANETLY REMOVE ALL EVENTS for that given day

alter table event truncate partition event_1_1_2025;