User story (meta) #2381

Create an administration page to manage the database

Added by Nicolas CHARLES almost 3 years ago. Updated over 2 years ago.

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

We need to create an administration page that would show :
  • 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

duplicated by Rudder - User story (meta) #2105: Historize (or delete) old reports Rejected 2011-11-28

Associated revisions

Revision 90acf835
Added by Nicolas CHARLES almost 3 years ago

Refs #2381 : create an administration page for the database that shows basic informations

Revision f7749239
Added by Nicolas CHARLES almost 3 years ago

Refs #2381 : create a methode to archive reports. Not much validation yet, and it's a bit clunky

Revision c8baa092
Added by Nicolas PERRON almost 3 years ago

Refs #2381 typo on Customlog in apache2-default.conf

Revision 23d0fce5
Added by François ARMAND over 2 years ago

Issue #2381: change a println to debug information

Revision 302be92d
Added by François ARMAND over 2 years ago

Issue #2381: for report archiving, add error message when queries return no tuples

Revision 14cef2a7
Added by Jonathan CLARKE over 2 years ago

Clarify wording a tiny bit. Refs #2381

History

#1 Updated by Nicolas CHARLES almost 3 years ago

  • Status changed from Qualified to In progress
  • % Done changed from 0 to 50

#2 Updated by Jonathan CLARKE over 2 years ago

  • Status changed from In progress to Pending technical review

This has been done and needs reviewing

#3 Updated by François ARMAND over 2 years 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 over 2 years 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.

Also available in: Atom PDF