[tor-bugs] #4673 [Metrics Website]: Partition the 67, 000, 000 row statusentry table in the metrics database

[Tor Bug Tracker & Wiki]

#4673: Partition the 67,000,000 row statusentry table in the metrics database
-----------------------------+----------------------------------------------
 Reporter:  karsten          |          Owner:  karsten
     Type:  enhancement      |         Status:  new    
 Priority:  major            |      Milestone:         
Component:  Metrics Website  |        Version:         
 Keywords:                   |         Parent:         
   Points:                   |   Actualpoints:         
-----------------------------+----------------------------------------------

Comment(by karsten):

 Sebastian and I worked on partitioning the statusentry table on
 Sebastian's laptop and external hard drive.  The changes to the SQL schema
 is in the [https://gitweb.torproject.org/karsten/metrics-
 web.git/commitdiff/87722e25db2065d2c0e2b33849959df64aa2db02 statusentry
 branch of my public repository].  The migration notes are attached to this
 ticket.

 The next step will be to finish the migration on Sebastian's laptop and do
 a lot more performance testing on it.  And then we do the same thing on
 yatei!

-- 
Ticket URL: <https://trac.torproject.org/projects/tor/ticket/4673#comment:1>
Tor Bug Tracker & Wiki <https://trac.torproject.org/>
The Tor Project: anonymity online