Opened 19 months ago

Closed 13 days ago

#3 closed feature (fixed)

Aggregate and garbage-collect *_log tables.

Reported by: mornfall Owned by: mornfall
Priority: major Milestone: 5.0
Component: bench Keywords:
Cc:

Description

When the log tables grow too much, they become useless anyway. We can add triggers to automatically aggregate the data, down to a few rows per execution. Full data should be available for a couple of weeks after they were collected.

Change History (3)

comment:1 Changed 19 months ago by mornfall

Type: defectfeature

comment:2 Changed 10 months ago by mornfall

Milestone: future5.0

Milestone renamed

comment:3 Changed 13 days ago by blurrymoi

Resolution: fixed
Status: newclosed

The added triggers should do for now, we may want to collect other info from the *_log tables in the future. After update on the 'job' table, the info is collected and any logs older than 2 weeks are removed.

Note: See TracTickets for help on using tickets.