Need to improve extractdb to truncate new matviews

RESOLVED FIXED in 2.3

Status

Socorro
General
RESOLVED FIXED
7 years ago
7 years ago

People

(Reporter: jberkus, Assigned: jberkus)

Tracking

Firefox Tracking Flags

(Not tracked)

Details

(Whiteboard: [qa-])

(Assignee)

Description

7 years ago
The current extractDB.py script shrinks the old matview tables (top_crashes_by_signature, etc.).  It does not shrink the new ones, though, which will cause miniDB to grow over the next few months.

We need to modify the script to also shorten the new matviews to only keep data from the last X weeks.  It might be good to refactor it to make the shortening of matviews more generic based on a dictionary.
(Assignee)

Comment 1

7 years ago
This is done with the new extractMiniDB.py
(Assignee)

Updated

7 years ago
Status: NEW → RESOLVED
Last Resolved: 7 years ago
Resolution: --- → FIXED
Component: Socorro → General
Product: Webtools → Socorro

Updated

7 years ago
Whiteboard: [qa-]
(Assignee)

Updated

7 years ago
Target Milestone: 2.4 → 2.3
You need to log in before you can comment on or make changes to this bug.