User story (meta) #2381
Create an administration page to manage the database
| Status: | Released | Start date: | 2012-03-19 | ||
|---|---|---|---|---|---|
| Priority: | 1 | Due date: | |||
| Assignee: |  François ARMAND |
% Done: | 50% |
||
| Category: | Webapp - Administration | ||||
| Target version: | 2.4.0~alpha7 | ||||
| Needs translating: | No |
Description
The growth of the database, filling with reports, raises some performance issue.
On a not so large server (2 GB ram, one core, virtual), it becomes a real issue when the reports database hits the 5M lines
- the number of entry in the database
- the period of entries
- allow to archives entries in another table
And maybe something else (managing postgres parameters ??)
The archive table would be ArchivedRudderSysEvents, and would contains exactly the same field as the RudderSysEvents
Related issues
Associated revisions
Refs #2381 : create an administration page for the database that shows basic informations
Refs #2381 : create a methode to archive reports. Not much validation yet, and it's a bit clunky
Refs #2381 typo on Customlog in apache2-default.conf
Issue #2381: change a println to debug information
Issue #2381: for report archiving, add error message when queries return no tuples
Clarify wording a tiny bit. Refs #2381
History
#1
Updated by Nicolas CHARLES about 1 year ago
- Status changed from Qualified to In progress
- % Done changed from 0 to 50
#2
Updated by Jonathan CLARKE about 1 year ago
- Status changed from In progress to Pending technical review
This has been done and needs reviewing
#3
Updated by François ARMAND 12 months ago
- Status changed from Pending technical review to Pending functional review
- Assignee changed from Nicolas CHARLES to François ARMAND
OK for me !
#4
Updated by Jonathan CLARKE 12 months ago
- Status changed from Pending functional review to Released
This is a great feature to have. It lacks some explanations at the moment, but it's definitely what we wanted.