If your analytics cluster is on 22.1.x (and it's been 90 days since the upgrade), the below information is relevant
Below script will truncate all the old tables, which are no longer used in 22.1.x (which has data older than Feb 2023). Dropping these old tables will free up any data held by these tables, while also ensuring that you would have access to all the data post
upgrade (within retention period)
This is useful while freeing up disk space, in case your analytics was subject to PR 93450, causing data older than retention period to be retained while you were on 21.2.x
#!/bin/bash
TABLES="tenantSrcFacts tenantDestFacts sdwanSite2SiteUsage_1 sdwanTcpAppPerfFacts sdwanSiteRuleUsage sdwanAppSubscriber sdwanSite2SiteSlam_1 sdwanSite2SiteSlaPathStatus tenantappfacts tenanturlcatfacts sdwanAppFacts_1 sdwanVRFUsage_1 tenanturlrepfacts tenantrulefacts
tenantfwdclassfacts tenantzonefacts tenantsvcfacts sdwanWanUsage sdwanSiteUsage sdwanAccCktCos_1 sdwanSite2SiteSlaViolation sdwan_site_dia_rule_usage sdwanSite2SiteRuleUsage sdwanSite2SiteMos sdwanAccCktMos sdwanTraffCond sdwan_site2site_traffcond sdwan_site2site_traffcond
intfUtil sdwanAccCktBw system_lte alarm_facts secacc_global_stats"
for table in $TABLES; do cqlsh -u cassandra -p cassandra -e "TRUNCATE van_analytics.${table}" ; done
Procedure is as below
-
Capture the output of "nodetool status" on one of the Analytic nodes (one of the older ones)
-
Create the truncate-script.sh and set permissions (chmod a+x truncate-script.sh) as mentioned above
-
Execute the script
-
Execute "sudo nodetool clearsnapshot"
-
Check "nodetool status" again to confirm if the load has cleared up
Details of PR 93450 can be found below