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