Closed Bug 1117923 Opened 9 years ago Closed 9 years ago

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

Categories

(Socorro :: Database, task)

Product:
Socorro
Component:
Database
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: selenamarie, Assigned: selenamarie)

References

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
Closed: 9 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.