Project

General

Profile

Actions

User story #2381

closed

Create an administration page to manage the database

Added by Nicolas CHARLES over 12 years ago. Updated over 12 years ago.

Status:
Released
Priority:
1 (highest)
Category:
Web - Maintenance
Target version:
UX impact:
Suggestion strength:
User visibility:
Effort required:
Name check:
Fix check:
Regression:

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 1 (0 open1 closed)

Has duplicate Rudder - User story #2105: Historize (or delete) old reportsRejected2011-11-28Actions
Actions #1

Updated by Nicolas CHARLES over 12 years ago

  • Status changed from 8 to In progress
  • % Done changed from 0 to 50
Actions #2

Updated by Jonathan CLARKE over 12 years ago

  • Status changed from In progress to Pending technical review

This has been done and needs reviewing

Actions #3

Updated by François ARMAND over 12 years ago

  • Status changed from Pending technical review to 10
  • Assignee changed from Nicolas CHARLES to François ARMAND

OK for me !

Actions #4

Updated by Jonathan CLARKE over 12 years ago

  • Status changed from 10 to Released

This is a great feature to have. It lacks some explanations at the moment, but it's definitely what we wanted.

Actions

Also available in: Atom PDF