Reporter.sql taking up a lot of disk space due to old Flow Forensics reports

book

Article ID: 207961

calendar_today

Updated On:

Products

CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

Hello, Our reporter DB has doubled in size (~ 4 GB to ~ 8 GB) after we deleted several devices (~100). This happened in mid December with no other changes to the system (versions etc. constant).  Is there an option to compress or to cleanup it up? DB in question is:   

mysqldump --routines --events -u root reporter --skip-lock-tables > reporter.sql

 

Cause

Years worth of old Flow Forensics reports were taking up disk space

Environment

Release : ANY

Component : NQRPTA - REPORTERANALYZER

Resolution

Run a CARE file and look at the database information included in it. The "RA_TableStatus.txt" included in the CARE file will show information on the size of each table in the Reporter database. Specifically, the "Rows" column will show which tables are taking up the most rows.

Looking in the CARE file, we could see that the largest tables were flow forsenics tables:

flowforensicsreport_instance_*

The output of the "RA_flowforensicsreport_definitions.txt" tells us which instance number corresponds to which Flow Forensics report name. Using this information, we can log on to the NFA Console GUI and delete the old Flow Forensics reports that are taking up the most space.