Opened 10 years ago

Closed 10 years ago

#1844 closed task (implemented)

Implement consensus and descriptor stats as materialized views

Reported by: karsten Owned by: karsten
Priority: Medium Milestone:
Component: Metrics/CollecTor Version:
Severity: Keywords:
Cc: kjbbb Actual Points:
Parent ID: Points:
Reviewer: Sponsor:


Kevin has been working on implementing statistics based on network status consensuses and server descriptors as materialized views in the database. These statistics include number of relays, relay versions, relay platforms, and advertised bandwidth. The motivation is to have the database as single interface between metrics-db and metrics-web.

So far, we have Java and huge temporary files to generate consensus and descriptor stats. The database schema changes that Kevin implemented will maintain tables with the required statistics data. Updates to these tables will be triggered after importing new data every hour. Querying the tables will be very efficient.

As discussed on #tor-dev today, we are going to merge Kevin's code into metrics-db soon. This ticket will be used to keep all discussion about merging the code in a single place.

Child Tickets

Change History (1)

comment:1 Changed 10 years ago by karsten

Resolution: implemented
Status: newclosed

Merged in 9f328ce854411cbc10c38f2b4c1433193a32662b. Thanks! Closing.

Note: See TracTickets for help on using tickets.