Examine current state of database table size and growth for our major groups of tables

RESOLVED FIXED

Status

Socorro
Database
RESOLVED FIXED
3 years ago
3 years ago

People

(Reporter: selenamarie, Assigned: selenamarie)

Tracking

Firefox Tracking Flags

(Not tracked)

Details

Things I'm interested in: 

* Size of groups of major tables (reports, reports_clean, raw_crashes, processed_crashes, plugins, signature_summary_* tables)
* Size of our report tables
* Estimate of how much storage we need for a single crash (and rough estimate of growth based on our partitions)
Performed this analysis. 

Here's the per-week breakdown for 2014 Q3/4 utilization of our 6-month retention partitioned tables: 

100-150 GB | processed_crashes
4-10 GB    | raw_crashes
2-5 GB     | reports
300-600MB  | reports_clean
40-50 MB   | plugins_reports 

signature_summary_* tables are overall about 2-5GB per cluster of partitioned tables, so no action needed at this time.

For base tables with processed_crashes, we need ~82 KB per crash.
For base tables without processed_crashes, we need ~8 KB per crash.
Status: NEW → RESOLVED
Last Resolved: 3 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.