Field Analytics - Database and Storage

Is there a way to easily clear the database to make room for more data?

• Automated cleanup:
  You can configure a rolling purge via Configuration → Software Settings → Data Retention. Set “Days to Retain” to the window you need (e.g. 7 days); any data older than that is deleted on a FIFO ( First-In First-Out) basis automatically.
  
  

• Full reset:
  Please Submit a Ticket to the Analytics Team via CRM if this is 100% necessary.

• FA uses InfluxDB for time-series data and MySQL for configuration.
  
  
•  If disk space is exhausted, new writes will fail, errors will appear in the logs, and no further data will be ingested until you free up space.
  
  
• To prevent this, use retention policies in FA User Interface.

• There’s no built-in “drop values below X” at ingest. However, in the Historian view you can apply Search Filters—including Aggregation Filters (Min, Max, Percentile, etc.) and Data Filtering Functions (Top, Bottom, Distinct, Percentile)—to display only the subset of interest (e.g. anomalies).
  
  
• If you need true ingestion-time filtering, you’d implement that upstream (e.g. in your Node-RED flows or via your API in Dashboard Configuration scripts).

• MySQL database (app metadata & users): in the MySQL Data Folder you configured at install (see Figure 2-7 in User Manual).
  
  

• InfluxDB (historical sensor data): in the Influx DB Data Folder you configured at install (see Figure 2-8 in User Manual) 
  
  To check current usage, simply look at the disk size of those two folders on your server.