Closed Bug 690185 Opened 13 years ago Closed 13 years ago

Need to improve extractdb to truncate new matviews

Categories

(Socorro :: General, task)

Product:
Socorro
Component:
General
Platform:
x86
macOS
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: jberkus, Assigned: jberkus)

Details

(Whiteboard: [qa-]) 

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.
This is done with the new extractMiniDB.py
Status: NEW → RESOLVED
Closed: 13 years ago
Resolution: --- → FIXED
Component: Socorro → General
Product: Webtools → Socorro
Whiteboard: [qa-]
Target Milestone: 2.4 → 2.3
You need to log in before you can comment on or make changes to this bug.